Re: Kill specific transactions/processes

when a session is killed. pmon is resposible for clean up process and lock. sometime pmon is busy and sometimes it takes a while before clean up take place. If you use unix you can kill the unix process use kill - p <process id>. For nt you probably have to use task manager to kill the session.

Ted Chyn
In article <7ll0jo$601$1_at_nnrp1.deja.com>,   acopelan_at_my-deja.com wrote:
> I have a user session where once in a while transactions applied
appear
> to be in an infinite loop or in a deadlock. The process I've used in
> the past is to attempt to kill the session: alter system kill session
> 'sid,serial#'. A number of times the session is marked as KILLED but
> nothing happens, the transactions continue, locks and processes
> associated with the session/transaction are still "alive". Is there a
> way to release specific table locks/processes/transactions associated
> with the session (possibly an "unfriendly" abort of the session) other
> than ALTER SYSTEM or shutting down the database?
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 03 1999 - 09:34:33 CDT