Re: shutdown took a long time!

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

Shutdown transactional let's transactions finish - shutdown immediate rollbacks the transactions... if I'm not mistaken

"RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message news:40sh8.18061$gK2.1349807_at_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 - 13:04:32 CST