Re: shutdown immediate

Wanni

Without knowing more of your configuration, it's impossible to say what's happening. Yes it's possible you could be rolling back a huge transaction, but you'd need to monitor exactly where the I/O is occurring before that can be confirmed.

The shutdown abort is cleaned up by instance recovery on next startup, so there's no issues about consistency etc.

HTH. Pete

Wanni wrote:

> HI Readers,
>
> From what I know, shutdown immediate will terminate all current
> transactions and does a 'graceful' shutdown down. But when I
> 'hang' at the shutdown immediate command for sometime, and noticing
> that the disk activity is high, could that mean, it is rollbacking
> some huge huge active transactions in the rollback segments?
>
> We have the shutdown immediate going for about 30mins and it was still
> running. instead, we did a shutdown abort. the next time the database
> was brought up, it was ok.
>
> When we issue shudown immediate again, the same problem persists.
>
> What's the logic explanation here?
>
> Thanks for your replies :)

--

Regards

Pete

Received on Thu Jun 24 1999 - 11:13:57 CDT