Re: SQL*Net sqlnet.expire_time in sqlnet.ora ???

Sean Kubovcik wrote:
> What kind of process termination will the following sqlnet.ora parameter kill?
> sqlnet.expire_time=
> My setting is currently 0. Sometimes, I have user processes that hanging around when they
> disconnect. Will this parameter kill any process that is longer than the time set? What about a
> user process that takes 5 hours to run? This process would not be desired for deletion.

  You can try to specify a number greater than zero as an zero may mean that it will wait indefinitely.

  However, this parameter will kill any process that is longer than the time set. This parameter is used to set the time interval for the probe to detect dead processes.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841