Re: Slow Database Shutdown Time

Chris - My guess is that the problem does not lie with SQL*Net, but with Oracle tidying up all the session information. You could test this by killing sessions on the server and see if the database shuts down faster.

A topic that has previously been discussed on this list is what Naveen mentions, namely shutdown abort, followed by a startup and a normal shutdown. Some sites have had a normal shutdown immediate hang for extended periods of time. There were rumors that in earlier versions of Oracle there were some issues with shutdown abort, but recent Oracle versions don't seem to have that problem.

Dennis Williams

On 6/8/05, Nahata, Naveen (US - Hyderabad) <nnahata_at_deloitte.com> wrote:
> Shutdown abort? :-)=3D20
>=20
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marquez, Chris
> Sent: Wednesday, June 08, 2005 7:49 PM
> To: oracle-l_at_freelists.org
> Subject: Slow Database Shutdown Time
>=20
>=20
> Anyone know of any other Oracle (network) method or parameter to
> disconnect sessions faster?
>=20
>=20
>=20
>=20
> This message (including any attachments) contains confidential =3D
> information intended for a specific individual and purpose, and is =3D
> protected by law. If you are not the intended recipient, you should =3D
> delete this message. Any disclosure, copying, or distribution of this =
=3D
> message, or the taking of any action based on it, is strictly =3D
> prohibited.
> --
> http://www.freelists.org/webpage/oracle-l
>

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