CPU wait time

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Fri, 09 Jan 2004 01:17:00 +0100
Message-ID: <95srvvsk8r65rhr9lenal3rsnc5l5ljl0s@4ax.com>

Using the "Performance Manager" delivered with the Tuning Pack of the OEM Software, I have noticed that CPU wait time is continuously shown as 97-98% ("CPU Overview" menu). At the operating system level, CPU usage is shown at about 60-80% at the same time. Perhaps the mismatch can be explained because Oracle only considers CPU time spent by Oracle itself.

Perhaps the CPU is "spinning" and actively polling for some resource to get free, which means that it is being wasted (assuming that other processes could benefit from an idle CPU). This is Oracle 9.2.0.4 on Solaris 7.

I can't remember any "CPU wait time" in the statspack report.

Should I try to tune the spinning behaviour to free CPU power?

Bye
Rick Denoire Received on Thu Jan 08 2004 - 18:17:00 CST