select 
  se1.inst_id as 被阻塞的会话节点,se2.inst_id  罪魁祸首节点,se1.sid  被阻塞的会话ID,ob.object_name  哪个表,se1.serial#  被阻塞的会话序列号,se2.sid   罪魁祸首会话ID,se2.serial#   罪魁祸首会话序列号#,se1.username  被阻塞的用户,se2.username  罪魁祸首名字,se1.blocking_instance,se1.final_blocking_instance blked_final_blocking_instance,se1.final_blocking_session blked_final_blocking_session,se1.event blked_event,se1.seconds_in_wait  被阻塞的用户等待时间,se1."BLOCKING_SESSION_STATUS",se2.final_blocking_instance blking_final_blocking_instance,se2.final_blocking_session blking_final_blocking_session,se2.event blking_event
from 
  gv$session se1,--被阻塞的会话
  gv$session se2,罪魁祸首
  dba_objects ob,1)">表
  gv$locked_object lck  锁
where
  se1.blocking_session_status = 'VALID'
and
  se1.blocking_instance > 0
 
  se1.blocking_session = se2.sid

  se1.sid  lck.session_id

  ob.object_id = lck.object_id;