Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 100% CPU utilization, urgent

RE: 100% CPU utilization, urgent

From: Thomas Day <tday6_at_csc.com>
Date: Mon, 20 Jan 2003 09:04:33 -0800
Message-ID: <F001.00534C4C.20030120090433@fatcity.com>

If you run the second script you will get the CPU utilization (whatever that means) per SID. In your case SIDs 1-6 are the ones that you're interested in. The NT Task Manager will only show you ORACLE.EXE. It doesn't show the embedded threads.

                                                                                                                                       
                      "Koivu, Lisa"                                                                                                    
                      <Lisa.Koivu              To:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      @efairfield.com>         cc:                                                                                     
                      Sent by: root            Subject: RE: 100% CPU utilization, urgent                                               
                                                                                                                                       
                                                                                                                                       
                      01/20/2003 10:36                                                                                                 
                      AM                                                                                                               
                      Please respond                                                                                                   
                      to ORACLE-L                                                                                                      
                                                                                                                                       
                                                                                                                                       




Thomas, thanks for your post.

However I don't see where I can match the threads on NT to what I see in Task Manager. Am I missing something?

To be more explicit, here's what I've got:

SQL> select * from dba_nt_threads;

ID_THREAD B NAME SID SERIAL# USERNAME STATUS OSUSER
--------- - ----- --------- ---------- ------------------------------

8 rows selected.

I see no processes in task manager that correspond to any of the numbers listed in ID_THREAD. In fact my sessions script used to reference spid, but I took it out because I couldn't make sense of it on Windows.

Thanks for any insight.

Lisa Koivu
Oracle Dogbarf Cleanerupper
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063

-----Original Message-----

Sent: Monday, January 20, 2003 9:00 AM
To: Multiple recipients of list ORACLE-L

Create the view dba_nt_threads and query it, then run the monitor CPU per session. These are not my scripts --- I'm pretty sure that they were posted here by others --- but I did not capture the information on who originally wrote them. My apologies. HTH

--cr_dba_nt_threads.sql

                      Hussain Ahmed


                      Qadri <hussain           To:      Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>
                      @skm.org.pk>             cc:


                      Sent by: root            urgent






                      01/20/2003 12:44


                      AM


                      Please respond


                      to ORACLE-L











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: Thomas Day
  INET: tday6_at_csc.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: Thomas Day
  INET: tday6_at_csc.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 - 11:04:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US