Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: question about cpu usage on solaris
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 % ?
A single process is using 1 CPU at any given time (although it is moving
from cpu to cpu during its livetime). If you have 4 CPUs, only 1 will be
busy, which is 25% of the entire cpu power of your system. If you have a
dual-cpu-system, 50% would be shown.
Stephan
Received on Tue May 04 2004 - 08:40:58 CDT