Re: Oracle SMP and RAID

Dmitry:

It's not so much the Intel-based hardware as it is the O/S. On NT, you will get something like a 75% performance increase by going from 1 processor to 2, assuming that everything in the instance is processor-bound. Going from 2 processors to 4, theoretically should give about a 50% increase, again assuming a processor-bound condition. We actually got about a 35% increase in going from 2 to 4.

Which version of RAID are you using? RAID0 (stripping), RAID1 (mirroring), or RAID5 (floating parity)? RAID0 is very good for reads and writes, but offers no fault-tolerance. RAID1 is OK for reads and writes (if you have enough mirror sets) and offers fault-tolerance, but is twice as expensive. RAID5 is good for reads and offers fault-tolerance, but is not too good for writes.

How many independent disk arrays do you have on your box?

Hope this helps,
Dave

Dmitry wrote in message <896859530.891339_at_servocomp.ru>...
>Hi,
>Could anyone tell me, what shall I do to fine tune Oracle 7.3.4 on NT intel
>machine with several processors and RAID?
>Is it true that 2 processors do not add sufficient impact of performance vs
>1 processor?
>
>Thanks, Dmitry
>
>
>
Received on Sun Jun 07 1998 - 20:21:58 CDT