Re: shutdown took a long time!

Roman Mirzaitov wrote:

> Hi,
>
> it's possible that you perfom a long transaction and during database
> shutdown it takes a long time to perform rollback.
> It may be inside a job or else...
> This could be a reason.

Thank you Roman!
I think it is not the reason for this time. Before I shutdown, I check the lock-lists. Only some locks for system tables. Then I shutdown, nerver finish.

I have no more experience for this. Would you tell me from where I can know the shutdown was in progress or it maybe hung?

Regards,

>
> Regards,
>
> --
> Roman Mirzaitov
> Brainbench MVP for Oracle Administration
> www.brainbench.com
>
> "y" <y_at_y.y> wrote in message news:3C861CE6.E91C1D7A_at_y.y...
> >
> >
> > Roman Mirzaitov wrote:
> >
> > > > 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!
> > >
> > > Hi,
> > >
> > > which way do you use to shutdown?
> >
> > Hi, Roman,
> > I use immediate. Before shutdown, I close all the applications.
> > Regards,
> >
> > >
> > >
> > > Regards,
> > >
> > > --
> > > Roman Mirzaitov
> > > Brainbench MVP for Oracle Administration
> > > www.brainbench.com
> >
Received on Thu Mar 07 2002 - 08:12:31 CST