RE: Slow Database Shutdown Time

From: Brian Mullin <bmullin_at_salesforce.com>
Date: Wed, 8 Jun 2005 09:29:38 -0700
Message-ID: <6A7AA073C12C0F41B56DD7B9A16F44B90756F0DC@ex-2.internal.salesforce.com>

Shutdown the listener and forms services ;-)

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marquez, Chris Sent: Wednesday, June 08, 2005 7:19 AM
To: oracle-l_at_freelists.org
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?

Thanks,

Chris Marquez
Oracle DBA

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 08 2005 - 12:34:55 CDT