Slow performance with connections that go idle for longer periods of time and are using older style DCD.
(Doc ID 2832915.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Net Services - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Requires idle connection.
Reproduces from 12.1.0.2 till 19.12 where the fix is included.
Requires USE_NS_PROBES_FOR_DCD=TRUE to be set in the server side SQLNET.ORA file
Symptoms
Issue typically presents as a slow performing or hang on a pre existing connection.
Issue initially reported as a connection waiting 10 minutes to continue after having been idle for 24 hours.
The connection and tracing will indicate that a large idle time was spent before the hang takes place.
The other major requirement is DCD being turned on and the USE_NS_PROBES_FOR_DCD to be set to true on the database side SQLNET.ORA file.
Changes
Begins in 12.1 and fixed in 19.12
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |