Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: shutdown took a long time!

Re: shutdown took a long time!

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Wed, 06 Mar 2002 19:24:30 GMT
Message-ID: <O1uh8.18208$gK2.1364495@bgtnsc04-news.ops.worldnet.att.net>


Consistent state. A rollback of that transaction would consume immense time. You're right, I think, it does kill the trans and then does rollback, which can be a real pig.

But again the DB is consistent. At best SHUTDOWN ABORT would make you do all that dirt when the DB was started up again.

ABORT is what I use only in an emergency where the next step is turning power off to the computer center.

RSH.
"koert54" <koert54_at_nospam.com> wrote in message news:4Lth8.240109$rt4.23091_at_afrodite.telenet-ops.be...
> > 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:24:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US