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?= <[EMAIL PROTECTED]>
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

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

=====
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: [EMAIL PROTECTED]

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: [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: 
  INET: [EMAIL PROTECTED]

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

Reply via email to