SQL> select xidusn, xidslot, xidsqn from v$transaction;
XIDUSN XIDSLOT XIDSQN
---------- ---------- ----------
8 23 253
---------- ---------- ----------
8 23 253
SQL> select trunc(id1/power(2,16)) rbs, bitand(id1, to_number('ffff', 'xxxx')) + 0 slot, id2 seq , lmode, request
2 from v$lock, v$session
3 where v$lock.type='TX'
4 and v$lock.sid=v$session.sid and v$session.username=USER;
2 from v$lock, v$session
3 where v$lock.type='TX'
4 and v$lock.sid=v$session.sid and v$session.username=USER;
RBS SLOT SEQ LMODE REQUEST
---------- ---------- ---------- ---------- ----------
8 23 253 6 0
---------- ---------- ---------- ---------- ----------
8 23 253 6 0
注：xidusn, xidslot, xidsqn 组成事务的ID. rbs slot和seq与v$transaction信息匹配。
LMODE=6表示排他锁
request =0 表示不请求锁， 也就是持有锁
request > 0表示 请求锁。