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!

What is the OEM telling me?

mcslainMar 23 2011 — edited Mar 24 2011
I am trying to figure out how to properly read OEM's Performance graph. During a point of high activity on my database, users complained of having very slow query times and some unresponsiveness from our application. OEM shows high levels of Network, Application, User I/O, CPU and CPU Wait.

My interpretation is:
Network - We have users all over the US and Canada so maybe some of this is to be expected.
CPU and CPU Wait - My server was maxed out so increasing the SGA size could eliminate this problem in the future.

So maybe the assessment above is correct, but if I am wrong I welcome any suggestions.

As for Application and User I/O I am not sure what this is telling me. Any guidance here would be greatly appreciated.

Here is a link to what the OEM graph looks like: https://sites.google.com/site/redroseraces/oem.tif

Thanks, and sorry if this isn't the correct place to post this, but I could not find a more appropriate forum.

mcslain
This post has been answered by Aman.... on Mar 24 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2011
Added on Mar 23 2011
8 comments
1,056 views