RE: Re: 100% CPU utilization, urgent

On Mon, 20 Jan 2003, Hussain Ahmed Qadri wrote:

> It's the Oracle.exe which is taking 100%. V$session tells me about the users
> connected to the database, but no the info about which user is taking what
> percentage of CPU. How can I identify which Oracle process (like DBSNMP or
> anyother) it is that is taking so much CPU?

I don't know how to see the top CPU-using thread in Windows, but you can get this from the database if you have TIMED_STATISTICS set to TRUE. Just query v$sesstat and join to v$statname by statistic# looking only for 'CPU used by this session', and find out which sid is using the most CPU BETWEEN QUERIES. Alternately, you can get this info from the same table since instance startup by dividing the statistics value by the total lifetime of the session taken from from v$session.

I'll let you make the SQL.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton




> >--- Hussain Ahmed Qadri <hussain_at_skm.org.pk> wrote:

> >

> >> We have a consistent problem of CPU utilization

> >> 100%. We have had this

> >> problem since Saturday, but it automatically

> >> subsided, I mean went back to

> >> normal after a few hours, and remained normal on

> >> Sunday as well. But its

> >> back to 100% since morning, that is when the load

> >on

> >> the server has gone up

> >> again to 100% and over all work is non-existent.

> >

> >> Our machine is Compaq Proliant ML350, 900 MB ram,

> >

> >> 933 single Processor,

> >> Database size of roughly 5 GB. WINNT4.0, Oracle

> >> 8.1.7.

> >> I have checked the temporary tablespaces, they

> >are

> >> normal.

> >> We have a 24x7 environment, a hospital, so please

> >

> >> can you suggest the areas

> >> to look in to, its really very urgent.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).