Re: How much does multiple CPU's help Oracle

stj_at_kraix05.allianse.no wrote:
> This question bugs me for several installations, i.e one NT
> (with 7.1.3 and 4 CPUS running NT 3.51) and one RS6000
> (with 7.2.2, AIX 4.1.4 and 2 Power PC 601 ECPU's), how can I "really"
> use those muscles in the machine ?
> Am I totally dependent on the OS using them to their own best ?
> Can I make Oracle use them more effieciently ?

Oracle is comprised, regardless of the options, of several OS Processes. If you have an OS that supports muliple CPU's reasonably well, you should get decent milage out of Oracle. It was my understanding that both NT and AIX have decent SMP performance. I *can* vouch for Oracle 6.x on a VAX 6000 with 2 CPU's. Even though the two CPU, together, were only 50% faster than the VAX 8500 they replaced, Oracle was much more graceful under load. On a free system, however, a single job was somewhat slower. One process would eventually become the bottleneck, leaving one CPU underutilized.

NT has got decent monitoring tools. Run some jobs and see if both CPU's light up.

Hope this helps,
Charlie Reitzel
creitzel_at_tiac.net Received on Tue Oct 22 1996 - 00:00:00 CEST