Bloques que generan enq: TX - row lock contention | ExpoDBA

Bloques que generan enq: TX - row lock contention

Bloques que generan enq: TX - row lock contention

SELECT object_name,    ROW_WAIT_FILE#,ROW_WAIT_BLOCK#,ROW_WAIT_ROW#, count(9) cant, min(seconds_in_wait) min_time, max(seconds_in_wait) max_time
from v$session b, dba_objects o
where o.object_id=ROW_WAIT_OBJ#
and event = 'enq: TX - row lock contention'
group by object_name,   ROW_WAIT_FILE#,ROW_WAIT_BLOCK#,ROW_WAIT_ROW#
order by 1,5;