Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Warehousing - RAID5 or RAID0-1
RAID-5 should be good for the DW application but the area where information
is loaded (involves lot of writes), we loaded them in a RAID 1 area and then
we moved them over to the RAID-5 area as RAID-1 is good for writes.
Hope this helps.
Regards,
Madhavan
>From: CHUCK_HAMILTON_at_qvc.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Data Warehousing - RAID5 or RAID0-1
>Date: Fri, 05 May 2000 07:39:58 -0800
>
>
>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).