Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

enq: TX - row lock contention

BoochiMar 19 2009 — edited Mar 31 2009
I'm facing a strange scenario. There is an update of a single row running for hours. The status is like "enq: TX - row lock contention". The where clause has the PK column. So, it's updating a single record. What are the possible reasons for this scenario.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2009
Added on Mar 19 2009
#general-database-discussions
36 comments
2,999 views