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.