In article <86nonn$unj$1_at_nnrp1.deja.com>, billmil_at_my-deja.com wrote:
> Thanks for the feedback, Andreas. I hadn't read the Oreilly Tuning
> book yet. The DBA book touches on the topic, but doesn't give much
> direction on how to configure if you don't have 15 disks.
> bill milbratz
> chicago
> In article <388D716A.9DB58395_at_adicom.de>,
> Andreas Michler <Andreas.Michler_at_adicom.de> wrote:
> > Oracle Performance Tuning from O'Really says:
> > 1 Disk for Operating System
> > rest for oracle.
> > In your case I would do the following:
> >
> > Using RAID-Level 5 or
> >
> > Redologs - > Disk1
> > the rest -> Disk2
> >
> Sent via Deja.com http://www.deja.com/
> Before you buy.
I disagree with the RAID 5 suggestion in every case except read-only
databases. Suggest you use RAID 0+1, since you have so few disks, as
the striping will help to distribute the I/O. Treat the array set as
one logical drive, since it is of no advantage to have separate logical
drives in one array set. When using RAID (if you have enough disks)
the balancing of I/O (according to Oracle's OFA) is best accomplished
with more than one "array set", which also allows appropriate different
stripe sizes. I recommend Chapter 3 in the Oracle 24x7 Tips &
Techniques Oracle Press book. Even if you are not a 24x7 shop, this is
a great book and this chapter has an excellent description of RAID
configurations and their relationship to Oracle. Good luck.
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Received on Thu Jan 27 2000 - 15:13:11 CST
