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