查锁信息常用的脚本

XIDUSN 回滚段
XIDSLOT事务槽

脚本1：--查锁信息脚本，事务槽，回滚段
set linesize 250
column o_name format a10
column lock_type format a20
column object_name format a15

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
from v$locked_object,all_objects
where v$locked_object.object_id=all_objects.object_id;

脚本2：---查表阻塞情况
select sid,type,id1,id2,
decode(lmode,0,'None',
1,'Null',
2,'Row share',
3,'Row Exclusive',
4,'Share',
5,'Share Row Exclusive',
6,'Exclusive') lock_type,
request,ctime,block
from v$lock
where TYPE IN('TX','TM');