Re: Terminating orphaned process

This isn't true.

For that, you need to set ( judiciously! ) expire_time in client's SQLNET.ORA this parameter has to do with session instantiation during the listener t_listen, t_accept, etc.
process.

Uri Margalit wrote in message <7jh7eu$42o$1_at_news.netvision.net.il>...
>Yes there is a way.
>
>To solve the problem you descired here you need to add a row to the
>listener.ora file:
>connect_timeout_listener = n
>
>Where n is the number of seconds in which the server check if the client is
>ok, if not it will kill the session in ORACLE.
>
>Uri
>
>
>Carlvel Smith <Carlvel.Smith_at_srs.gov> wrote in message
>news:1999Jun7.125600.11501_at_srs.gov...
>> Is there a way a user (owner of the process being done) to cancel or kill
>a
>> process in oracle once their connection has been abnormally terminate?
>For
>> example, during an update to a single record from an offsite location
>> (telecommuting from home) connection to the Oracle data base was dropped.
>Once
>> logon was reestablished, the record in the process of update was locked
>> requiring DBA intervention to kill the orphaned process.
>>
>> Thanks in advanced,
>>
>> Carlvel
>>
>
>
Received on Thu Jun 10 1999 - 05:26:35 CDT