Physical Data Layout

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