|
作了测试,SESSION 1 没解锁之前,2,3都申请 tm=3 的锁,1 解锁后,
2 获得 tm=3,但 3 要 tm=6, 结果被堵,奇怪,3 为什么要 tm=6 的锁?
[php]
SCOTT@bi>select b.* from (select id1,id2 from v$lock where block=1) a, v$lock b
2 where a.id1=b.id1 and a.id2=b.id2 order by b.id1,b.id2,b.ctime;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
---------------- ---------------- ----- -- ---------- ---------- ---------- ---------- ---------- ----------
00000000B68DAD80 00000000B68DADA8 108 TM 1232201 0 0 3 27 0
00000000B68DAC80 00000000B68DACA8 148 TM 1232201 0 0 3 30 0
00000000B68DAB80 00000000B68DABA8 20 TM 1232201 0 6 0 39 1
SCOTT@bi>select b.* from (select id1,id2 from v$lock where block=1) a, v$lock b
2 where a.id1=b.id1 and a.id2=b.id2 order by b.id1,b.id2,b.block;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
---------------- ---------------- ----- -- ---------- ---------- ---------- ---------- ---------- ----------
00000000B68DAD80 00000000B68DADA8 108 TM 1232201 0 0 6 75 0
00000000B68DAB80 00000000B68DABA8 148 TM 1232201 0 3 0 75 1
[/php] |
|