Re: sqlplus shutdown "time-out"
- From: Vitalis <vitalisman@xxxxxxxxx>
- To: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- Date: Wed, 20 Apr 2005 14:59:02 +0200
On 4/19/05, K Gopalakrishnan <kaygopal@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
