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

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Processes at 100% CPU

Re: Database Processes at 100% CPU

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 26 Nov 2007 21:59:12 -0800
Message-ID: <1196143145.793994@bubbleator.drizzle.com>


Steve Howard wrote:
> On Nov 26, 5:55 pm, howard <pkowa..._at_gmail.com> wrote:

>> I am running a standalone 10g R1 instance on RHEL 4 box. I have not
>> made any recent changes to the database or changes
>> to the application SQL. Everything seemed to be running properly. Then
>> one night, the core Oracle processes (SMON, PMON, MMON...)
>> started taking 100% of the CPU. I killed every non-critcal Oracle
>> process and still I had 100%. The server was so maxxed out on
>> CPU that I could not even log into sqlplus, it would just hang.
>>
>> I was left to do a cold restart on the server.
>>
>> That fixed this issue, but I'm still a little concerned. I saw nothing
>> in the alert log that indicated a problem. Even on EM, nothing
>> indicated a problem.
>>
>> What would cause this type of situation?

>
> Hi,
>
> Can you run an AWR report for each of the periods leading up to the
> hang? MMON probably stopped gathering data when it got "bad enough",
> but perhaps the activity leading up to the hang would provide some
> insight.
>
> HTH,
>
> Steve

A good idea if the OP is licensed to access the AWR. If not you just asked them to violate their Oracle license. Be very careful. You might cost a company a lot of money ... and a well meaning person their job.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Nov 26 2007 - 23:59:12 CST

Original text of this message

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