('binary' encoding is not supported, stored as-is)
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).
Received on Mon Jan 20 2003 - 02:28:52 CST
