Oracle 查询锁资源
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
评论暂时关闭