Re: sqlplus shutdown "time-out"

From: Vitalis <vitalisman_at_gmail.com>
Date: Wed, 20 Apr 2005 14:59:02 +0200
Message-ID: <68b12855050420055976a04f69@mail.gmail.com>

On 4/19/05, K Gopalakrishnan <kaygopal_at_gmail.com> wrote:
> Hi,

>=20

> I couldn't follow the complete thread. So someone might have already
> posted this info.

>=20

> There is a timeout for shutdown (I think starting from 9iR2) which
> defaults to 60 minus. If the active calls (!) don't complete in that
> time, the instance just updates the alertlog and doesn;t shutdown its
> own. You need to shutdown abort.

>=20
> It is not documented btw :D

Oracle is planning to update the administrator guide about this 1-hour time-out (in the 10.2b3 book apparently.)

That's a real problem when huge rollbacks occur at shutdown: if they're to last more than 1 hour, the shutdown is cancelled.

Jerome

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

Received on Wed Apr 20 2005 - 09:03:13 CDT