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

About fragment size in a HFS file system

SOLVED
Go to solution
fly_fisher
Advisor

About fragment size in a HFS file system

Hi all,

Is 4k a good fragment size in a HFS Filesystem which block size is 32k ?

This filesystem is going to be used as Data Wharehouse(oracle).

Thank you very much for your help.
Regards.
Catch and release !!!!!!
3 REPLIES
John Palmer
Honored Contributor
Solution

Re: About fragment size in a HFS file system

Data warehousing = big database files.

Why are you concerned about fragsize in a filesystem that's only likely to contain a few large database files?

I would recommend that you use a VXFS filesystem rather than HFS. As it's extent based, you don't really have to worry about the blocksize. It's much faster to recover in the event of a crash and doesn't require the 10% minfree space overhead.

Regards,
John
John Bolene
Honored Contributor

Re: About fragment size in a HFS file system

Only use HFS if you have to, VXFS is a much better solution.

And yes 4K is a good fragment size to use in a 32K block. It is usually 8-1 or 10-1.
It is always a good day when you are launching rockets! http://tripolioklahoma.org, Mostly Missiles http://mostlymissiles.com
Wodisch
Honored Contributor

Re: About fragment size in a HFS file system