The db_block_size is not the size that oracle reads or writes in the
manner that you are thinking. From the OS level, that is still based on
the IO routines of the host operating system.
The db_block_size is the minimum allocation size on the MEDIA. i.e. if
you have a device that the block size is 4K, you don't want to put 2K
blocks on it, but 4K instead.
This parameter is usually OS driven and typically doesn't have much to do
with the database at all. On Linux, I'd pick 8K as a decent size...
Eric
On Mon, 9 Aug 1999, Eladio Linares Morcillo wrote:
> Hi!
> The range for db_block_size parameter for Oracle8i on Linux is between
> 2K and 16K. This is the size of the minimum block of data that Oracle
> reads or writes to disk as a hole. I'm trying to optimize a 5-disks
> Raid0, so the only way i found is to define db_block_size to the maximun
> (16K), and define chunk-size to 4K for my raid0. Anybody can tell me if
> this is wrong? Is there anything i can do for profiling the raid?
>
> Thanks, Eladio
> NewTech Commitee Coordinator,
> Clinica Universitaria de Navarra
>
>
