David,
One
likely culprit is the need to rollback a long-running transaction that did not
complete before shutdown.
You
can avoid this wait on shutdown with abort, but then it will still need to
process the rollback on startup.
You
did not mention the type of shutdown that you issued: normal, transactional,
immediate, abort. Each one has potential to add more necessary events
before shutdown will complete. The alert log is a good place to start
looking when this occurs.
-Ron-
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nguyen, David M
Sent: Tuesday, February 25, 2003 7:44 PM
To: Multiple recipients of list ORACLE-L
Subject: It takes too long to shutdown databaseI try to bounce database by shutting it down and starting it back up but it just hang in there for almost 45 minutes trying to shut down. It is running on Solaris8, I can press Ctrl+C to interrupt it or issue a kill command to kill it but I hesitate to do so. Do you have any advices and why it takes too long to shutdown database? It usually only takes me about 3 minutes to bounce database.
Thanks,
David
