重建索引锁表:
Session 1:
SQL> select * from v$mystat where rownum<2;
SID STATISTIC# VALUE
---------- ---------- ----------
12 0 0
Session 2:
SQL> select * from v$mystat where rownum<2;
SID STATISTIC# VALUE
---------- ---------- ----------
191 0 0
Session 1:
alter index IDX_WARECOUNTD_GOODID rebuild;
Session 2:
insert into test values(199,'aaa');
oracle 直接建索引锁表
最新推荐文章于 2023-03-07 11:01:26 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)