| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: db block size
Note in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st
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.
 |
 |