17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT b.session_id AS sid,
NVL(b.oracle_username, '(oracle)') AS username, --为空则显示'oracle'
a.owner AS object_owner,
a.object_name,
Decode(b.locked_mode, 0, 'None', -- 检查b.locked_mode列 如果为0则输出'NONE',
1, 'Null (NULL)', -- 如果为1 则输出'Null (NULL)'
2, 'Row-S (SS)', -- ....
3, 'Row-X (SX)',
4, 'Share (S)',
5, 'S/Row-X (SSX)',
6, 'Exclusive (X)',
b.locked_mode) locked_mode, --如果都不是 则原样输出
b.os_user_name
FROM dba_objects a, -- a表
v$locked_object b --b 表
WHERE a.object_id = b.object_id --a交b
ORDER BY 1, 2, 3, 4 --排序 1代表sid,2代表username,3代表object_owner ,4代表locked_mode