Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA Experiences with Oracle and RAID 0+1

RE: DBA Experiences with Oracle and RAID 0+1

From: Craig Munday <Craig.Munday_at_ecard.com.au>
Date: Mon, 14 Jan 2002 14:43:38 -0800
Message-ID: <F001.003EF9CF.20020114142236@fatcity.com>

If I remember correctly, I do not think that chapter covers RAID.  There is a good white paper on implementing RAID for Oracle at http://www.quest.com/whitepapers/Raid1.pdf

Cheers,
Craig.

-----Original Message-----
From: Ken Janusz [mailto:ken.janusz_at_sufsys.com] Sent: Tuesday, 15 January 2002 8:30 AM
To: Multiple recipients of list ORACLE-L Subject: RE: DBA Experiences with Oracle and RAID 0+1

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 jonb_at_iewc.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jon Behnke
  INET: JonB_at_iewc.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: Ken Janusz
  INET: ken.janusz_at_sufsys.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). Received on Mon Jan 14 2002 - 16:43:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US