【赛迪网－IT技术报道】Oracle数据库检查锁的参考脚本:
SET linesize 200
COLUMN sid format 999;
COLUMN b format 9;
COLUMN spid format 999999;
COLUMN object_type format a5
COLUMN object_name format a30;
COLUMN lock_type format a10;
COLUMN ctime format 99999
COLUMN username format a15
COLUMN machine format a20;
COLUMN MODULE format a20;
COLUMN action format a20;
SELECT v$session.SID, v$session.serial#, v$process.spid,
RTRIM (object_type) object_type,
RTRIM (owner) || '.' || object_name object_name,
DECODE (lmode,
0, 'None',
1, 'Null',
2, 'Row-S',
3, 'Row-X',
4, 'Share',
5, 'S/Row-X',
6, 'Exclusive',
'Unknown'
) lockmode,
DECODE (request,
0, 'None',
1, 'Null',
2, 'Row-S',
3, 'Row-X',
4, 'Share',
5, 'S/Row-X',
6, 'Exclusive',
'Unknown'
) requestmode,
ctime, BLOCK b, v$session.username, machine, module, action,
DECODE (a.TYPE,
'MR', 'Media Recovery',
'RT', 'Redo Thread',
'UN', 'User Name',
'TX', 'Transaction',
'TM', 'DML',
'UL', 'PL/SQL User Lock',
'DX', 'Distributed Xaction',
'CF', 'Control File',
'IS', 'Instance State',
'FS', 'File Set',
'IR', 'Instance Recovery',
'ST', 'Disk Space Transaction',
'TS', 'Temp Segment',
'IV', 'Library Cache Invalida-tion',
'LS', 'Log Start or Switch',
'RW', 'Row Wait',
'SQ', 'Sequence Number',
'TE', 'Extend Table',
'TT', 'Temp Table',
'Unknown'
) locktype
FROM (SELECT *
FROM v$lock) a,
all_objects,
v$session,
v$process
WHERE a.SID > 6
AND object_name <> 'OBJ$'
AND a.id1 = all_objects.object_id
AND a.SID = v$session.SID
AND v$process.addr = v$session.paddr;
（责任编辑：卢兆林）
|
