Re: DATABASE HANGS WITH SHUTDOWN IMMEDIATE
- From: Tom Fox <tom@xxxxxxxxx>
- To: Ahmed Ullah <ahmed107@xxxxxxxxx>
- Date: Fri, 28 Apr 2006 07:22:35 -0400 (EDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
