Re: DB RAID Setup

El mar, 18-11-2008 a las 17:06 +0000, Rob Dempsey escribió:
> Hi
>
>
>
> Oracle 10g2 (data warehouse)
>
>
>
> data tablespace on RAID 5 I found that strange. When I asked the
> reason why I was give the response ‘that is what Oracle recommends’.
>
>
>
> Has anyone heard this before?
>
>

Nope, in data warehouses the FTS is ( should be ) the most used operation. At least, when loading data one practice is to destroy the indexes ( if any ), load directly the data and recreate the index ( using parallel if available ). You need the max I/O access on FTS, create big blocks and let multiblock to do the magic. I don't saying that indexes will should not be used on data warehouses, don't take me wrong.

Actually the vast majority of disk storage systems has sufficient cache to minimize the delay on RAID5 writes, personally I don't like very much RAID5, not for the writing time, but for the disks ability to fail in 'petit committee' when they are under a RAID5. ( the worst that can occur to RAID5 is a disk failure when other one is restoring from other previous failure ), having more disks in the same raid5 minimizes this problem.

And 'cause I'm member of BAARF ( http://www.baarf.com/ ) and very sentimental :)

Regards

D.

--
http://www.freelists.org/webpage/oracle-l