RE: 1M STRIPE SIZE BEST?

Ethan,

EMC is recommending a 2-cylinder stripe depth now (960KB) which is pretty close to the 1MB that Oracle's SAME (Stripe and Mirror Everything) configuration recommended in the Optimal Storage Configuration Made Easy paper.

Other recommendations:
- use at least 4-member or 8-member striped metavolumes to distribute load
  across multiple disk adapters on the back end; don't go above 8 though or
  you're likely to run into disk queue depth issues - use powerpath to do load balancing on the front end - put redo logs on the first hyper of the physical disk (outer hyper)

Rich

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of Post,
Ethan
> Sent: Wednesday, November 20, 2002 5:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 1M STRIPE SIZE BEST?
>
> A number of papers recommend a stripe size of 1 M (even for EMC) for
> volumes
> containing data files. I also have the following email from Eyal
Aronoff
> of
> Quest dated Nov 2000. A number of the white papers are more recent.
>
> ============================================================
> The reasons for a larger stripe size on a non-RAID 5 device are:
> 1) Sequential reads are faster if you can take advantege of the read
ahead
> built into the disk caching
> 2) If a 64K read does not start on the first block of the stripe, two
> "spindled" are locked for the duration of the read
>
> However, lately we have been testing some EMC gear and it looks like
EMC
> have optimized both of those for smaller strip size too.
>
> The bottom line - I no longer have an opinion one way or another. The
> undelying technology just changes too rapidly.
>
> Eyal
> ============================================================
>
> Your opinions/comments as far as a "best" practice in setting stripe
sizes
> would be greatly appreciated.
>
> Thanks,
> Ethan
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
> INET: Ethan.Post_at_ps.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rich Holland
  INET: holland_at_guidancetech.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).