Jon: I would suggest "Oracle8i DBA Handbook" by Loney & Theriault. Chapter 4 deals with the physical database layouts. It starts with the ideal layout on 22 disks and goes down to about 7 disks. It's very good.
Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -----Original Message----- Sent: Monday, January 14, 2002 2:40 PM To: Multiple recipients of list ORACLE-L Subject: DBA Experiences with Oracle and RAID 0+1 We are in the process of setting up a SAN using RAID 0+1 for our database. In our current environment, we are able to separate our tables, indexes, rollback segments, and archive logs on different disks. On the SAN we would have six 73 gig disks on RAID 0+1 for a total of about 210 Gig of usable space (3 disks worth of space). Some white papers that I have read suggest attempting to separate the data, indexes, and rollback segments on separate RAID volumes, and others simply suggest that the performance boost of striping will supercede the separation of these items. Can anyone offer any comments or suggestions? Jon Behnke Applications Development Manager Industrial Electric Wire & Cable Phone (262) 957-1147 Fax (262) 957-1647 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Behnke 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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).
