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: Chuck Hamilton <chuckh_at_softhome.net>
Date: Mon, 10 Mar 2003 07:08:52 -0800
Message-ID: <F001.00564756.20030310070852@fatcity.com>


We have had I/O issues in the last few months on EMC disks that were corrected by physically relocating filesystems. With no other changes we saw response times cut in half by simply splitting the filesystems from busy databases onto different physical devices within the SAN.

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

-- 
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).
Received on Mon Mar 10 2003 - 09:08:52 CST

Original text of this message

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