本帖最后由 lwp542 于 2013-4-20 01:34 编辑
SQL> lock table t1 in share mode;
Table(s) Locked.
SQL> select * from v$lock where type in ('TM','TX') order by sid;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
-------- -------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
00D7D880 00D7D8B0 1 TM 76573 0 4 0 2 0
SQL> insert into t1 values (4);
1 row created.
SQL> select * from v$lock where type in ('TM','TX') order by sid;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
-------- -------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
5173E2E0 5173E320 1 TX 524294 7484 6 0 1 0
00D7D880 00D7D8B0 1 TM 76573 0 5 0 1 0
-- 可以看到发生了锁转换,lmode 4-->5