ORACLE: Bloqueante y bloqueado de un objeto de base de datos.

Basándome en el query que pasaron en este foro completé un poco más la información obtenida, agregándole la sentencia que está bloqueando, y la bloqueada.


SELECT LPAD (' ', DECODE (l.xidusn, 0, 8, 0))
|| l.oracle_username "User Name",
o.owner, o.object_name, o.object_type, l.locked_mode, st.sql_text
FROM v$locked_object l,
dba_objects o,
v$session s,
v$sqltext_with_newlines st
WHERE l.object_id = o.object_id
AND l.session_id = s.SID
AND ( ( l.xidusn = 0
AND st.address = s.sql_address
AND st.hash_value = s.sql_hash_value
)
OR ( l.xidusn <> 0
AND st.address = s.prev_sql_addr
AND st.hash_value = s.prev_hash_value
)
)
ORDER BY o.object_id, 1 DESC, st.piece;