Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database Processes at 100% CPU
howard 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?
10gR1 leaves a lot to the imagination.
Is that the initial release or have you been applying the patches released by Oracle?
-- 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.orgReceived on Mon Nov 26 2007 - 17:33:04 CST
![]() |
![]() |