Re: How may idle user sessions be killed prior to a shutdown?

A shutdown immediate will rollback any transactions very nicely and neatly, so I don't see any reason you need to kill sessions first. We don't, and see no problems from same.

mas_at_bailey.com (Mitchell A. Slater) wrote:

>I would like to kill all inactive user sessions in my database prior
>to a shutdown for backup purposes. Alter system kill session
>indeed kills the session BUT a shutdown normal still waits until
>something happens on the user side before issuing the Session killed
>message to the user. I.e, the user has his session killed, but is not
>officially disconnected until something happens on the client side.
>This means that if the session is simply idle with no user physically
>present, that will not happen and the database will not shutdown.
 

>As an alternate, I've examined doing kill sessions followed by shutdown
>immediate which seems to do the trick. But I am wondering if just doing
>a shutdown immediate would yield the same effect? Does the kill session
>prior to the shutdown immediate buy me any additional graceful rollback
>and protection of the idle users' data?
 

>How are others handling this situation?
 

>I am running Oracle 7.0/7.1 with SQL*Net V.2 under Solaris 2.3 on a Sun
>Sparc 10.
Received on Fri Apr 07 1995 - 00:00:00 CEST