Re: inactive connection

Darksheep's Revenge wrote:

> 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

You can monitor connections by selecting from v_$session.

But a far better approach is to alter the default profile, or create a custom profile that logs users off automatically after a specific period of inactivity.

Daniel Morgan Received on Fri Dec 06 2002 - 16:32:37 CST