Block size

[muralip]

We have a hp-ux 11.11 system. The filesystems were all created with a 1k fragment size(vxfs).
I want to change the size to 8k so that my oracle database does not have any performance issues.My sysadmin says that there will not be any performance improvement as the bottleneck would be still there at the fiber optic level(ours is a SAN environment) HP L3000 connected to a XP512 .He says the fragment size there is 1K and that would still be the bottleneck.

Any thoughts?


Murali

[harry d brown jr]

Murali,

I agree with you that the block size should be 8k for oracle (AT LEAST 8k, if not LARGER!!!!) It's a tough call. What are you blcoked on, IO calls or IO waits?

live free or die
harry

[harry d brown jr]

http://www.docs.hp.com//hpux/onlinedocs/os/11.0/tuningwp.html#diskperf

live free or die
harry

[Frank Slootweg]

vxfs/JFS is an *extent*-based filesystem, so the term "fragment" is somewhat incorrect, because that is an *HFS* term.

With vxfs/JFS you can only specify the *block* size. A block size of 1KB is normally fine, because, for larger files, vxfs/JFS will use an extent, which is normally a, large, multiple of the block size.

So unless the filesyetm is (too) fragmented because (at one time or another) it was too full, and you can not unfragment it, vxfs/JFS block size may be an use.

Very, very likely the 8KB recommendation is, implicitly, an *HFS* recommendation.

[Tim D Fulford]

Hi

vxfs is 1k fragment & 8k block!
I believe these are set in stone.

However, if you use raw disk you can do what you like (within the limits of the technology).

We have an fc60 & have LUNS set up with a 64k stripe ... There are multiple ways of achieving this stripe
o Using LVM striping (lvcreate -i -I
o Using the HW striping.
It is all accessed as RAW LVM logical volumes.

A major difference here though is that we use Informix as the database but, I'm sure Oracle can do the same.

Tim

[Frank Slootweg]

See also the current "block size default" thread, talking about the same issues:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x59d828e43106d6118ff40090279cd0f9,00.html