| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: stipe size
-----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
> -----------------------------------------------------------------
>
-- 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 - 09:06:53 CST
 |
 |