Re: DB RAID Setup
- From: David Ballester <ballester.david@xxxxxxxxx>
- To: Rob.Dempsey@xxxxxxxxxx
- Date: Tue, 18 Nov 2008 18:31:40 +0100
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
