CODEWITHSUNDEEP
oracle-databaseperformanceawr
oradbanj
oradbanj

Reputation: 563

Interpreting Row Lock Contention in AWR Report

My AWR report shows the following :

Event                        Waits  Total Wait Time(s) 
enq: TX - row lock contention 30       10,694

Does 10,694 represents clock time ?

Or does it represents total time spent by all sessions which were monitored during the period AWR was generated ?

Upvotes: 1

Views: 1932

Answers (3)

Dinesh vishe
Dinesh vishe

Reputation: 3598

you have see wait stats is showing

enter image description here

see what queries are running on server.

enter image description here

check blocking by :- select blocking_session, sid, serial#, wait_class, seconds_in_wait from v$session where blocking_session is not NULL order by blocking_session;

SQL currently is waiting :- select sid, sql_text from v$session s, v$sql q where sid in (select sid from v$session where state in (‘WAITING’) and wait_class != ‘Idle’ and event=’enq: TX – row lock contention’ and (q.sql_id = s.sql_id or q.sql_id = s.prev_sql_id));

Upvotes: 0

Ahmed Mustafa
Ahmed Mustafa

Reputation: 29

It is the total suffered time of all the sessions which was suffered due to "TX-row lock contention".

Upvotes: 0

BobC
BobC

Reputation: 4432

It's the latter; time spent by all sessions which were monitored during the snapshot.

Upvotes: 1

Related Questions