O'Reilly logo

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos by Porus Homi Havewala

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required