multiple block size
Hi,
i have the following test case
Oracle databae 11gR2
1. table TBLCOMPRESS_CON in tablespace with blocksize 8k
alter system flush BUFFER_CACHE;
select *
from TBLCOMPRESS_CON
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 364999 7.69 8.47 26679 390016 0 5474964
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 365001 7.69 8.48 26679 390016 0 5474964
2. table TBLCOMPRESS_CON in tablespace with blocksize 32k
alter system flush BUFFER_CACHE;
select *
from
TBLCOMPRESS_CON
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 364999 13.26 14.73 6082 370608 0 5474964
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 365001 13.26 14.73 6082 370608 0 5474964
i have the following test case
Oracle databae 11gR2
1. table TBLCOMPRESS_CON in tablespace with blocksize 8k
alter system flush BUFFER_CACHE;
select *
from TBLCOMPRESS_CON
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 364999 7.69 8.47 26679 390016 0 5474964
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 365001 7.69 8.48 26679 390016 0 5474964
2. table TBLCOMPRESS_CON in tablespace with blocksize 32k
alter system flush BUFFER_CACHE;
select *
from
TBLCOMPRESS_CON
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 364999 13.26 14.73 6082 370608 0 5474964
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 365001 13.26 14.73 6082 370608 0 5474964
0