Re: inactive connection

From: James Williams <willjamu_at_mindspring.com>
Date: Sat, 07 Dec 2002 18:05:02 GMT
Message-ID: <3df237b6.15803952@nntp.mindspring.com>

On Fri, 6 Dec 2002 19:16:00 +0100, "Darksheep's Revenge" <vi_at_cal.it> wrote:
In your sqlnet.ora there is a parm for this.

sqlnet.expire_time= mintues. Check your sqlnet admin guide for the exact syntax. . I think this parms is available in V7.

If set it will send a probe out at the end of the timer pop to kill the thread if it has become a ghost.

>I have a small visualbasic application that work on a DB on Oracle 7.
>When a user shutdown the pc while this application is running without
>closing this application before, the connection with the Oracle instance
>remain inactive, but present (they are present in Istance Manager) .
>In a few time, the number of these "inactive" connection increasly, and
>locks other user to access to the DB Instance .
>There is a batch that help me to monitor and close these connections ?
>Tnx in advance
>
>
Received on Sat Dec 07 2002 - 12:05:02 CST