RE: 100% CPU utilization, urgent

If I remember correctly (from a previous NT-life): v$process.spid maps to the NT thread_id. The thread(s) causing this can be found probably by looking at pstat or perfmon: here you can see the cpu consumption. Also you can probably deduce it from v$sesstat's 'cpu used by this session': it will be high compared to others (if it's just 1 runaway thread).. regards,
Mario Broodbakker

-----Original Message-----
Sent: maandag 20 januari 2003 9:54
To: Multiple recipients of list ORACLE-L

In windows NT you cannot map the OS proces with v$session information. I hope there is a way to get the thread information and map it to V$SESSION, but in Task Manager it will only show as Oracle.exe for all the processes.

If you find out how to get the thread information and map it to v$session, please let me know.

But the question is, are you having a problem with 100 CPU utilization? Is it for short periods or it happens for long duration without much corresponding DB activity?

Regards
Naveen

-----Original Message-----
Sent: Monday, January 20, 2003 1:59 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).



DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return  e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited.  Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Broodbakker, Mario
  INET: Mario.Broodbakker_at_hp.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).