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: Oracle on a SAN.... Good, Bad or Proceed with caution?

RE: Oracle on a SAN.... Good, Bad or Proceed with caution?

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Fri, 07 Mar 2003 12:19:46 -0800
Message-ID: <F001.00563AB3.20030307121946@fatcity.com>


We ran ORacle on NETapps... about a 100 Production Databases and I spent a massive
amount (6months) of time verifying that Certain applications were not hindered by the
Netapp SAN... There was alot of doubt buy everyone... but in the end it was clear the
San preformed fine..and all the glitches proved to be solved by application redesign.

This vendor told me everything was journalled in memory and pointers were changing rather
than direct hitting disk becoming an issue.

 I looked at the specs of the disks...ie megs per second capability.. and compare that
 to what your database is out putting per mount point/ie disk.  

Bottom line... I was a doubter ...but converted :)

Brian Spears  

-----Original Message-----
Sent: Friday, March 07, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L

Darrell,

Could I have a copy of that white paper if you still have it?

Thanks,
Scott

At 08:19 AM 3/7/03 -0800, you wrote:
>Amen! For several years we heard from EMC reps, don't worry about it,
>don't worry about it, then recently we we're given a white paper from EMC
>on striping for Oracle.
>
>
> >>> chuckh_at_softhome.net 03/07/03 09:43AM >>>
>SAN is fine as long as you keep track of what's mapping to what physical
>disks. I for one don't believe the SAN vendors that say their caching takes
>care of performance for you and you don't need to worry about where data is
>stored physically. Place datafiles the same way you would for local storage
>and you will do well - striped, with data, indexes, temp, and rollback
>physically separated.
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Thursday, March 06, 2003 4:39 PM
>
>
> > Hello,
> >
> > We are currently spec'ing out hardware for our new ERP system. It is
> > either going to be Peoplesoft or Oracle. We are also debating on using
a
> > SAN rather than attached storage. I'm just looking for any
> > positives/negatives/rules of thumb I should be aware of when running
>Oracle
> > on a SAN architecture provided that management goes that way. The SAN
box
> > we are looking at right now is the EVA3000 from HP (although this isn't
a
> > definite) not sure if this matters.
> >
> > TIA,
> > -Scott Stefick
> >
> > ******************************************
> > Scott Stefick
> > UNIX Systems Administrator
> > Oracle Certified Professional DBA
> > Wm. Rainey Harper College
> > 847.925.6130
> > ******************************************
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Scott Stefick
> > INET: sstefick_at_harpercollege.edu
> >
> > 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: Chuck Hamilton
> INET: chuckh_at_softhome.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.net
>--
>Author: Darrell Landrum
> INET: dlandrum_at_zalecorp.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).



Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Stefick
  INET: sstefick_at_harpercollege.edu

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 Fri Mar 07 2003 - 14:19:46 CST

Original text of this message

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