Re: long running query across network

From: Dave Hau <davehau_nospam_123_at_nospam_netscape.net>
Date: Wed, 13 Aug 2003 00:56:59 GMT
Message-ID: <3F398CDA.70506@nospam_netscape.net>

A firewall can time out a TCP session after a certain amount of idle time. One way to prevent this is to set SQLNET.EXPIRE_TIME on the sqlnet.ora of the listener to send a ping every n seconds to the client.

Cheers,
Dave

Ralf Fernan wrote:
> If a windows client (ODBC) initiates a long-running query to Oracle (AIX,
> 8.1.5), what are the reasons why the Oracle connection might be lost? I
> don't believe that 1) the application will close the connection simply
> because it is idle; 2) Oracle will close the connection while it is still
> processing the query. Besides a network "glitch" (whatever that is), are
> there reasons why the database connection might be dropped?
>
> Thanks
>
>
Received on Tue Aug 12 2003 - 19:56:59 CDT