从mode 2-6的TM锁相互间的互斥示例(三)
6 0 0
在会话147进行hang住
BYS@ bys001>lock table test in row share mode;
BYS@ bys001>select sid,type,id1,id2,lmode,request,block from v$lock where type in('TM','TX') order by 1,2;
SID TY ID1 ID2 LMODE REQUEST BLOCK
---------- -- ---------- ---------- ---------- ---------- ----------
19 TM 77389 0 6 0 1
147 TM 77389 0 0 2 0