Re: ora-03113 timeout

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 16 May 2007 19:49:59 +0200
Message-ID: <f2fg7c$a0u$1@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

steph schreef:
> Hi group,
>
> Just made this simple experiment (on Oracle 9i, Windows XP client):
>
> +) connect to a database via sqlplus
> +) disconnect the network cable
> +) enter a query
> +) wait until the i get an ora-03113
>
> Conclusion: it takes some seconds, till the connection breaks. If I
> reconnect the network cable early enough, the connection stays alive.
> (Well, probably these are trivial findings ...)
>
> But is there a parameter to set the time until the connection breaks
> down when there are networking problems? Can the time until a
> networking error appears be extended?
>
> Thanks,
> Stephan
>

Take a look at the network administrators guide, and see if sqlnet_timeout can help.

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGS0RHLw8L4IAs830RAmMJAJ4omxDur+5xI2TakA+P499cNtjfOQCeIH/3 JpXoBbeC5iXIKc5f+eHP0co=
=CPJg
-----END PGP SIGNATURE----- Received on Wed May 16 2007 - 12:49:59 CDT