My Oracle Support Banner

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 12.1.0.2 and later
Information 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.