Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?
[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
???
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 CDT