Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Warehousing - RAID5 or RAID0-1
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFB6C9.196E49B0
Content-Type: text/plain;
charset="iso-8859-1"
But doesn't moving involve writing (into data tablespaces, indexes or index creation)? In this case what did you win? I think that if you can not afford to have everything in RAID 0+1 you should have RBS, TEMP, REDO LOGS and most often changing data and indexes on RAID 0+1. By the way, the difference between let say 1TB of RAID 5 and RAID 0+1 is 0.8TB of disk space. If we assume that 10G disk cost $500 then 0.8TB should cost $40,000. It is nothing comparing with other costs of 1TB DW. Any thoughts anybody?
Alex Hillman
-----Original Message-----
From: Madhavan Amruthur [mailto:mad012000_at_hotmail.com]
Sent: Friday, May 05, 2000 2:03 PM
To: Multiple recipients of list ORACLE-L
Subject: 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).
-- Author: Madhavan Amruthur INET: mad012000_at_hotmail.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). ------_=_NextPart_001_01BFB6C9.196E49B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Data Warehousing - RAID5 or RAID0-1</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>But doesn't moving involve writing (into data = tablespaces, indexes or index creation)? In this case what did you win? = I think that if you can not afford to have everything in RAID 0+1 you = should have RBS, TEMP, REDO LOGS and most often changing data and = indexes on RAID 0+1. By the way, the difference between let say 1TB of = RAID 5 and RAID 0+1 is 0.8TB of disk space. If we assume that 10G disk = cost $500 then 0.8TB should cost $40,000. It is nothing comparing with = other costs of 1TB DW. Any thoughts anybody?</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Madhavan Amruthur [<A = HREF=3D"mailto:mad012000_at_hotmail.com">mailto:mad012000_at_hotmail.com</A>]<= /FONT> <BR><FONT SIZE=3D2>Sent: Friday, May 05, 2000 2:03 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Data Warehousing - RAID5 or = RAID0-1</FONT> </P> <BR> <P><FONT SIZE=3D2>RAID-5 should be good for the DW application but the = area where information </FONT> <BR><FONT SIZE=3D2>is loaded (involves lot of writes), we loaded them = in a RAID 1 area and then </FONT> <BR><FONT SIZE=3D2>we moved them over to the RAID-5 area as RAID-1 is = good for writes.</FONT> </P> <P><FONT SIZE=3D2>Hope this helps.</FONT> <BR><FONT SIZE=3D2>Regards,</FONT> </P> <P><FONT SIZE=3D2>Madhavan</FONT> </P> <BR> <P><FONT SIZE=3D2>>From: CHUCK_HAMILTON_at_qvc.com</FONT> <BR><FONT SIZE=3D2>>Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>>To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>>Subject: Re: Data Warehousing - RAID5 or = RAID0-1</FONT> <BR><FONT SIZE=3D2>>Date: Fri, 05 May 2000 07:39:58 -0800</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>DWs are typically high read, low write = applications. RAID-5 should be fine</FONT> <BR><FONT SIZE=3D2>>for all but TEMP tablespace, RBS tablespace, = redo logs, and archived logs.</FONT> <BR><FONT SIZE=3D2>>RAID 0+1 is also good but requires twice as much = disk.</FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Chuck Hamilton</FONT> <BR><FONT SIZE=3D2>>QVC Inc.</FONT> <BR><FONT SIZE=3D2>>Enterprise Technical Services</FONT> <BR><FONT SIZE=3D2>>Oracle DBA</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>>  = ; = "Surjit</FONT> <BR><FONT = SIZE=3D2>>  = ; = Sharma" = To: Multiple = recipients of </FONT> <BR><FONT SIZE=3D2>>list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT = SIZE=3D2>>  = ; = <surjits_at_ozema = cc: (bcc: CHUCK </FONT> <BR><FONT SIZE=3D2>>HAMILTON/QVC)</FONT> <BR><FONT = SIZE=3D2>>  = ; = il.com.au>  = ; Subject: Data Warehousing - </FONT> <BR><FONT SIZE=3D2>>RAID5 or RAID0-1</FONT> <BR><FONT = SIZE=3D2>>  = ; Ext: = NA</FONT> <BR><FONT = SIZE=3D2>>  = ; Sent = by:</FONT> <BR><FONT = SIZE=3D2>>  = ; = root_at_fatcity.c</FONT> <BR><FONT = SIZE=3D2>>  = ; om</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>>  = ; 05/05/00 = 09:14</FONT> <BR><FONT = SIZE=3D2>>  = ; AM</FONT> <BR><FONT = SIZE=3D2>>  = ; Please = respond</FONT> <BR><FONT = SIZE=3D2>>  = ; to = ORACLE-L</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Hi</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>I need your thoughts on RAID0-1 vs RAID5 = configuration on very large data</FONT> <BR><FONT SIZE=3D2>>warehousing project. The expected data is = going to be about 1 Tera byte,</FONT> <BR><FONT SIZE=3D2>>10 Giga byte Memory, Sun box E6500 , = Oracle 8.1.5.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>I am told that for data warehousing RAID01 = (mirroring and striping) is the</FONT> <BR><FONT SIZE=3D2>>good balance between=A0 RAID5 and no RAID = at all.=A0 Does anyone has any</FONT> <BR><FONT SIZE=3D2>>experience on this? I will be delighted to = hear your thoughts.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>My main consideration is to be able to load = the data in the given window</FONT> <BR><FONT SIZE=3D2>>(overnight) and good response time for the = queries.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Thanks in advance.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Surjit</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Author:</FONT> <BR><FONT SIZE=3D2>> INET: CHUCK_HAMILTON_at_qvc.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>>-----------------------------------------------------------= ---------</FONT> <BR><FONT SIZE=3D2>>To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>>the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>>(or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>>also send the HELP command for other information = (like subscribing).</FONT> </P> <P><FONT = SIZE=3D2>_______________________________________________________________= _________</FONT> <BR><FONT SIZE=3D2>Get Your Private, Free E-mail from MSN Hotmail at <A = HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Madhavan Amruthur</FONT> <BR><FONT SIZE=3D2> INET: mad012000_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =Received on Fri May 05 2000 - 14:35:41 CDT