RE: Data Warehousing - RAID5 or RAID0-1

Hi,

RAID 0+1 is preferable, but RAID5 is cheaper in the long run.

Either way, LOTS of devices on LOTS of channels.

Don't let the SA's make uninformed decisions and remember Oracle works best spread across LOTS of 'spindles'.

Don't get suckered into logical volumes where you mix RAID levels across the same set of devices, e.g.
 4 x 9g /u0 raid 0+1 @ 4.5 /u01 raid 5 @ 13.5g

you want
  4 x 9g /u0 raid 0+1 18g

George.

> -----Original Message-----
> From: "Surjit Sharma" <surjits_at_ozemail.com.au>
> [mailto:surjits_at_ozemail.com.au]
> Sent: Friday, May 05, 2000 2:14 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: Data Warehousing - RAID5 or RAID0-1
>
>
> 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.
Received on Fri May 05 2000 - 09:02:37 CDT