snippetMinor
How can I remove locks on an object?
Viewed 0 times
canremovehowobjectlocks
Problem
One of my queries is running in to a Row Lock Contention. I've tracked down which table is causing that - so now what's the next step ? Which session is causing this table to get locked ? How do I remove the lock ?
I'm using Oracle 10g
I'm using Oracle 10g
Solution
Look in
You can remove the lock by killing the session, but you will then need to wait for Oracle, specifically PMON, to roll back that session's outstanding work.
DBA_BLOCKERS and DBA_WAITERS. If you don't have these views, as SYS run @?/rdbms/admin/catblock.You can remove the lock by killing the session, but you will then need to wait for Oracle, specifically PMON, to roll back that session's outstanding work.
Context
StackExchange Database Administrators Q#570, answer score: 4
Revisions (0)
No revisions yet.