Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
Is this a one-off error? Or is this happening every time you restart the database? Can you give us more details? – Brian Ballsun-Stanton Jan 12 '11 at 10:02
@Brain it was a one-off error, and lock eventually was released since all db's have a timeout limit here, was wondering what would be the way to go for a scenario like this, without having to wait for timeouts. – Sathya Jan 12 '11 at 10:19
up vote 4 down vote accepted

Look in 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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.