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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
