Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OS block size vs. DB block size
S S Wan wrote:
>
> Hello all,
>
> I was confused by the documents from SUN. They said
> that the logical filesystem block size is 8192 bytes but
> the physical block size is 512 bytes. My concern is which
> figure I should take to consider the DB block size, which
> should be integral multiple of the OS block size.
>
> Does anyone have insight?
I agree with what has been said: Your DB block size should be
multiples of the OS logical block size. In your case, 8192.
But here's something to be aware of. When describing initialization
parameters in the manuals, Oracle often refers to OS block size.
In those cases, use 512.
-- Kelly Young Database Administrator Maricopa Community Colleges young_at_maricopa.eduReceived on Wed Mar 25 1998 - 00:00:00 CST