Re: ora-03113 timeout

On May 16, 10:59 pm, steph <stepha..._at_yahoo.de> wrote:
> 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

You asked the same question as in Metalink thread 71237.999. Not sure if those suggestions work.

Yong Huang Received on Wed May 16 2007 - 13:42:27 CDT