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 JANUARY 11, 2022
Applies to:Oracle Net Services - Version 220.127.116.11 and later
Information in this document applies to any platform.
Requires idle connection.
Reproduces from 18.104.22.168 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
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.
Begins in 12.1 and fixed in 19.12
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