Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Block size of file system for BLOB column type

Marcelo De Florio_1
Frequent Advisor

Block size of file system for BLOB column type


What is the max block size for file system in HP-UX 11.0 ?

MDF
Marcelo De Florio
3 REPLIES
A. Clay Stephenson
Acclaimed Contributor

Re: Block size of file system for BLOB column type

Hi:

For vxfs, it's 8K; for hfs it's 64K. On vxfs filesystems (which you should be using), blocksize is essentially unimportant as far as performance is concerned. Vxfs likes to write in 64K chunks so it is more important to match your lvol stripe size to 64K.
If it ain't broke, I can fix that.
S.K. Chan
Honored Contributor

Re: Block size of file system for BLOB column type

64K for HFS
8K for JFS
Andreas D. Skjervold
Honored Contributor

Re: Block size of file system for BLOB column type

Hi

If this BLOB column is in a Oracle database, your maximum database blocksize is 32K.

What blocksize the filesystem operates with is of less importance (if not no importance) as during tablespace creation the fixed db blocks are created of continous filesystem blocks and will be used as such for the tablespaces lifetime.

rgds
Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!