| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Virgin RAID system
I also recommend insisting on at least one JBOD - there is no need to
pay the performance price of any RAID for the system swap file and the
temporary tablespace...
Also, try to get the RBS off the same disks as other components. (If OLTP environment.)
The worst disk I/O subsystem you can possibly have for any RDMS is a single RAID5 array with a minimum number of physical disks. Unfortunately, the beancounters love RAID5 - they love it more when they can buy a total of 3 disks. The manufacturing trend to larger and larger disks makes my skin crawl. It gets harder and harder to convince people to purchase many disks for a database server as these huge drives become available and the prices go down.
A mix of 0+1 and 1 arrays are best - but nobody wants to spend the money (until they have been through the cycle of pain).
Think about this as a compromise:
RAID1 - System disk RAID1 - Redo Logs RAID1 - RBS RAID5 - Data RAID5 - Index
jambu_batu_at_my-deja.com wrote:
>
> In article <7r3gvh$4q3$1_at_winter.news.rcn.net>,
> "Jerry Gitomer" <jgitomer_at_hbsrx.com> wrote:
>
> Performance on RAID 5 is worst. I suggest you go for 0 + 1.
>
> > Hi Darren,
> >
> > Just make sure that you have a mirrored drive outside of the
> > RAID 5 configuration for you redo logs. Space permitting you may
> > also want to keep your archives on that drive. If you can't get
> > a mirrored drive start complaining now and make sure that your
> > management knows that you will be taking a substantial
> > performance hit (I have attempted to remove this experience from
> > my memory -- it was that bad. The conflicts were so severe that
> > when we moved redo logs off of the RAID 5 our performance
> > doubled! I have no idea if this was an extreme situation or
> > normal for RAID 5 and I have no intention of trying to find out.)
> >
> > As far as the RAID array is concerned,I don't know about
> > Sun's RAID 5, but the ones I have worked with don't give you
> > access at the drive level. The entire RAID 5 is treated as a
> > single volume.
> >
> > Regards
> > Jerry Gitomer
> >
> > Darren John Capper wrote in message
> > <37D37FA3.ACA7B5B9_at_preci-spark.co.uk>...
> > >Oracle Guru's,
> > >
> > >My company has just purchased a Sun Enterprise server along with
> > a RAID
> > >array (RAID 5 I think). It's going to be about two months
> > before I get
> > >my hands on it and I was wondering how RAID will affect my
> > Oracle
> > >setup. Do I need to be concerned with which disk a particular
> > table is
> > >on or will RAID stripe it anyway?
> > >
> > >Any comments or pointers in the right direction will be greatly
> > >appreciated.
> > >
> > >Regards,
> > >Darren
> > >
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Sep 08 1999 - 07:54:09 CDT
 |
 |