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!

How to find sql causing "enq: TX - row lock contention"

940748Mar 5 2013 — edited Mar 18 2013

Hi,

In one of our database we keep finding "enq: TX - row lock contention" for 2-3 days. But, then it stopped. The time it happened it blocked other sessions for some long time and it got resolved automatically. Now from ADDM report we got sql queries which waited for this but, we can not find which query from which module was causing the issue. What I should look for that past information. Please help.

Database is 10gR2 on AIX.

Regards,
Gourab

This post has been answered by Salman Qureshi on Mar 17 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2013

Added on Mar 5 2013

#general-database-discussions

27 comments

29,700 views