OEM shows 100% CPU Utilization
Running Oracle 10.2.0.3.0 on HP UX 11.23. OEM has shown CPU% at 100% for over 2 full days.
I looked at Workload Report for a 1 hour period and determined CPU usage for the 1 hour period to be 17%.
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 53151 30-Jan-14 10:00:40 39 11.7
End Snap: 53152 30-Jan-14 11:01:01 37 7.6
Elapsed: 60.37 (mins)
DB Time: 52.29 (mins)
Top 5 Timed Events
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time 1,252 39.9
db file scattered read 185,056 1,018 6 32.5 User I/O
db file sequential read 145,803 395 3 12.6 User I/O
log file parallel write 1,419 26 18 .8 System I/O
control file parallel write 1,311 22 17 .7 System I/O
Operating System Statistics
Statistic Total