Re: setting db blocksize and vxfs blocksize

pat_2000_at_my-deja.com wrote:
>
> I'm posting to both comp.databases.oracle.misc and comp.unix.solaris,
> since this question is neither just a Solaris/Veritas question nor an
> Oracle question.
>
> If I have db_block_size in init.ora set to 4096, what is the preferred
> setting for creating a veritas vxfs filesystem:
>
> mkfs -F vxfs -o bsize=# /dev/vx/rdsk/hostdg/vol#
>
> This is a database for OLTP.
>
> Thank you for the help.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Without seeing your system, I'd be inclined to go for a 8k block size and raw file systems. Whilst veritas overcomes some of the unix file deficiencies, (quick io even more so), you can't beat raw for high end OLTP. HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse