Re: sqlnet.expire_time - Help !!

My understanding of sqlnet.expire_time is that it is a SERVER parameter (in the sqlnet.ora file on the rdbms server) and does not have any affect when placed on the client pc.
We have not tested much with this parameter

Steve

Andrew Gilkes wrote:

> Hi,
>
> The application/Database that I currently support is about to have a number
> of PC's running Forms45 connected to it. In anticipation of these PC's
> hanging and leaving their SQL*NET sessions hanging around, I have tried to
> config SQL*NET.expire_time parameter in the SQLNET.ORA file on the PC's.
>
> I have started by setting the value to 2 minutes and then crashing the PC.
> At some time later 5 - 30 minutes, the server side terminates the session.
>
> Is this usual ? If so why so much variance in the delay ?
> Has anybody made use of this parameter successfully ?
> Thanks
>
> Andy Gilkes
Received on Thu Jan 14 1999 - 08:38:35 CST