Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OS block size vs. DB block size
>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.
I'd go with the logical block size since your IO will be buffered unless you are using RAW devices. In any case, I would not choose a DB block size larger that 4K unless it is a datawarehouse application.
Nabil Courdy