Re: RAID Storage for Oracle

Yikes! A serious performance hit? No, RAID 5 is not a serious performance hit in some circumstances. There is, however overhead associated with RAID 5 stripes.

Situations where I recommend RAID 5 are:

1. Read intensive applications (Datawarehouse, reporting databases, etc.)
2. Where hardware cost is a bigger issue than data protection
3. Using hardware based RAID.

However, even situations with that are ideal for RAID 5 configurations still need some 0+1 LUNS for rollback segments, redo logs, and archived redo logs. The performance overhead with RAID 5 is experienced usually with write-intensive operations. Also, I always try to stay away from software based raid systems in production dbs...

Jeff Hunter
eric_peterson_at_maurices.inrg.com wrote in message <7nngjq$7ln$1_at_nnrp1.deja.com>...
>Does anyone know what level RAID storage Oracle recommends? A fellow
>DBA just got back from an Oracle 8 course and informed me that we
>should not be using RAID5 as it stripe's the data and is a serious
>performance hit. Any information would be helpful.
>
>TIA
>Eric Peterson
>Programmer/Analyst DBA
>Maurices Inc.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jul 29 1999 - 22:14:45 CDT