Overview
There is a new OEM report called
.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
is accessed, through OEM, via the pull-down menu as shown below:
ASH Analytics Page
A sample
page is shown below: