Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: San Performance gurus

RE: San Performance gurus

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Wed, 23 Apr 2003 14:07:29 -0800
Message-ID: <F001.005881C8.20030423140729@fatcity.com>

Chris, what is your type of SAN are you using?

Brian
-----Original Message-----
Sent: Wednesday, April 23, 2003 12:37 PM To: Multiple recipients of list ORACLE-L

I'm not sure I understand the question (but I'm not a SAN guru either). We run our database on a SAN, and we also use SAME (more or less; see below). The two concepts aren't necessarily related (though I'd guess it's easier to use SAME on a SAN rather than otherwise).

We're running RAID 5 without apparent ill effects. We spend a lot more time reading than writing. We're also in a situation (shared by many others, I understand) where tuning a query can have a dramatic effect on performance, and I/O tweaks are pretty ho-hum by comparison.

Maybe I'm misusing the acronym SAME - I've always used it somewhat casually - that is, I assume that building across several RAID-5 sets, rather than across RAID 1 or 10 or 0+1, gives an acceptable amount of protection against hardware failure. The one thing I've fought for is to have a separate volume, on top of physically separate disks, for multiplexing of redo and control files.

-Chris

> -----Original Message-----
> From: Spears, Brian [mailto:BSpears_at_Limitedbrands.com]
> Sent: Tuesday, April 22, 2003 7:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: San Performance gurus
>
>
>
>
> Has anybody any knowledge on the San configuration as compared to
> ORACLE's SAME methodology.
>
> I am ok with the San raid 5 but some are saying ORACLES SAME
> makes alot of
> difference. SAME=Stripe and Mirror Everything.
>
> I did some performance testing and found the payback was not
> worth it. My
> conclusion
> was the advance technology just does a good job on
> performance on the SAN's.
>
> I could never really even reproduce hot spots that were bottlenecks.
>
>
> Brian
>

LEGAL NOTICE:
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sarnowski, Chris
  INET: csarnows_at_CuraGen.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Spears, Brian
  INET: BSpears_at_Limitedbrands.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).
Received on Wed Apr 23 2003 - 17:07:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US