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-----
From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: 100% CPU utilization, urgent
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).
