Re: DATABASE HANGS WITH SHUTDOWN IMMEDIATE

Ahmed,

Correct me if I'm wrong, but it's not necessarily the size of your database, but the amount of transactions that need to be cleaned up that is causing your long shutdown. Either way, SMON will still need to cleanup and will do this on the next restart.

--Tom

On Thu, 27 Apr 2006, Ahmed Ullah wrote:

> Hi Jared:
>
> Thanks for your reply.
>
> I waited for 30 minutes before issuing shutdown abort. I did try shutdown immediate afte bringing it up twice later ( waited for 15 mins evetyrime ) - no luck as SMON was busy in housekeeping. It is no a big database ( 100GB with 1.2GB SGA ).
>
> -ahmed

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