Well, keep in mind that if you issue a shutdown immediate, Oracle will have
to rollback the transactions, clean up temp segments, and that sort of
thing. This can take time if there is much activity on the database when
you try to do the shutdown immediate. What most people recommend is to do a
checkpoint, shutdown abort, startup restrict, shutdown immediate.
>From: "Heidi E. Schmidt" <heidi_at_cybercom.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Shutdown immediate - not quite as immedaite as I want it to be
>Date: Thu, 25 May 2000 05:57:59 -0800
>
>
> > I have some other problem though, in which I would like your advise.
> > Sometime there are still procedures running when the batch kicks in and
> > tries to do a shutdown immediate. Most of the time, the proces still
>running
> > get's killed and the database is shut down. However, in some cases this
>does
> > not happen, and the procedure just keeps running.
>
>Kirsten,
>
>I have found that if I shutdown the listener, run a kill session dynamic
>script that doesn't include oracle, sys, or system I have gotten just
>about everything dealt with before I execute a shutdown immediate.
>
>If you find something that involves less steps, please let me know. It'd
>be great to find out too.
>
>Thanks,
>
> Heidi :)
>
>--
>Author: Heidi E. Schmidt
> INET: heidi_at_cybercom.net
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
Received on Thu May 25 2000 - 10:07:39 CDT
