ORACLE官方资料上说,ORACLE9i的
两级BB可管如下一级的
BLOCKSIZE 一级数量
---------------- ------------------------------------------ 2K 275 4K 569 8k 1154 16K 2325 32K 4665
但我在9i和10g上都试了下发现不对是241个 frmt: 0x02 chkval: 0x1715 type: 0x21=SECOND LEVEL BITMAP BLOCK
Dump of Second Level Bitmap Block
number: 241 nfree: 241 ffree: 0 pdba: 0x01800023
测试方法,
declare
begin
for i in 1 .. 739200 loop
execute immediate 'alter table t allocate extent';
end loop;
end;
/