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

From: <jpope_at_mojo.europe.dg.com>
Date: 1995/05/05
Message-ID: <1995May5.174445.14249_at_mojo.europe.dg.com>#1/1

Chris Hubble (chubble_at_pcug.org.au) wrote:

: In article <D6oGH1.FLC_at_bailey.com> mas_at_bailey.com (Mitchell A. Slater) writes:


: >From: mas_at_bailey.com (Mitchell A. Slater)

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

: >Keywords: shutdown, kill session
: >Date: Fri, 7 Apr 1995 18:24:36 GMT
 

: >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.
 

: If you are killing off user sessions, you may as well do a shutdown abort!
: This can be followed by startup then shutdown normal to allow necessary 
: rollback.  In my experience this is the usual approach prior to system backups.
 

: Chris Hubble...

If you send a kill -14 to the shadow, it takes an unexpeted timeout, and tidies up nicely, rolling back any work or just dying. Gets rid of the client process as well.

-- 
******************* :-) *******************************************************
Jon Pope email:	jpope_at_mojo.europe.dg.com
European Database Competence Centre Manager
Data General UK Ltd.

Received on Fri May 05 1995 - 00:00:00 CEST