Home -> Usenet -> comp.databases.oracle -> How may idle user sessions be killed prior to a shutdown?

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

From: Mitchell A. Slater <mas_at_bailey.com>
Date: 1995/04/07
Message-ID: <D6oGH1.FLC_at_bailey.com>#1/1 






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












Original text of this message