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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Concurrent io AIX 5.3

Re: Concurrent io AIX 5.3

From: Alex Gorbachev <ag_at_oracloid.com>
Date: Thu, 26 Jul 2007 19:04:29 -0400
Message-ID: <c2213f680707261604g5f1ba18u556afc2d8e6b726a@mail.gmail.com>


I second opinion that controlfiles can also be on CIO. Can you share your conflicting references?

For redo logs - IO size is usually higher than one block. Read IO can be up to 1MB don't know if AIX platform limits it. Write size depends on how much of redo buffer LGWR needs to flush. LGWR does write in chunks of 512 bytes or whatever your redo block size is but it issues single write IO up to max it can.

On 7/26/07, Brian Shanblatt <bshan_at_yu.edu> wrote:
> Hello all!
>
> I am configuring a new AIX 5.3 machine, for an oracle database 9.2.0.8
>
> The file systems are JFS2, with the blocksize of 4K which matches our db
> block size.
>
> I would like to implement Concurrent io. I am looking for some
> advice/affirmation, beyond what I found on Metalink and IBM whitepapers.
>
> What I would like to do is:
> 1) All datafiles (tables, indexes, UNDO tablespace, etc) would be on JFS2
> mounted with cio, with a block size of 4K
>
> 2) Redo logs would be on JFS2, mounted with cio, with block size of
> (agblksize) of 512 BYTES. (is this because oracle writes redos in 512
> byte pieces?)
>
> 3) Control files would be on on JFS2 file systems, mounted as default (not
> using direct io or concurrent io).
>
> Does this makes sense? I am assuming that control files should not be on
> filesystems with cio, though I found some conflicted data about control
> files.
>
> I would appreciate any advice/affirmations/flames!
>
> Thank you!
> -brian s
> analyst/dba
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 26 2007 - 18:04:29 CDT

Original text of this message

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