Re: Terminating orphaned process

You can also use the SQLPLUS starement ALTER SYSTEM KILL SESSION ...

Rob Duke
Database Administrator
Motherwell Information Systems

Carlvel Smith wrote:

> 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 Tue Jun 15 1999 - 09:21:23 CDT