Saturday, July 4, 2015

Managing Oracle Database 12c with Enterprise Manager – Part XV


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we started to look into the Performance Hub of Enterprise Manager Database Express 12c. Let us move to the Activity tab.
The red line shows the CPU cores used by this VBOX image, and obviously at a point of time this line has been exceeded. The total CPU wait class can be seen in green, the red part shows the concurrency wait class and so on.
We can drill down to the actual SQL Id and user session at this point of time. However, we can also change the top dimensions of this graph to the actual wait event, as seen below.
Notice that the graph has now changed to display the individual wait events such as db file sequential read, log file parallel write, row cache lock and so on. You can drill down further on any of these wait events and find the actual SQL and session causing the events. 
You can also change the lower dimension, here we have drilled down on the wait event: db file sequential read, and changed the lower dimension to “object” – this displays the objects causing this wait event, and also the SQL below. Pretty powerful.
You can select a number of other dimensions such as SQL ID, object, Instance, PDB, Service, User ID, and so on in this graph.
This blog post was originally published at this link.

No comments:

Disclaimer

Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive