Database has been consuming 90 - 95% of the CPU
Environment is : Oracle 10.2.0.4 on HP-UX.
Our sys admin set out an email saying the database is using 90 -95% of teh CPU consistently. Wher e can I start doing the research?
More info from OEM Snapshot report:
Host CPU was a bottleneck and the instance was consuming 15% of the host CPU. All wait times will be inflated by wait for CPU.
Please advice as to how I can go about looking at this message.
Thank you.
Edited by: 860412 on May 31, 2011 10:48 AM