Ruth,
I would recommend the paper up on the hotsos site
regarding "Alignment of filesystem blocks along stripe
boundaries".
aligning_blocks_hardware_striping.pdf
IMHO, you'd be better off with 2 x 8 drive RAID 01
volumes as opposed to a 6 drive and a 10 drive volume,
particularly with an 8KB block size and a 64 KB stripe
size.
You do not want your oracle blocks fragmented across
multiple drives.
powers of 2 make math easy.
Paul
- Ruth Gramolini <rgramolini_at_tax.state.vt.us> wrote:
>
>
> -----Original Message-----
> From: Claus Lund [mailto:clund_at_tax.state.vt.us]
> Sent: Tuesday, February 24, 2004 7:52 AM
> To: Ruth Gramolini
> Subject: RE: stipe size
>
>
> comments/answers are in Paul's email.
>
> > -----Original Message-----
> > From: Ruth Gramolini
> [mailto:rgramolini_at_tax.state.vt.us]
> > Sent: Monday, February 23, 2004 2:34 PM
> > To: Claus Lund
> > Subject: FW: stipe size
> >
> >
> >
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org] On Behalf
> Of Paul Drake
> > Sent: Friday, February 20, 2004 3:09 PM
> > To: oracle-l_at_freelists.org
> > Subject: Re: stipe size
> >
> >
> > --- Ruth Gramolini <rgramolini_at_tax.state.vt.us>
> wrote:
> > > Good morning all,
> > > We just installed a new fast disk farm with
> fiber
> > > channels. For production
> > > we are using raid 10. My SA set in up with a
> stipe
> > > size of 64K based on the
> > > size of most of the transactions. He wants to
> know
> > > if this will be OK. I
> > > don't know so I told him I would ask the
> experts.
> > > What do you think?
> > >
> > > Thanks,
> > > Ruth Gramolini
> > > Oracle DBA
> > > Vermont Department of Taxes
> >
> > Hi Ruth.
> >
> > I'm not claiming to be an export, but I'll chime
> in
> > anyways. :)
> >
> > What operating system and version are you running
> > Oracle Server on?
>
> AIX 5.2 64bit
>
> > What is the database block size?
> > What filesystem are you using, or are raw volumes
> in
> > use?
>
> JFS2
>
> > Does the storage unit have a cache that is used
> for
> > pre-fetching, and does it also support write-back
> > cacheing?
>
> Yes and yes (and both are used).
>
> > How many drives comprise the striped volume?
>
> 10x36GB RAID0+1 for oradata
> 6x36GB RAID0+1 for oraidx
> 6x36GB RAID0+1 for oramisc
>
> >
> > In an average statspack report, what is the
> average
> > number of blocks fetched per request in your data,
> > index and temp tablespaces?
> >
> > If you're performing mostly single block accesses,
> > then a smaller stripe size will carry the least
> > overhead, but may make maintenance operations take
> > longer.
> >
> > It will be a tradeoff of optimizing performance of
> > daily oltp activity (single block requests), vs.
> your
> > monthly batch jobs which are likely more
> > batch-oriented, which may favor a largish stripe
> size,
> > say 512KB.
> >
> > I'd highly recommend that he short-stroke the
> drives,
> > and only throw a filesystem on the outer half of
> the
> > disks for datafiles, and throw a filesystem on the
> > inner half for storing backups, archlogs, etc.
>
> Right now we are mainly using the outer half of the
> drives ... however as
> the database grows then we will certainly have to
> let the filesystems grow
> closer towards the center of the drives.
>
> >
> > Paul
> >
> > token reference to Juan Loiza's paper on SAME up
> on
> > the BAARF.net site
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail SpamGuard - Read only the mail you
> want.
> > http://antispam.yahoo.com/tools
> >
>
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
> > To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
> >
>
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Feb 24 2004 - 10:01:17 CST