Re: Active sessions after powerfailer network components

From: <frank.van.bortel_at_gmail.com>
Date: 18 Apr 2006 05:24:44 -0700
Message-ID: <1145363084.163161.176890@u72g2000cwu.googlegroups.com>

belgarion1 schreef:

> Hi,
>
> Recently we have had a lot of active sessions after a powerfailer of
> network components.
> To solve this, i know of these optins :
> kill all "hanging sessions" ( time consuming and you have to stop the
> listener so no one can logon )
> do a shutdown of the database
>
> Are there any other options and can anyone tell what the best option
> is in case of massive hanging sessions
>
> Thanks in advance
>
> The Oracle version is 9.2.0 on a AIX platform.

Set sqlnet.expire_time; it will terminate inactive sessions after expire_time (in minutes) expires. Received on Tue Apr 18 2006 - 07:24:44 CDT