RE: Slow Database Shutdown Time
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: "Powell, Mark D" <mark.powell@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Jun 2005 10:37:46 -0400
Sorry Mark...good question;
Oracle 9203
AIX 5.3
Other DBA's claim that the same app running on;
Oracle 9203
RH Linux 3
shuts down fast *every* time!?
Chris Marquez
Oracle DBA
-----Original Message-----
From: Powell, Mark D [mailto:mark.powell@xxxxxxx]
Sent: Wed 6/8/2005 10:34 AM
To: Marquez, Chris; oracle-l@xxxxxxxxxxxxx
Subject: RE: Slow Database Shutdown Time
And you are shutting down which version of Oracle running on what
platform using what command?
Shutdown immediate is generally the best command to use to stop an
Oracle database
We like to run a kill script immediately prior to issuing the shutdown
due to the fact that there were certain operations that a shutdown
immediate would wait for to complete before terminating the instance.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marquez, Chris
Sent: Wednesday, June 08, 2005 10: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?
Thanks,
Chris Marquez
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
