RE: It takes too long to shutdown database

From: Ron Yount <ronwy_at_swbell.net>
Date: Tue, 25 Feb 2003 18:53:40 -0800
Message-ID: <F001.005597AA.20030225185340@fatcity.com>

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-----

David
M
Sent: Tuesday, February 25, 2003 7:44 PM To: Multiple recipients of list ORACLE-L

I 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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ron Yount
  INET: ronwy_at_swbell.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 25 2003 - 20:53:40 CST