Diagnose performance issues using ASH enhancements

Overview

There is a new OEM report called ASH Analytics.

References

Reading Notes

"2.6.1.1 Enterprise Manager Database Express" says:

Enterprise Manager Database Express greatly simplifies database performance diagnostics by consolidating the relevant database performance screens into a consolidated view called the database Performance Hub. DBAs get a single, consolidated view of the current real-time and historical view of the database performance across multiple dimensions such as database load, monitored SQL and PL/SQL, and Active Session History (ASH) in a single page for the selected time period.

"Performance Diagnostics Enhancements" says:

With the interactive user interface in the Active Session History (ASH) Viewer, users now can visualize the many performance dimensions that were not available to them in earlier releases. The Enhanced Enterprise Manager Performance and Top Activity pages allow users to visualize the multidimensional data in ASH. The ASH viewer enhances the performance troubleshooting capabilities of a DBA by providing the facility to detect skews in workload. Emergency ADDM adds performance diagnostics for databases suffering from severe performance problems.

The main enhancement is the provision of ASH analytics.

Procedure

Access ASH Analytics

ASH Analytics is accessed, through OEM, via the Performance pull-down menu as shown below:

Access ASH Analytics via OEM Performance pull-down menu

ASH Analytics Page

A sample ASH Analytics page is shown below:

Sample ASH analytics page