Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OEM Host CPU was a bottleneck and the instance was consuming 9% of the host

367662Sep 4 2008 — edited Sep 6 2008
select * 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2008
Added on Sep 4 2008
6 comments
2,583 views