Dead Connection Detection - sqlnet.expire_time
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Dead Connection Detection - sqlnet.expire_time

  1. #1
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.
    Reddy,Sam

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Thanks Shestakov, that helps a lot.
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width