Re: shutdown immediate: make it go faster

Hi Charles

all my database are stopped by this way : shutdown abort
starupt force
and at least
shutdown (normal or immediat)

when the shutdown normal or immediate arrive, oracle is cleaning the temporary segment (i mean all what is in the tempdata, the sort tablespace), if you have a database where sort are important when the shutdown accour then it can take a long time for the shutdown normal to be effective.

I've an NT oarcle database V7.3.3 where i have this "problem".

I've found these explanation on the metalink oracle.

regards

Patrice

"Charles J. Fisher" <cfisher_at_rhadmin.org> wrote in message news:<Pine.LNX.4.44.0211211057170.3082-100000_at_galt.rhadmin.org>...
> "shutdown immediate" takes a long time on some of my databases. I've never
> really known why; disk activity is usually very low throughout the
> shutdown period.
>
> However, if I kill all of the "oracleSID (LOCAL=NO)" processes prior to
> the the shutdown immediate, it goes a lot faster. I assume that this will
> drive PMON nuts, but I don't see any other major risk.
>
> I've killed these processes with:
>
> ps -ef | awk '/oracle.*LOCAL=NO/ && !/awk/ {print "kill "$2}' | sh
>
> Is this something that I should consider doing in non-emergency
> situations?
>
> -----------------------------------------------------------------------------
> | The Moving Finger writes; and, having writ, |
> | Moves on: nor all your Piety nor Wit |
> | Shall lure it back to cancel half a Line, |
> | Nor all your Tears wash out a Word of it. |
> | |
> | -Rubaiyat of Omar Khayyam |
> -----------------------------------------------------------------------------
> / Charles J. Fisher | cfisher@rhadmin.org | http://rhadmin.org /
> -----------------------------------------------------------------------------
Received on Fri Nov 22 2002 - 15:20:10 CST