Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: setting db blocksize and vxfs blocksize

Re: setting db blocksize and vxfs blocksize

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 05 Sep 2000 19:52:26 +0800
Message-ID: <39B4DE7A.756F@yahoo.com>

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
Received on Tue Sep 05 2000 - 06:52:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US