My Oracle Support Banner

How To Track Dead Connection Detection(DCD) Mechanism Without Enabling Any Client/Server Network Tracing (Doc ID 438923.1)

Last updated on MARCH 14, 2024

Applies to:

Oracle Net Services - Version and later
Information in this document applies to any platform.
This may not be applicable to version 12. See the following document: Oracle Net 12c: New Implementation of Dead Connection Detection (DCD)

+ This requires truss/ strace / tusc or any system call trace tool & understanding on the system call functions.
+ The example here is taken from database server on solaris operation system for an dedicated server process

Abbreviation in this note are as follows,

DCD => Dead Connection Detection
DB => Database
PID => Process ID


The goal is check and confirm if DCD functionality or mechanism is
working as expected at the DB server side when you have enabled the
respective sqlnet.expire_time parameter. 

That is to track if the timer is getting expired after specified interval and
DCD sending probe packets being written on to the tcp socket corresponding
to connected database server process for the respective client.

Especially,  without enabling the client and server network traces or
in the case where the client has gone and session at server side is still present.


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

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