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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
