Re: new posts to an old issue

yls177 wrote:

> http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=3f927ab3%240%243699%24afc38c87%40news.optusnet.com.au&rnum=8&prev=/groups%3Fq%3Dyls177%2Bgroup:comp.databases.oracle.server%26hl%3Den%26lr%3D%26ie%3DUTF-8%26group%3Dcomp.databases.oracle.server%26scoring%3Dd
>
>
> hi, from the above... i cant post to that again. so have to link these
> two together...
>
> basically... its like this
>
> recently.. my colleagues have come up with 2 shutdown procedures and
> are as belows
>
> 1)
> alter system switch logfile
> alter system checkpoint
> shutdown abort
> startup restrict
> shutdown immediate
>
>
> 2)
> alter system switch logfile
> alter system checkpoint
> shutdown immediate
>
> are there any major differences between them?
>
> we noticed that (1) shutdowns much faster than (2).. this is because
> of the abort statement?

Of course there are major differences. Do they matter is more to the point.

The first question that comes to mind reading your first option is what is your expectation with respect to users that are logged on and/or jobs that are running.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)