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: Database using 100% of CPU

RE: Database using 100% of CPU

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Mon, 20 Aug 2001 08:26:36 -0700
Message-ID: <F001.00370E3A.20010820075210@fatcity.com>

the OEM with 9i, works beautifully(at least on linux) :)
 

joe
>>> tday6_at_csc.com 08/20/01 10:51AM >>>Are you using the OEM that came with 8.1.6?  I have a dim memory that theJAVA executable that powers that version of OEM had a flaw that couldconsume 100%

of the CPU.  Personally, I don't use OEM versions after 
8.1.5.HTH                                                                                           

                   
Christopher                                                           
                   
Spence               To:     Multiple recipients of list ORACLE-L     
                   

<cspence_at_Fuel       
<ORACLE-L_at_fatcity.com>                            

                   
Spot.com>            cc:                                              
                   
Sent by:             Subject:     RE: Database using 100% of
CPU      
                   
root_at_fatcity.                                                          

                   
com                                                                   
                                                                                          
                                                                                          
                   
08/17/2001                                                            
                   

04:34
PM                                                               

                   
Please                                                                
                   

respond
to                                                             

                   
ORACLE-L                                                              
                                                                                          
                                                                                          
It sounds like you may need more ram."Do not criticize someone until you walked a mile in their shoes, that waywhen you criticize them, you are a mile a way and have their shoes."Christopher R. SpenceOracle DBAPhone: (978) 322-5744Fax:    (707) 885-2275Fuelspot73 Princeton StreetNorth, Chelmsford 01863-----Original Message-----Sent: Friday, August 17, 2001 3:22 PMTo: Multiple recipients of list ORACLE-LI've looked at the server.  Total Commit Charge is 574968.  Total PhysicalMemory is 523680.  I can see that it's over, but what am I looking at?  Iunderstand physical memory, but the help on 'Commit Memory' inwindows is less than helpful.Do I need to reboot the
box?Thanx,Mike---===========================================================================Michael 
P. VergaraOracle DBAGuidant Corporation(909) 914-2304-----Original Message-----Sent: Friday, August 17, 2001 11:08 AMTo: Multiple recipients of list ORACLE-LHow much memory is being used, vs. available physical RAM?Check Task Manager | Performance tab, compare Commit Charge Total (LLcorner) vs. Physical Memory Total (UR corner).You should stay below physical RAM as much as possible, because Oraclereally does not like NT virtual memory.Patrice BoivinSystems Analyst (Oracle Certified DBA)     -----Original
Message-----     From:     Vergara,
Michael (TEM) [SMTP:mvergara_at_guidant.com]     Sent:     Friday, August 17, 2001 2:41
PM     To:  Multiple recipients of list ORACLE-L     Subject:  RE: Database using 100% of CPU     Steven:     I
also have this happen on one of our smaller DBs running NT.  Ihaven't     found a cause yet either.  Rebooting seems (so far) to be the onlycure.     If you get any replies would you please summarize to the list?     Thanx,    
Mike    
---===========================================================================     
Michael P. Vergara     Oracle
DBA     Guidant Corporation    
(909) 914-2304     -----Original
Message-----     Sent: Friday, August 17, 2001 9:41 AM     To: Multiple recipients of list
ORACLE-L     We are having a problem with our database - it is using 100% of theCPU.     This has only started happening recently, and restarting thedatabase    
temporarily     stops it happening - it usually recurrs a few hours later.     There are no jobs running, and at the moment there are no active    
connections.     Obviously something has kicked this off, can anyone shed any lighton this     or     suggest how to find out what is running on the db?     Thanks in
advance,     Steven
H.     (Oracle 8.1.6.0.0 EE on NT 4
SP5)     --     Please see
the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com     --     Author: Steven
Hovington       INET:
steven.hovington_at_procession.com     Fat City Network
Services    -- (858) 538-5051  FAX: (858) 
538-5051     San Diego, 
California        -- Public Internet access / 
MailingLists    
--------------------------------------------------------------------     
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: <A href="http://www.orafaq.com">http://www.orafaq.com     --     Author: Vergara, Michael
(TEM)       INET:
mvergara_at_guidant.com     Fat City Network
Services    -- (858) 538-5051  FAX: (858) 
538-5051     San Diego, 
California        -- Public Internet access / 
MailingLists    
--------------------------------------------------------------------     
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: <A href="http://www.orafaq.com">http://www.orafaq.com--Author: Boivin, Patrice J  INET: BoivinP_at_mar.dfo-mpo.gc.caFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing
Lists--------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from).  You may also send the HELPcommand for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author:
Vergara, Michael (TEM)  INET: mvergara_at_guidant.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing
Lists--------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from).  You may also send the HELPcommand for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author:
Christopher Spence  INET: cspence_at_FuelSpot.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing
Lists--------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com--
Author:   INET: tday6_at_csc.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing
Lists--------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing). Received on Mon Aug 20 2001 - 10:26:36 CDT

Original text of this message

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