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表示 请求锁。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27042095/viewspace-773726/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27042095/viewspace-773726/