Re: Re: 100% CPU utilization, urgent

There may be some utility at sysinternals.com that does what you require.

On Monday 20 January 2003 03:49, Hussain Ahmed Qadri wrote:
> Hi,
>
> 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?
> By the way, I have been able to solve the problem, by increasing the
> Large_pool_size and sort_area_size parameters, and thank to Allah, its
> working fine since then. Anything else that I should do in light of this?
>
> Regards,
>
> Hussain
>
> -----Original Message-----
> Sent: Monday, January 20, 2003 1:29 PM
> To: Multiple recipients of list ORACLE-L
>
> Hussain,
>
> Good advice. First thing to do is to identify WHICH process or thread is
> using CPU. Once you have an OS identifier, check V$SESSION to see what it
> is exactly. I would not have as dark a vision as Pankaj - I mean it is not
> necessarily a virus or Trojan horse. I have seen quite a number of Oracle
> processes (DBSNMP springs to mind, but it's not the only one) causing this
> type of behaviour, and there is most often an easy workaround.
>
> >----- Original Message -----
>
> From: Pankaj Agarwal <gpankaj_at_yahoo.com>
>
> >To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> >Sent: Sun, 19 Jan 2003 22:48:53
> >
> >Hi,
> >
> >Check the processes runnning and identify the
> >process
> >which i resulting in 100% CPU utilization.
> >
> >you can check it by pressing ctrl+shift+esc. There
> >will be a tab Processes. Under thi tab it will how
> >each process that i running on your machine.
> >
> >My own experience says it will a trojan or
> >something
> >like that which is cauing problem.
> >
> >Hope thi resolves your problem, Goodluck
> >
> >Pankaj
> >
> >--- Hussain Ahmed Qadri <hussain_at_skm.org.pk> wrote:
> >> HI all
> >> 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.
> >>
> >> Regards,
> >>
> >> Hussain
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Faroul
> INET: sfaroult_at_oriolecorp.com
>
> 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).

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

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