Re: shutdown immediate

No longer entirely true:

    shutdown immediate has to rollback every single     current transaction one after the other.

    At startup after an abort (7.3 and above I think) there     is code to delay recovery so that transactions are only     recovered as a new transaction hits a block needing     recovery. At 8.1 (I think) this is improved further in that     the block hit is recovered by the process that wants the     block and the rest of the blocks in the transaction are     handed off to smon.

One possibility for the 'immediate shutdown takes a long time' may be the use of a proper TEMPORARY tablespace. As the instance closes, the instance's 'permanent temporary segment' is released. In version 7.3.3 it is coalesced as the instance restarts, but possibly you have a version where it is coalesced at shutdown. If so, and if the segment has a VERY LARGE number of extents (e.g. 5,000) it could take a very long time to coalesce.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Bass Chorng wrote in message <7ktndf$dal$1_at_news.eng.octel.com>...
>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.
Received on Thu Jun 24 1999 - 16:22:12 CDT