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 15:33:04 -0800
Message-ID: <1196119977.650030@bubbleator.drizzle.com>


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.org
Received on Mon Nov 26 2007 - 17:33:04 CST

Original text of this message

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