Re: Oracle block size - OS block size

It's not my area of expertise, but isn't 'number of bytes per inode' telling the mkfs command the average file size, and therefore the amount of space on disc to reserve for inodes ?

Also, one of the other performance features to consider with HP in particular is the memory page size - which defaults to 4K. I believe the ideal is to set the filesystem block size, (mkfs) the memory page, and the oracle data block size to be the same if you are going to use HP file systems.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



koert54 wrote in message ...


>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.

>>

>

>