Re: sqlplus shutdown "time-out"

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 19 Apr 2005 17:38:41 +0000
Message-Id: <1113932321l.8494l.0l@medo.noip.com>

Comments inline:

On 04/19/2005 12:53:20 PM, K Gopalakrishnan wrote:

> 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.

Gopal, this is very interesting, thanks for sharing! Why do I need to abort= ? Would=20
"immediate" help? Is it controllable? Can it be seen anywhere?

>=20

> It is not documented btw :D

>=20

> ___
> Best Regards,
> K Gopalakrishnan=3D20
> Co-Author: Oracle Wait Interface, Oracle Press 2004
> http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
> --
> http://www.freelists.org/webpage/oracle-l
>=20
>=20

--=20
Mladen Gogala
Oracle DBA

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

Received on Tue Apr 19 2005 - 13:45:32 CDT