Re: Confirmation of trace data

On Tue, 3 Aug 2004 11:04:28 -0400, Mark W. Farnham <mwf_at_rsiz.com> wrote:
> Forgive my confusion. If the full CPU utilization is showing in task
> manager, can you not just pull up the tab showing processes, click on the
> cpu column, and get a list of processes ordered by CPU consumption rate? My
> guess is that should show you what is consuming the time.

Mark

I *thought* that I'd sent much the same suggestion, but apparently not. You certainly can do that and see what is at the top of the CPU processes list - I do this occasionally. You can also monitor cpu run queue etc using perfmon.

Paul - I don't understand your comment that

"So this is not stange that each of Oracle thread have max 1/50 of CPU resource (OS overhead not counted)." each thread *when it is executing* will likely get 100% of one of the processors. If Oracle is starved of CPU you will find something else getting most of the CPU in task manager (anti-virus software can be a good candidate).

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------