Hello All
pls let mw know how to check if DCD is enabled ?
And if not enabled how do i enable ?
regards
Enabling Dead Connection Detection ?
-
- Posts: 11
- Joined: Thu Jul 26, 2007 8:01 am
- Location: Pakistan
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
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
Who is online
Users browsing this forum: Google Adsense [Bot] and 11 guests