|
ORACLE查询锁资源语句
oracle查询锁资源:
[sql]
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, www.2cto.com
b.XIDSLOT,
b.XIDSQN
from all_objects a, v$locked_object b
where a.object_id = b.object_id
作者 ziwen00
|