Database Tuning (MOSC)

MOSC Banner

multiple block size

edited Jan 28, 2012 7:29AM in Database Tuning (MOSC) 12 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center