Re: Oracle block size - OS block size

I know very well Steve Adams' suggestion on this. But in some cases a smaller block size makes more sense. For instance, when you create a database in which you have many small tables, so small that every table takes space far less than 8k and they grow very slowly. From the space usage point of view, you can choose 4k or even 2k. Loss in performance due to extra I/O on garbage bits and bytes is an issue but may be a small one.

BTW, has anyone seen a benchmark on different db_block_sizes? I remember somebody posted a message on an Oracle Applications mailing list claiming better performance using 16k block size than 8k as a result of some benchmark test.

Yong Huang
yong321_at_yahoo.com

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:<3b287231_at_news.iprimus.com.au>...
> 8K Oracle blocks on a Unix platform, and don't even think about it. See
> Steve Adams' article entitled 'Why a Large Database Block Size' at
> ixora.com.au for an explanation of why this one is a no-brainer.
Received on Thu Jun 14 2001 - 13:12:28 CDT