ORACLE 查询锁资源

oracle查询锁资源:

 

select b.SESSION_ID,
       b.ORACLE_USERNAME,
       b.OS_USER_NAME,
       b.PROCESS,
       b.LOCKED_MODE,
       a.owner,
       a.object_name,
       a.object_id,
       a.object_type,
       b.XIDUSN,
       b.XIDSLOT,
       b.XIDSQN
  from all_objects a, v$locked_object b
 where a.object_id = b.object_id