SELECT /*+ rule */
lpad(' ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username User_name,
o.owner,
o.object_name,
o.object_type,
s.sid,
s.serial#
FROM
v$locked_object l, dba_objects o, v$session s
WHERE
l.object_id = o.object_id AND
l.session_id = s.sid
ORDER BY
o.object_id, xidusn DESC;
查找数据库锁
最新推荐文章于 2024-09-07 20:09:50 发布