Printable View
Anybody have any experiences with DCD. I have enabled the parameter SQLNET.EXPIRE_TIME =10 min and DCD is active (checked it from net8 server trace file) but, it never cleanup the sessions that are killed and have the sever column turned to 'PSEUDO' from DEDICATED.
I made tests of check SQLNET.EXPARE_TIME in RAC invoronment.
This parameter turn on ONLY after network OS(TCP/IP) layer say:
"connection lost".
Some results in different OS:
Linux RH 6.2 (SQLNET.EXPARE_TIME turn on after 45 min.) common
delay time before DOD = 45min + 10min.
Linux RH 7.2 (SQLNET.EXPARE_TIME turn on after 30 min.)
Solaris 8 (SQLNET.EXPARE_TIME turn on after !!! 48 hours.)
U can tune OS/network delay time using system parameter:
tcp_keepalive_time (/proc/sys/net/tcp_keepalive_time)
I set this parameter to 1 min (on client an server boxes) and common period of timeout now is 1min + 10 min = 11 min.
Thanks Shestakov, that helps a lot.