Code Listing 2: Finding the locked table and row information 

 

select sample_time, session_state, blocking_session, current_obj#, current_file#, current_block#, current_row#
from v$active_session_history
where user_id = 92
and sample_time between
    to_date('29-SEP-12 04.55.00 PM','dd-MON-yy hh:mi:ss PM')
    and
    to_date('29-SEP-12 05.05.00 PM','dd-MON-yy hh:mi:ss PM')
and session_id = 39
and event = 'enq: TX - row lock contention'
order by sample_time;

                           SESSION
SAMPLE_TIME                _STATE    BLOCKING_SESSION  CURRENT_OBJ#  CURRENT_FILE#  CURRENT_BLOCK#  CURRENT_ROW#
—————————————————————————  ————————  ————————————————  ————————————  —————————————  ——————————————  ————————————
29-SEP-12 04.55.02.379 PM  WAITING                 43        121419              7            4491            48
29-SEP-12 04.55.03.379 PM  WAITING                 43        121419              7            4491            48
29-SEP-12 04.55.04.379 PM  WAITING                 43        121419              7            4491            48
29-SEP-12 04.55.05.379 PM  WAITING                 43        121419              7            4491            48
29-SEP-12 04.55.06.379 PM  WAITING                 43        121419              7            4491            48
29-SEP-12 04.55.07.389 PM  WAITING                 43        121419              7            4491            48
… output truncated …