| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shutdown immediate - not quite as immedaite as I want it to
Steve:
But when you do the startup restrict, Oracle will *still* have to roll back the same transactions. I don't see the benefit. Am I missing something?
Colin.
-----Original Message-----
From: Steve Boyd [mailto:pimaco_oracle_at_hotmail.com]
Sent: Thursday, May 25, 2000 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Shutdown immediate - not quite as immedaite as I want it to
be
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).
-- Author: Steve Boyd INET: pimaco_oracle_at_hotmail.com 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 mayReceived on Thu May 25 2000 - 21:39:25 CDT
 |
 |