Re: Sqlnet 2.1 leaves session alive after user reboots resulting in record locking.

In article <4slg7e$g7g_at_dfw-ixnews7.ix.netcom.com>, daveshaw_at_ix.netcom.co says...
>
>You wrote:
>>
>>gang,

 then set the 'expire_time' to
>>a reasonable period in the _server's_ sqlnet.ora file.
>>
>>douglas
>
> You are right, the expire time was left at the default value by the
>installer. The value is 2147483647, which I assume is 2147.483647 years
>using Oracle's internal julian date, therefor infinity.
>
> What would be a reasonable value, and must it be in the julian date
>format? How would I specify just a few minutes? Can connections be
>dropped inadvertently if the value is too low?
>
> Thank you all for your quick responces.
>
> Dave Shaw
>

 The value for expire_time is expressed in minutes...

-- 
Tony Noble
tnoble_at_mt.gov
Opinions expressed do not necessarily reflect those of my employer.