Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Slow Database Shutdown Time

Slow Database Shutdown Time

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Wed, 8 Jun 2005 10:18:43 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E0450BC0A@ecogenemld50.Org.Collegeboard.local>


I convinced that my slow "shutdown" time is directly related to the number of connected or live connections (ACTIVE *or* INACTIVE) to the database at the time of shutdown. I can see the correlation to when it "high water mark" is HIGH it takes a long time to shutdown, but when the "high water mark" is LOW, shutdown is quick. In any Oracle database disconnecting hundreds a valid connections takes time...I know this is rather normal.

Anyone know of any other Oracle (network) method or parameter to disconnect sessions faster?

Thanks,

Chris Marquez
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 08 2005 - 10:24:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US