Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |