Re[2]: Correction : EMC symetrix - 1M stripe width - Raid 0+

From: <dgoulet_at_vicr.com>
Date: Wed, 14 Nov 2001 09:14:06 -0800
Message-ID: <F001.003C4AEE.20011114081522@fatcity.com>

We're using the Symetrix storage system as well, but we did not use stripping, but full mirroring instead. Performance has been more than acceptable, but we really haven't pushed it I think. As far as the SAME (Stripe And Mirror Everything) idea from Oracle, that's great if you have the funds and space for all of those disk systems. Otherwise it's 'pie in the sky'. BTW, you SHOULD look into EMC's PowerPath software (if available on your system). This one allows the computer to balance IO across all of the ports available into the Symetrix. It really does improve matters.

Dick Goulet

____________________Reply Separator____________________
Author: =?iso-8859-1?q?Connor=20McDonald?= <hamcdc_at_yahoo.co.uk>
Date:       11/14/2001 2:10 AM

Interestingly you could go back to Oracle support and ask them about the "SAME" method (as presented by an Oracle employee if I recall correctly at a user conference) - which advocated 1m stripes.

You'll tend to face these battles with EMC - their sales people are great at things like "you don't need to worry about where things are on the disk, or striping etc - our cache takes care of all of that"...Yeah right!

As a general guideline, I think you'd be better of with smaller stripe size, but you don't have to limit yourself - you could have fine granined striping for some parts of the system, and larger grains for other parts.

hth
connor

• Mohammed.Ahsanuddin_at_VerizonWireless.com wrote: > Hi,
  >
  > Application : OLTP
  > Environment : Solaris 2.6 on a E10K
  > Database : 8.0.5.2.1
  >
  > We recently migrated from sun a5200 storage to EMC
  > symetrix, and we have
  > been seeing occasional performance problems. When
  > contacted, Oracle support
  > among other things pointed out the stripe width we
  > have used 1M, is very
  > large and also said users will not see an advantage
  > above 64K.
  >
  > When we had Sun storage before we had 64K as the
  > stripe width.
  >
  > Has anyone faced this kind of issue or has any
  > comments..or can someone
  > explain the low level impact of the stripe width on
  > the ORACLE I/O
  > operations?
  >
  > Much appreciated..
  >
  > Regards
  >
  > Mohammed Ahsanuddin
  > Oracle DBA
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author:
  > INET: Mohammed.Ahsanuddin_at_VerizonWireless.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > 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).
  

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Wed Nov 14 2001 - 11:14:06 CST