Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Confirmation of trace data

RE: Confirmation of trace data

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 3 Aug 2004 11:04:28 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKGEDOFCAA.mwf@rsiz.com>


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. From this same tab you should be able to find the Oracle processes and verify how much CPU they get per unit of real time. Not that this solves your problem, but I think it would let you know what is burning the CPU and confirm that Oracle is getting only dribs and drabs of time. Then again, my level of confusion on what is growing wrong on products from the referenced company is very high and nearly continuous.

--->>> probably trojan_remail_everyone.new_undetected_worm_of_the_day (I hope not.)

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Baumgartel Sent: Tuesday, August 03, 2004 9:23 AM
To: oracle-l_at_freelists.org
Subject: RE: Confirmation of trace data

Comments in-line.

> Hi,
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org =
> > [mailto:oracle-l-bounce_at_freelists.org]
> > On Behalf Of Paul Baumgartel
> ...
> > Is there anything I'm missing here? The following
> ...
> > other sessions on the server (Windows 2K,
> > dual-hyper-threaded CPU,
> > about 2 GB of memory allotted to Oracle) and at
> > times the CPUs are
> > pegged at 100%. Oracle9iR2.
> ...
>
> Are you saying your server is pegging 100% on
> hyper-threaded CPUs? If you have dual CPUs and
> hyperthreading, does task manager show 4x CPU?

Yes, Task Manager shows 4 CPU graphs, each at 100% most of the time.
>
> Since you see double CPU's with hyper-threading, 50%
> CPU utilization implies one normal CPU and 100%
> implies special programs that can use hyperthreading
> pipelines to _full_ capacity. The only program I've
> seen do that is SETI @ home.
>
> What programs are running on the system, besides
> Oracle?

This is a dedicated Oracle server, so there's nothing beyond the OS and related processes.

>
> Good luck.
>
> Regards,
>
> Mike Thomas
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
> http://promotions.yahoo.com/new_mail
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>



Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail

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
-----------------------------------------------------------------


----------------------------------------------------------------
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
-----------------------------------------------------------------
Received on Tue Aug 03 2004 - 10:00:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US