SQL Hangs When Using Database Link
(Doc ID 551117.1)
Last updated on JANUARY 08, 2020
Applies to:Oracle Net Services - Version 184.108.40.206 to 220.127.116.11 [Release 9.2 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.
Certain SQL statement over database link hangs. No error code is shown for the session.A typical example is that a select statement can run with no errors, where as a insert statement fails. Both SQL statement use the same databases and database link.
On server tracing the failure, you may see a error stack similar to the following
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document