Re: Is RAID useful for Oracle database files?

From: Darryl E Balaski <darryl_e_balaski_at_groton.pfizer.com>
Date: Thu, 14 Jan 1999 14:44:40 -0500
Message-ID: <369E4928.3443@groton.pfizer.com>

Connor McDonald wrote:
> Monique van Daal wrote:
> > We know it is possible to use RAID 5 on SUn Solaris for our Oracle
> > databases. But does anybody know if it is also USEFUL to apply RAID 5
> > with Oracle database?
> >
> > Thanks
>
> With RAID you can have 2 of a possible 3 benefits...Take your pick
>
> RAID 0 1 0+1 5
> Redundancy No Yes Yes Yes
> Performance Yes Maybe Yes No
> Inexpensive Yes No No Yes
> --

I've had good experience with Raid-5 (mostly in an ORacle/VMS environment -- 20GB OLTP database with apx 1100 users)

Whatever you do, make sure it is not software raid --- too big of a performance bite!

Make sure the controller has a good cache with battery backup. Performance is pretty good. Sun is coming into my current shop to show us the benchmarks of Raid-5 on their A1000 array's and controllers -- they claim the performance is great.

hope this helps,
darryl dB Balaski
www.rdbms.org Received on Thu Jan 14 1999 - 13:44:40 CST