Oracle 查询到谁锁了表而谁在等待

--sql---

  

  select lpad(' ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username user_name,
         o.owner,
         o.object_name,
         o.object_type,
         s.sid,
         s.serial#
    from v$locked_object l, dba_objects o, v$session s
   where l.object_id = o.object_id
     and l.session_id = s.sid
   order by o.object_id, xidusn desc