Re: Physical Data Layout

Hi,

I think, "don't use RAID for..." is not a good approach. If there is no IO related wait event or there is no huge CPU cycles for software raids, it's not a problem to use RAID or not to use.

There is an excellent paper of Carry Millsap who is a philosopher of Oracle+ComputerSciences.

You can download it at www.hotsos.com

Stefan Jahnke wrote:

> Hi,
>
> I'm also looking for RAID / SAN / NAS technology used with databases. Do
> you know any recommended readings ?
>
> Saumya99 schrieb:
> >
> > Hi Chris,
> > The concern is the putting datafile on RAID system. Oracle documentation
> > recommends not to put datafiles on RAID because reading from a RAID device
> > is slower whereas writing is a faster process. Particularly when you are
> > thinking of Performance benefit, you can give a consideration here.
> >
> > -Saumyajit
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, April 25, 2001 1:22 AM
> >
> > > Hello all,
> > >
> > > We are moving our production database onto new disks to improve
> > > performance. It is a high transction OLTP environment using Oracle8i on
> > > a SPARC Solaris box. We are divided about which parts of Oracle to put
> > > where for the best performance. We have come up with two basic
> > > designs.
> > >
> > > A-C are SCSI controllers, 0-18 are 36GB hard disks. B & C each are
> > > connected to hardware RAID controllers. A has two disks mirrored
> > > through software.
> > >
> > > SETUP I:
> > >
> > > A0: Solaris & Oracle Software
> > > A1: A0 soft mirror
> > > B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs
> > > C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO logs, TOOLS, ROLLBACK
> > > (extra disks used in other systems)
> > >
> > > SETUP II:
> > >
> > > A0: Solaris & Oracle Software
> > > A1: A0 soft mirror
> > > B[RAID 0+1]2-7: DATA
> > > B[RAID 1]8-9: REDO logs, SYSTEM
> > > C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO Logs, TOOLS
> > > C[RAID 1]16-17: ROLLBACK
> > >
> > > Or is there an even better way to arrange the data?
> > >
> > > Thanks,
> > >
> > > Chris
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Chris Rezek
> > > INET: crezek_at_dotclick.com
> > >
> > > 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: 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.com
> > --
> > Author: Saumya99
> > INET: saumya99_at_yahoo.com
> >
> > 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: 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.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: danisment.unal_at_unal-bilisim.com

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