Re: Physical Data Layout

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