Tell me more ×
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. It's 100% free, no registration required.
up vote 4 down vote favorite

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
1  
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

1 Answer

up vote 3 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

 
discard

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.