Re: "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?
Date: 1997/05/06
Message-ID: <01bc59fe$8afc7f60$2d22ea9e_at_UKP01436.logica.co.uk>#1/1
[SNIPPAGE]
> Thanks a lot.
>
> Paul.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Can anyone comment whether the following script would result in something near a shutdown immediate?
alter system flush shared pool;
alter system checkpoint;
alter system switch logfiles;
shutdown abort
startup restrict
shutdown
???
[Quoted] Also, as I understand it, shutting down the Oracle services under NT is
equivalent of a shutdown abort. Can anyone confirm?
NB: The lack of a shudown immediate command which times out after a configurable number of seconds is what leads to the use of shutdown abort anyway! Also, I've occaisionally found that an 'alter system kill session' is not always effective.
-- Miles Thomas Logica UK Ltd thomasm "at" logica "dot" com The above are personal opinions, and are not necessarily the opinions of my employer.Received on Tue May 06 1997 - 00:00:00 CEST