下面的脚本显示哪些对象被哪些会话锁住:
select rpad(oracle_username,10) o_name,session_id sid,
decode(locked_mode,0,'None', 1,'Null', 2,'Row Share',
3,'Row Exclusive', 4,'Share', 5,'Share Row Exclusive',
6,'Exclusive') lock_type,object_name,xidusn,xidslot,xidsqn,o.object_id
from v$locked_object l,all_objects o
where l.object_id = o.object_id
|