Operating System - HP-UX
1748199 Members
2615 Online
108759 Solutions
New Discussion

Re: os blk size vs oracle blk size

 
SOLVED
Go to solution
Dennis J Robinson
Frequent Advisor

Re: os blk size vs oracle blk size

All.

Final answer on this:

Oracle Block size should either match or be a multiple of the OS block size.

In your case OS block size should be 8kb, OS fragment should also be 8kb.

In the filesystem/directory structure with the actual oracle installation, you should use the default vxfs filesystem parameters, as there are alot of small files which would eat up space with larger block size.

Smaller block size on vxfs side increase chance in fragmentation of the datafiles at the filesystem side. (DBA's will copy files in and out of filesystem, more than one at a time).

Smaller block size on vxfs side also incurs slightly larger CPU overhead in the copy of the OS block from kernel to user space. This slightly larger CPU overhead will show up as more time spent in system calls.

Good luck:



You know the drill
K.C. Chan
Trusted Contributor

Re: os blk size vs oracle blk size

Frankie, all the replies seems helpfull from an OS perspective. But if the database is created with db_block_size of 2KB, then their's no way of changing it unless you recreate the whole database.
Reputation of a thousand years can be determined by the conduct of an hour