Kill specific transactions/processes

From: <acopelan_at_my-deja.com>
Date: Sat, 03 Jul 1999 12:44:41 GMT
Message-ID: <7ll0jo$601$1@nnrp1.deja.com>

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. Received on Sat Jul 03 1999 - 07:44:41 CDT