多个会话修改相同行时(enq: TX-row lock contention,mode=6)

多个会话修改相同行时(enq: TX-row lock contention,mode=6)

修改相同行,是发生TX锁引起争用的最普遍的情况。

相同行update引起的TX锁争用:

SQL> select * from a1;

	ID
----------
	 1
	 2

SQL> select * from v$mystat where rownum<2;

       SID STATISTIC#	   VALUE
---------- ---------- ----------
      1588	    0	       1

SQL> update a1 set id=999 where id=1;

1 row updated


SQL> select * from v$mystat where rownum<2;

       SID STATISTIC#	   VALUE
---------- ---------- ----------
      1586	    0	       1

SQL>  update a1 set id=999 where id=1;
.......waiting......................

SQL> select * from v$lock where type in ('TM','TX');

ADDR		 KADDR			 SID TY        ID1	  ID2	   LMODE    REQUEST	 CTIME	    BLOCK
---------------- --------------