查看锁和等待

  SELECT /*+ rule */
   lpad(' ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username User_name,
   o.owner,
   o.object_name,
   o.object_type,
   s.sid,
   s.serial#,
   p.spid
    FROM v$locked_object l, dba_objects o, v$session s, v$process p
   WHERE l.object_id = o.object_id
     AND l.session_id = s.sid
     and s.paddr = p.addr
   ORDER BY o.object_id, xidusn DESC