Database Tuning (MOSC)

MOSC Banner

Frequent enq: TX - row lock contention

edited May 13, 2016 3:25PM in Database Tuning (MOSC) 7 commentsAnswered ✓

Hi,

My statspack reports display frequently the event "enq: TX - row lock contention" on the top of the events :

By example :

Top 5 Timed Events                                                Avg %Total
~~~~~~~~~~~~~~~~~~                                               wait   Call
Event                                        WaitsTime (s)   (ms)   Time

----------------------------------------- ------------ ----------- ------ ------

enq: TX - row lock contention                   79   4,813  60929   52.1
CPU time                                                 3,684      39.9
db file sequential read                     90,165     612  76.6
direct path read                           141,770      89  11.0
log file parallel write                      7,830       8  1

What can I do in order to identify the sql code causing that problem ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center