查看当前用户TX锁
SELECT username,
v$lock.sid,
Trunc(id1 / Power(2, 16)) rbs,
Bitand(id1, To_number('ffff', 'xxxx')) + 0 slot,
id2 seq,
lmode,
request
FROM v$lock,
v$session
WHERE v$lock.TYPE = 'TX'
AND v$lock.sid = v$session.sid
AND v$session.username = USER;
查看事务ID
select xidusn,xidslot,xidsqn from v$transaction;
查看某个session被某个session锁住
SELECT (SELECT username
FROM v$session
WHERE sid = a.sid) blocker,
a.sid,
' is blocking ',
(SELECT username
FROM v$session
WHERE sid = b.sid) blockee,
b.sid
FROM v$lock a,
v$lock b
WHERE a.BLOCK = 1
AND b.request > 0
AND a.id1 = b.id1
AND a.id2 = b.id2;