Re: Terminating orphaned process

From: Kenneth C Stahl <kcstahl_at_ix.netcom.com>
Date: Sun, 20 Jun 1999 08:22:35 -0400
Message-ID: <376CDD0B.7698FE52@ix.netcom.com>

One thing that has bothered me about ALTER SYSTEM KILL SESSION xxx is that once I do it, the session is still listed in Instance Manager - although its status is KILLED. Is there any way (other than bouncing the database) to get rid of these sessions so that they are not listed at all?

Ken

Robert Duke wrote:
>
> 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 Sun Jun 20 1999 - 07:22:35 CDT