| Dead Connection Detection [message #145363] |
Wed, 02 November 2005 13:37  |
bnorma01
Messages: 4
Registered: November 2005
|
Junior Member |
|
|
We have Oracle 8.1.7.4.0 on HP-UX 11.11 If I run sqlplus on pc client running xp pro and then disconnect network jack of my pc my oracle session takes 2 1/4 hours to go away on server. We do not have expire_time set in our servers sqlnet.ora file.
What is removing session ?
It always seems to be 2 1/4 hours even when it is my app on a pc server that loses its connection. I just duplicated with sqlplus removing any issues with my app or my odbc connection.
|
|
|
|
| Re: Dead Connection Detection [message #145667 is a reply to message #145363] |
Fri, 04 November 2005 12:53  |
bnorma01
Messages: 4
Registered: November 2005
|
Junior Member |
|
|
Found the answer. HP-UX is seeing the tcp/ip socket and removing it. oracle then removes the connection. The 2 hours is the interval that UNIX checks for inactivity. In HP-UX the ndd parameter is tcp_keepalive_interval which mine is set to 7,200,000 milliseconds which is 2 hours. To view this parm I used the following command:
"ndd -get /dev/tcp tcp_keepalive_interval"
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
