RE: Data Warehousing - RAID5 or RAID0-1

RAID 5 always requires 1 disk for parity information, well really it's distributed parity but the effect is the same. It requires a minimum of 3 drives, hmm, come to think of it I don't know what the upper drive limit is.

3 drives : 2 for data
5 drives : 4 for data

George.

> -----Original Message-----
> From: "Day, Tom" <tday_at_grci.com> [mailto:tday_at_grci.com]
> Sent: Monday, May 08, 2000 4:00 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: RE: Data Warehousing - RAID5 or RAID0-1
>
>
> RAID 1 requires twice as many platters as no RAID at all, but
> what is it's
> ratio vs. RAID 5?
>
> -----Original Message-----
> Sent: Friday, May 05, 2000 11:40 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> DWs are typically high read, low write applications. RAID-5
> should be fine
> for all but TEMP tablespace, RBS tablespace, redo logs, and
> archived logs.
> RAID 0+1 is also good but requires twice as much disk.
> --
> Chuck Hamilton
> QVC Inc.
> Enterprise Technical Services
> Oracle DBA
>
>
>
>
> "Surjit
>
> Sharma" To: Multiple
> recipients of
> list ORACLE-L <ORACLE-L_at_fatcity.com>
> <surjits_at_ozema cc: (bcc: CHUCK
> HAMILTON/QVC)
>
> il.com.au> Subject: Data
> Warehousing -
> RAID5 or RAID0-1
> Ext: NA
>
> Sent by:
>
> root_at_fatcity.c
>
> om
>
>
>
>
>
> 05/05/00 09:14
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
>
> Hi
>
> I need your thoughts on RAID0-1 vs RAID5 configuration on
> very large data
> warehousing project. The expected data is going to be about
> 1 Tera byte,
> 10 Giga byte Memory, Sun box E6500 , Oracle 8.1.5.
>
> I am told that for data warehousing RAID01 (mirroring and
> striping) is the
> good balance between RAID5 and no RAID at all. Does anyone has any
> experience on this? I will be delighted to hear your thoughts.
>
> My main consideration is to be able to load the data in the
> given window
> (overnight) and good response time for the queries.
>
> Thanks in advance.
>
> Surjit
>
>
>
>
> --
> Author:
> INET: CHUCK_HAMILTON_at_qvc.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).
> --
> Author: Day, Tom
> INET: tday_at_grci.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
Received on Mon May 08 2000 - 09:28:24 CDT