Filter Average Active Sessions Data

The Average Active Sessions data is displayed by the dimension selected in the drop-down list. To analyze the data better, you can further filter the data displayed on the chart by the various components displayed in the legend to the right of the chart.

  1. Go to the Performance Hub.
  2. In the ASH Analytics tab, select a dimension in the Average Active Sessions by drop-down list. By default, Consumer Group is selected.
    The chart is displayed and each color in the chart denotes a component of the selected dimension. These components are also listed in a legend to the right of the chart. For example, the Consumer Group dimension has High, Medium, and Low, which are predefined service names assigned to your Autonomous Database entity to provide different levels of concurrency and performance.
  3. Click a component in the legend.
    The selected component is displayed in the Applied Filters field and the chart is updated to only display data pertaining to that component. The total activity, which includes all the components of the dimension, is denoted by a black outline and is displayed by default when you filter data.