对于assm可以减少buffer busy wait中的freelist断头块争用很多文章都有提到过,今天做了个实验,对于insert操作也可以分离块的选择,对于不同的session选择不同的块进行insert,test如下
create table zz(id char(2000);
dump块
--------------------------------------------------------
DBA Ranges :
--------------------------------------------------------
0x01000039 Length: 8 Offset: 0
0:Metadata 1:Metadata 2:Metadata 3:75-100% free
4:75-100% free 5:75-100% free 6:75-100% free 7:75-100% free
--------------------------------------------------------
insert into zz values('1);
--------------------------------------------------------
DBA Ranges :
--------------------------------------------------------
0x01000039 Length: 8 Offset: 0
0:Metadata 1:Metadata 2:Metadata 3:75-100% free
4:50-75% free 5:75-100% free 6:75-100% free 7:75-100% free
--------------------------------------------------------
insert into zz values('1);
--------------------------------------------------------
DBA Ranges :
--------------------------------------------------------
0x01000039 Length: 8 Offset: 0
0:Metadata 1:Metadata 2:Metadata 3:75-100% free
4:50-75% free 5:50-75% free 6:75-100% free 7:75-100% free
--------------------------------------------------------
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/16158219/viewspace-610024/ ,如需转载,请注明出处,否则将追究法律责任。