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;
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.
alter system checkpoint;
alter system switch logfiles;
shutdown abort
startup restrict
shutdown
???
Also, as I understand it, shutting down the Oracle services under NT is
equivalent of a shutdown abort. Can anyone confirm?
-- 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