awr中的Segments by Row Lock Waits模拟

来源：互联网发布：天风期货软件下载编辑：程序博客网时间：2024/05/22 07:40

为什么会有索引的等待事件，是索引在进行分裂，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