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