Re: Database Processes at 100% CPU

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Mon, 26 Nov 2007 16:47:35 -0800 (PST)
Message-ID: <bc3d155a-11e6-47b3-90cb-2733741c5ede@y43g2000hsy.googlegroups.com>

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 Received on Mon Nov 26 2007 - 18:47:35 CST