RAID Performance with Oracle

Paul paul at kbs.net.au
Mon Mar 24 17:12:01 CST 2003


Thanks all, I will pass this on and let them know

----- Original Message -----
From: "Seth Mos" <knuffie at xs4all.nl>
To: "Paul" <paul at kbs.net.au>; <linux-poweredge at dell.com>
Sent: Monday, March 24, 2003 6:19 PM
Subject: Re: RAID Performance with Oracle


> At 17:09 24-3-2003 +1100, Paul wrote:
> >
> >Hey All,
> >
> >I am helping someone out with quite an intensive database with a lot of
> >writes (and reads).  They have Oracle 9i on SuSe SLE8 and using RAID 5
> >(PowerEdge2600 with Perc4di).
> >It appears it is taking time to write to the disks.  In this case it is
> >not feasable right away to switch it from RAID 5 to RAID 1+0 or 0+1 or
> >similar.
>
> Do not put a Large database on a raid5 software or hardware raid.
>
> Raid 0,1 and 10 are safe for use with databases.
>
> >Does the Perc4Di support RAID 1+0 arrays?
>
> Yes.
>
> >I appears that it may be taking up to 8 seconds to write to the Redo log
> >files.
> >
> >Is there anything I can do to optimize the database for RAID 5 use?
>
> No. Raid 5 requires 5 read write operations on the hardware level for one
> update which hurts really badly.
> This is why it is inherently bad for something dynamic like a database.
>
> Cheers
>
> --
> Seth
> It might just be your lucky day, if you only knew.
>
> _______________________________________________
> Linux-PowerEdge mailing list
> Linux-PowerEdge at dell.com
> http://lists.us.dell.com/mailman/listinfo/linux-poweredge
> Please read the FAQ at http://lists.us.dell.com/faq or search the list
archives at http://lists.us.dell.com/htdig/
>




More information about the Linux-PowerEdge mailing list