Re: Identifying host OS block size (HP/UX)

Kelly,
Although I am not a HP_UX Guy, I would suggest sizing the Oracle DB_BLOCK_SIZE based on the nature of U'r Applications( like OLTP , DSS etc) and not on the OS Block Size.

Most of the Unix Flavours have a Physical Block size of 512 bytes or 1K and Filesystem Block Sizes like 2K,4k,8K etc..

For OLTP applications I would go for 2k or 4K and for DSS 4K or 8K or even 16K...

I would give one more useful tip ...
 Increasing DB_FILE_MULTIBLOCK_READ_COUNT value in U'r Init.ora will simulate a Bigger Block Size by Reading multiple Smaller Oracle Blocks instead of doing multiple Physical Reads !!! This is a much Simpler method to gain Performance boost instead of Recreating the Entire DATABASE for the purpose of Changing the DB_BLOCK_SIZE ....

Hope this helps...

-Thiru

Kelly Foster wrote:

> Documentation refers to setting a database block size as a multiple of
> the host
> operating system block size. My SA showed me the results of a fstype -v
> command which was (in part):
>
> #fstyp -v /dev/dsk/c1t3d0
> hfs
> f_bsize: 8192
> f_frsize: 1024
>
> In planning a (or revamping current) database block size... Should I
> consider the
> OS block size to be 8K or 1K?
>
> Thanks,
> Kelly L. Foster
> kelly.foster_at_Gunter.af.mil
Received on Fri Jul 23 1999 - 12:59:51 CDT