Re: RE: db block size

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 23 Jun 2004 08:57:49 +0100

Note in-line


Jonathan Lewis
The Co-operative Oracle Users' FAQ
Optimising Oracle Seminar - schedule updated May 1st

----- Original Message ----- 
From: <solbeach@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, June 21, 2004 8:32 PM
Subject: Re: RE: db block size

WRT the question of whether smaller block sizes will allow
Oracle to perform better, I don't see where it can have any
impact (one way or the other). From my perspective it is
kind of like asking which pizza will fill you up more;
a 12 inch pizza cut into 4 slices or a 12 inch pizza cut
into 8 slices. A 12" pizza is the same size; regardless of
how you slice it.

Not true - depending on the filling, it may be a lot 
easier to pick up the smaller slices with one hand;
which affects the options for eating pizza and drinking
{insert liquid of preference here} at the same time.

Comparing disk i/os - you may have to make 8 trips 
to the pizza box with the smaller slice - but you may 
have to move, and co-ordinatate both hands when 
you reduce the number of trips to 4.

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: