What kind of shutdown are you doing (immediate or normal). If the
former, there may be a lot of transactions to rollback, how often/
when was your last log switch? If the latter, somebody hasn't logged
off. Normal waits for all transaction to complete.
-Original Message-
Sent:
Try shutdown abort, takes about 2 seconds...works for me (ROFLOL)
If you are doing a shutdown or shutdown normal (same things) then
Oracle waits for all sessions to disconnect, flushes everything, and
checkpoints the database, could be a long wait.
If you are doing a shutdown immediate then
Hi,
Set event 10400 to turn on system state dumps for shutdown debugging to see what is
happening. I guess, SMON is
cleaning up your temporary segments.
regards...
[EMAIL PROTECTED] wrote:
Try shutdown abort, takes about 2 seconds...works for me (ROFLOL)
If you are doing a shutdown or
I am guessing you might have a lot of sort segments that Oracle
may be releasing. It does this on shutdown. Check to see what
kind of sorts are happening on disk. I am assuming you are
using a tablespace of type temporary. Then, if you are having
sorts occur on disk ensure that your extent