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!

Blocking sessions

776020Jun 12 2011 — edited Jun 12 2011

We had some issue in the database and have identified some of the sessions which was blocking the other session, due to which the database was in hang state. In AWR report, top event was enq: TX - row lock contention. Want to know if how to find the reason/root cause for which the query was blocked during runtime.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2011

Added on Jun 12 2011

#general-database-discussions

7 comments

1,326 views