OEM Host CPU was a bottleneck and the instance was consuming 9% of the host
367662Sep 4 2008 — edited Sep 6 2008select * from DBA_ADVISOR_FINDINGS gives me something like this:
Host CPU was a bottleneck and the instance was consuming 9% of the host CPU. All wait times will be inflated by wait for CPU.
Individual SQL statements responsible for significant user I/O wait were found.
Wait class "User I/O" was consuming significant database time.
Individual database segments responsible for significant user I/O wait were found.
Wait class "User I/O" was consuming significant database time.
The throughput of the I/O subsystem was significantly lower than expected.
Wait class "User I/O" was consuming significant database time.
Individual database segments responsible for significant physical I/O were found.
The throughput of the I/O subsystem was significantly lower than expected.
Wait class "User I/O" was consuming significant database time.
Hard parsing of SQL statements was consuming significant database time.
SQL statements consuming significant database time were found.
I am confused by the message:
Host CPU was a bottleneck and the instance was consuming 9% of the host CPU.
Please help me to explain it.
Thanks.
Don