为什么会有索引的等待事件,是索引在进行分裂,5-5、9-1分裂。
session 1:
create table test(x number,y char(20),z date,q varchar2(4000)) tablespace users;
create index t1_idx1 on test(q,z);
begin
for x in 1..10000 loop
insert into test values(1162,'aaaaaaaaaaaaaa', sysdate, rpad('a',2000,'a'));
end loop;
end;
session 2: 与session 1并发执行插入
begin
for x in 1..10000 loop
insert into test values(1162,'bbbbbbbbbbbbbbbbbbbb', sysdate, rpad('b',2000,'b'));
end loop;
end;
session 3:
session 1与session 2插入后
select object_name,STATISTIC_NAME,value from v$segment_statistics where object_name in ('TEST','T1_IDX1') and STATISTIC_NAME='row lock waits' order by 1;
OBJECT_NAME STATISTIC_NAME VALUE
-----------------------------------------------------------------
T1_IDX1 row lock waits 115
TEST row lock waits 0