Re: Oracle block size - OS block size

From: koert54 <k_at_k.com>
Date: Fri, 15 Jun 2001 20:50:51 GMT
Message-ID: <LyuW6.36383$mR5.4796351@afrodite.telenet-ops.be>

8192 = nbpi or number of bytes per inode always make your nbpi equal to db block size - less translation overhead

cheers
Kurt Van Meerbeeck

"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.
>
Received on Fri Jun 15 2001 - 15:50:51 CDT