Re: Slow Database Shutdown Time

Normally this is done with a "startup restrict" to prevent a race condition where the database starts up and a new session starts, messing up your nice clean shutdown immediate. The "startup restrict" prevents non-DBA sessions from connecting, so it's not perfect but it does greatly reduce the likelihood of such an event.

S-

On Wed, 8 Jun 2005, Vasu Balla wrote:

> i usually do
>
> alter system checkpoint;
> shutdown abort
> startup
> shutdown immediate
>
> sometimes i tend to forget checkpoint & abort and directly do shutdown
> immediate. in this case , atleast in 9.2.0.4+ , alert log will list
> PIDs of all active server process that shutdown is waiting on .so=20
> just killing them will get the db down real fast
>
> -vAsu

-- 
Stephen Rospo        Principal Software Architect
Vallent Corporation (formerly Watchmark-Comnitel)
Stephen.Rospo_at_vallent.com           (425)564-8145

This email may contain confidential information. If you received this in
error, please notify the sender immediately by return email and delete this
message and any attachments. Thank you.

--
http://www.freelists.org/webpage/oracle-l