Page 1 of 1

Enabling Dead Connection Detection ?

Posted: Fri Mar 06, 2009 5:00 am
by syrara
Hello All

pls let mw know how to check if DCD is enabled ?

And if not enabled how do i enable ?

regards

Posted: Thu Mar 26, 2009 11:20 am
by Qurrat-ul-Ann
Hi,
the parameter EXPIRE_TIME parameter in sqlnet.ora file will enable DCD.
SQLNET.EXPIRE_TIME is set in minutes. if the value is set to non zero value DCD(detect dead connections) is enabled. It detects and kills the dead inactive SQLNET session.

If you set the value to "0" , the dead connections will not be detected