Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OS block size vs. DB block size

Re: OS block size vs. DB block size

From: Kelly Young <young_at_maricopa.edu>
Date: 1998/03/25
Message-ID: <351922B6.32B7@maricopa.edu>#1/1

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.edu
Received on Wed Mar 25 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US