Re: Slow Database Shutdown Time
- From: "Oracle" <all_about_oracle@xxxxxxxxxx>
- To: <cmarquez@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Jun 2005 12:15:04 +0800
May be those connected session doing some transactions need to be
rollback....
Try shutdown abort :) jokin
----- Original Message -----
From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, June 08, 2005 10:18 PM
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:
