Re: question about cpu usage on solaris

From: Steve <ThisOne_at_Aint.valid>
Date: Wed, 05 May 2004 22:43:26 +1200
Message-ID: <c7aggf$sld$1@lust.ihug.co.nz>

JBR wrote:
> I have a Oracle 8.1.7 database running on a 4 cpu Sun V440 with Solaris 8.
> When a user does a SQL query on the database I see a maximum CPU usage of
> about 24.89%. It is not query dependent.
> When I do for example an gzip, the max CPU usage will be more then 25%.
>
> Why is the Oracle process limited to about 24.89% CPU usage and will not
> consume more CPU % ?
>
> regards,
> John
>
>

Hi John,

Do the math... 1 x CPU = 25% of 4 CPUs. You're looking at single threaded applications here, by the look of things. The upside is that you can run 4 of these queries at the same time. This is always where you gain with multiple cpus.

Alternatively, you could also run 3 copies of setiathome as well (^:

Steve Received on Wed May 05 2004 - 05:43:26 CDT