Re: Terminating orphaned process

From: Uri Margalit <uri_at_hypernix.co.il>
Date: Mon, 7 Jun 1999 22:45:11 +0200
Message-ID: <7jh7eu$42o$1@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 Mon Jun 07 1999 - 15:45:11 CDT