Re: Oracle block size - OS block size

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.

(Quite what he'll recommend when block size becomes variable in 9i, who can say?? Steve?????)

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"John van Eck" <JvanEck_at_ssc.dordrecht.nl> wrote in message
news:3B286B54.EFC51ED9_at_ssc.dordrecht.nl...


> Hello,

>

> In the administator's reference it is advised that the Oracle block size

> should be equal or a multiple of the operating system block size.

> I am having problems with finding the operatings system block size. We

> have got HP9000 machines with HP-UX 10.20 and HP-UX 11.

> I have found disk blocks to be 512 bytes. I have also found with the

> command df -g the value of 8192 for the file system block size.

> Which is the one to look at for designing the Oracle block value and

> what is the easiest way on a HP-UX operating system to see the value of

> the nessecary OS block size.

>

> Many thanks in advance,

> John van Eck.

>