Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> removing locks or rolling back transactions

removing locks or rolling back transactions

From: <raff32_at_my-deja.com>
Date: Mon, 08 Nov 1999 20:49:33 GMT
Message-ID: <807d0s$i6p$1@nnrp1.deja.com>


I am having trouble removing locks from an oracle 8.0.5 database. One of my users aborted their session in the middle of it while it was holding locks on certain objects.
I have since killed the session manually using the alter system kill session command.
Even thought these sessions are marked as killed in the v$session view there are still active transactions mapping back to each one of them. These transactions have left eachother in a deadlocked
state. I cannot find the correct docementation on either releasing locks or forcing a transaction to rollback or commit. Killing the transaction would be okay too.
Can anyone help me out on the commands I am looking for?

thanks in advance
Steve

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 08 1999 - 14:49:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US