Re: shutdown immediate

Wanni (wanni_at_mbox2.singnet.com.sg) 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 :)

If shutdown immediate seems to hang, shutdown abort does not make it any better. It will do the rollback when coming up, instead of going down.

However, if you always see hanging at shutdown immediate, there might be a bug.

If you see disk activity at shutdown, I suspect this is a bug though. Check your snapshot, maybe there is a refresh going on.

-Bass Chorng Received on Thu Jun 24 1999 - 11:46:39 CDT