Steve Howard wrote:
> 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
A good idea if the OP is licensed to access the AWR. If not you just
asked them to violate their Oracle license. Be very careful. You might
cost a company a lot of money ... and a well meaning person their job.
--
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 - 23:59:12 CST
