Re: How Many CPUS??

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Thu, 15 May 2003 15:19:23 GMT
Message-ID: <3EC3AEAD.37595299@telusplanet.net>

Niall Litchfield wrote:

> Check the utilisation using the appropriate OS utility.
>
> adding CPU is expensive (like 25k a pop for licenses to start with) and if
> the CPU is not the bottleneck quite likely counterproductive. What is the
> problem and why do you suspect cpu?

Your 25K a pop - if talking US Dollars, you are referring to Standard Edition, right? If so - watch the licensing on that ... according to the rules, one of the features of enterprise edition is the ability to legally run on a machine capable of more than 4 CPUs. (see http://oraclestore.com, look at Standard Edition, check user minimums, click on the note identified by the caveat. )

I agree with your statement to check ... and your question ...

If OP is not getting distribution across all CPUs, perhaps he's using Standard or does not have parallelism properly initialized. Good - albeit now obsolete - discussion in OReilly's "Oracle Parallel Processing" book. Received on Thu May 15 2003 - 10:19:23 CDT