Re: oracle on a raid type system

J Holden wrote:
> I have always been told that it is not best to have Oralce on a raid
> type system, but I havent been able to find anything to show people
> who ask me why. I kind of understand why, but was wondering where a
> good place to look to find information on this would be. Or is what I
> have been told not entirely accurate?
> Thanks
> Jeff

You can get some of the information from oracle or look at ORAPub http://www.europa.com/~orapub/papers/pmain.htm for some technical information --- although I must say it is out of date information mostly being 4 years old or older. You can apply the basic principals explained in the capacity planning documents on that page -- minding that they were written with software raid based on the host -- things have changed and they have changed a lot!

You can try asking oracle directly or you can also try asking your hardware vendor (we just got out of a meeting with Sun Microsystem with a storage expert who has extensive experience with oracle).

From personal experience, I have had great success with hardware raid-5 storage with a 20+ GB database using OPS in a clustered node environment (200->250 concurrent users in an OLTP environment).

Things to look at when looking at using raid : 1) The raid functions are performed in hardware on the controller. 2) the controller has adequate caching (32MB or better)

Good Luck,
darryl Received on Fri Jan 22 1999 - 15:38:02 CST