8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 12c » Here

Active Session History (ASH) Analytics in Oracle Enterprise Manager Cloud Control 12c

The Active Session History (ASH) was introduced in Oracle 10g to provide real-time diagnostics information. ASH Analytics is a feature of Enterprise Manager Cloud Control 12c, which visualises ASH information, making it even simpler to diagnose performance problems.

ASH Analytics is listed as requirement for the 1Z0-060 "Upgrade to Oracle Database 12c" OCP upgrade exam, hence this short overview for those who don't use Cloud Control.

ASH requires the Diagnostics and Tuning option in Enterprise Edition.

Once you've navigated to a database target, the "ASH Analytics" menu will be available under the "Performance" section.

ASH Analytics : Menu

 

  1. On the top-left of the page you will see buttons to quickly alter the monitoring period displayed in the overview graph.
  2. The greyed out, selected, area of the activity graph is expanded into a more detailed activity graph below.
  3. All the screens under the ASH Analytics section can be saved or emailed by pressing the relevant button.

ASH Analytics

 

  1. The edges of the selection on the overview graph can be repositioned by dragging them with your mouse. The expanded activity graph will refresh to match your selection.
  2. The dropdown allows you to alter the contents of the expanded activity graph.
  3. The dropdown allows you to customise the contents of this detail section.
  4. The dropdown allows you to customise the contents of this detail section.

ASH Analytics : Drill Down

The dropdowns contain the following metrics.

 

  1. Hovering over the expanded activity graph will highlight the section you are above. Clicking it will apply a filter and redraw the graph based on that filter.
  2. The filter can be removed by click the "X" on the filter.

ASH Analytics : Filters

 

  1. Clicking the "Load Map" button will redraw the activity as a load map.

ASH Analytics : Load Map

For more information see:

Hope this helps. Regards Tim...

Back to the Top.