Re: Physical Data Layout

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).
>
> -----------------------------------------------------------
> This Mail has been checked for Viruses
> Attention: Encrypted Mails can NOT be checked !
>
> ***
>
> Diese Mail wurde auf Viren ueberprueft
> Hinweis: Verschluesselte Mails koennen NICHT geprueft werden!
> ------------------------------------------------------------

-- 
Regards,
Stefan Jahnke
BOV AG
@:D2 Vodafone, Abt.: FIBM
AMS-Gebäude: E6 R08

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
  INET: stefan.jahnke_at_d2vodafone.de

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