Re: Slow Database Shutdown Time

May be those connected session doing some transactions need to be rollback....

Try shutdown abort :) jokin

• Original Message ----- From: "Marquez, Chris" <cmarquez_at_collegeboard.org> To: <oracle-l_at_freelists.org> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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