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 <[EMAIL PROTECTED]> > > >To: Multiple recipients of list ORACLE-L > ><[EMAIL PROTECTED]> > >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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).