Top activity
At any point in time, it is possible to go to Performance | Top Activity and display a view of the top SQL statements as well as top sessions. You can drag the highlighted bar to select the particular time required.
This screen looks similar to the drilldown from the Average Active Sessions section on the performance home page. However, the difference is that all the wait events can be seen against the time in this graph, on the Top Activity page. This data is fully sourced from the ASH information in the database. The text in the following screenshot may not be fully readable, but it has been included for the purpose of illustration:
Another difference is the presence of the Run ASH Report button on this page. This allows you to generate ...
Get Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
