Re: DCD (dead connection detection) on Linux
- From: John Hurley <hurleyjohnb@xxxxxxxxx>
- To: "Amir.Hameed@xxxxxxxxx" <Amir.Hameed@xxxxxxxxx>, 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Oct 2013 18:11:05 -0700 (PDT)
Read this first:
Metalink note ID 395505.1 "How to Check if Dead Connection Detection (DCD) is
Enabled in 9i ,10g and 11g"
A fair amount of bugs in this area of the code path from oracle ... might be
some one offs needing installed on 11.2.0.3 ...
________________________________
From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
To: 'ORACLE-L' <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, October 30, 2013 8:50 PM
Subject: DCD (dead connection detection) on Linux
Folks,
RDBMS - 11.2.0.3
Linux - RHEL 6/U4
Oracle E-Business Suite R12
I have noticed that DCD is not working quickly enough in my database even if I
set "SQLNET.EXPIRE_TIME= 1" on the database server. If I crash my Linux host
running the http server while I have connections established to the
application, I can see that dead connections in the database corresponding to
the application connections take somewhere from 12-15 minutes to get cleaned
up. I can see that the TCP keep-alive parameters on Linux are set as shown
below:
cat /proc/sys/net/ipv4/tcp_keepalive_time
7200
cat /proc/sys/net/ipv4/tcp_keepalive_intvl
75
Does anyone know what are all the parameters that need to be set to allow DCD
work within 1-2 minutes?
Thanks,
Amir
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
