Re: Confirmation of trace data
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 3 Aug 2004 17:26:13 +0100
On Tue, 3 Aug 2004 11:04:28 -0400, Mark W. Farnham <mwf@xxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
