Database Processes at 100% CPU

From: howard <pkowal74_at_gmail.com>
Date: Mon, 26 Nov 2007 14:55:04 -0800 (PST)
Message-ID: <100a49ae-2a0f-44ba-84e0-095e185cf895@i12g2000prf.googlegroups.com>

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? Received on Mon Nov 26 2007 - 16:55:04 CST