RE: Slow Database Shutdown Time

  • From: "Brian Mullin" <bmullin@xxxxxxxxxxxxxx>
  • To: <cmarquez@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 8 Jun 2005 09:29:38 -0700

Shutdown the listener and forms services ;-)

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marquez, Chris
Sent: Wednesday, June 08, 2005 7:19 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Slow Database Shutdown Time

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?


Chris Marquez
Oracle DBA



Other related posts: