Re: Slow Database Shutdown Time

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

On 6/8/05, Dennis Williams <oracledba.williams_at_gmail.com> wrote:

> mentions, namely shutdown abort, followed by a startup and a normal
> shutdown. Some sites have had a normal shutdown immediate hang for
> extended periods of time. There were rumors that in earlier versions
> of Oracle there were some issues with shutdown abort, but recent
> Oracle versions don't seem to have that problem.
>=20
> Dennis Williams

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