SEO

#1 (**permalink**) 02-25-2008, 03:48 AM

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.

#2 (**permalink**) 02-25-2008, 03:49 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Active sessions after powerfailer network components