Diagnose performance issues using ASH enhancements
Overview
References
- Database New Features Guide
- Oracle® Enterprise Manager Cloud Control Introduction 12c Release 1 (12.1.0.2)
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:
ASH Analytics Page
A sample ASH Analytics page is shown below: