Re: Killing disconnected Oracle sessions

From: Sharon Medlock <sharon.medlock_at_daytonoh.ncr.com>
Date: Tue, 21 Mar 1995 15:06:39 GMT
Message-ID: <D5spz3.C58_at_intruder.daytonoh.attgis.com>


There is a feature in our UNIX OS (AT&T-GIS) called "keepalive", which will detect and purge zombie processes. Basically, it checks at intervals to see if the TCP connection is still alive, by pinging both ends. If no response is received after a specified number of checks, it kills the associated process. This also causes the process (and any of its locks) to disappear from Oracle.

One problem is that the default parameters for this feature are never set low enough to be of any real value.

Additionally, although SQL*Net 1.x "enabled" keepalive actions, SQL*Net 2.0 did not. SQL*Net 2.1 is supposed to correct this. Received on Tue Mar 21 1995 - 16:06:39 CET

Original text of this message