Re: Database Processes at 100% CPU

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 27 Nov 2007 03:16:12 GMT
Message-ID: <0_L2j.27923$L15.4389@newsfe08.phx>

howard <pkowal74_at_gmail.com> wrote in news:100a49ae-2a0f-44ba-84e0- 095e185cf895_at_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?

If you are running V10.2.0.1 , then this may be a known bug; especially if OS uptime was at or over 200 days. AFAIK, the only known fix is to upgrade to V10.2.0.2. Received on Mon Nov 26 2007 - 21:16:12 CST