Re: shutdown took a long time!

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Wed, 06 Mar 2002 17:06:08 GMT
Message-ID: <40sh8.18061$gK2.1349807@bgtnsc04-news.ops.worldnet.att.net>

Um, Y. SHUTDOWN IMMEDIATE prevents new logons, allows pending operations to finish, then logs out those sessions, and finally shuts the DB down.

So for example rolling back or forward is completed, etc. and the DB is closed in a consistent state. If you have a table like NJ_RESIDENTS and someone was in sqlplus and just entered:

update tax_code to 'Z' where zip_code in (08083, 08034, 08035); and hit enter

well that'd hold up your shutdown a bit....

RSH. PS: DONT DO shutdown abort because of things like this!

"y" <y_at_y.y> wrote in message news:3C859BF0.4A41A9DB_at_y.y...
> Hi,
> Today, when I shutdown my oracle instance/database, it took me a long
> time.
>
> I would like to know where I should check besides alert log ?
>
> Thanks for any help!
>
Received on Wed Mar 06 2002 - 11:06:08 CST