唯一索引引发的行锁

最新推荐文章于 2022-06-28 14:57:46 发布

weixin_30493401

最新推荐文章于 2022-06-28 14:57:46 发布

阅读量124

点赞数

原文链接：http://www.cnblogs.com/zhaoyangjian724/p/3798040.html

版权

SQL> create table t2(id  int,name char(10));

Table created.

SQL> create unique index te_idx1 on t2(id);

Index created.

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

       SID STATISTIC#	   VALUE
---------- ---------- ----------
	35	    0	       0

SQL> insert into t2 values(1,'a');

1 row created.


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

       SID STATISTIC#	   VALUE
---------- ---------- ----------
	36	    0	       0

SQL>  insert into t2 values(1,'b');


hang---------
        SAMPLE_ID SESSION_ID
1	1670776	  36	25-2月 -01 12.25.42.878 下午	9jgxu7z5wr2dv	enq: TX - row lock contention	35	 insert into t2 values(1,'b')
2	1670775	  36	25-2月 -01 12.25.41.868 下午	9jgxu7z5wr2dv	enq: TX - row lock contention	35	 insert into t2 values(1,'b')
3	1670774	  36	25-2月 -01 12.25.40.868 下午	9jgxu7z5wr2dv	enq: TX - row lock contention	35	 insert into t2 values(1,'b')

转载于:https://www.cnblogs.com/zhaoyangjian724/p/3798040.html