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

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