Oracle Cloud Infrastructure Documentation

Average Active Sessions Data

To view Average Active Sessions Data by a selected dimension:

  1. Open the Performance Hub page from the database details page, if not already open.

    Note

    For more information about how to navigate to the Performance Hub page, see:

  2. You can adjust the time slider to select the time period for which performance data is displayed on the current tab.

    The ASH Analytics tab displays the top activity for a selected dimension in the selected time period.

    The Quick Select field helps you to quickly select from a set of predetermined time ranges (for example, Last Hour, Last 8 Hours, and so on) or set a different custom time range.

  3. Select a dimension in the ASH Dimension menu of the Average Active Sessions chart to display ASH analytics by that dimension.

    Optionally, you can:

    • Click the Maximum Threads check box to view the number of Max CPU Threads. The red line on the chart shows this limit.

    • Click the Total Activity check box to view a black border that denotes total activity of all the components of the selected dimension on the chart. This option is selected by default when you use the filtering capabilities to only view the data for a particular component within a dimension.

      For information about filtering capabilities, see Filter Average Active Sessions Data.

  4. Use the Sample Resolution menu to select the sampling of ASH data displayed in the Average Active Sessions chart. The data resolution selections are Low, Medium, High, and Maximum.

    For more information about sample resolutions, see ASH Analytics.

  5. For the dimension selected in the ASH Dimension menu of the Average Active Sessions chart, you can further drill down into session details by selecting dimensions in the two tables at the bottom of the ASH Analytics tab.

    By default, the following dimensions are selected for the two tables:

    • SQL ID - displays the SQL statements with the top average active sessions activity broken down by the main ASH dimension for the selected time period. You can right-click the bar charts to sort the SQL statements in ascending or descending order or click the SQL ID to go the SQL Details page.

    • User Session - displays the user sessions with the top average active sessions activity broken down by the main ASH dimension for the selected time period. You can right-click the bar charts to sort the user sessions in ascending or descending order or click the user session to go to the User Session page.

Filter Average Active Sessions Data

To filter Average Active Sessions Data:

  1. Open the Performance Hub page from the database details page, if not already open.

    Note

    For more information about how to navigate to the Performance Hub page, see:

  2. In the ASH Analytics tab, select a dimension in the ASH Dimension menu of the Average Active Sessions chart.
    Note

    By default, Consumer Group is selected for Autonomous Databases. For all other databases, Wait Class is selected by default.

    Each color in the chart denotes a component of the selected dimension. For example, the Consumer Group dimension has High, Medium, and Low, which are predefined service names assigned to your database 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.
    Note

    When ASH data is down sampled (maybe due to the selected data resolution), a new data request call is automatically triggered using the selected filters to ensure that precise data is displayed. Otherwise, filtering is performed on the UI layer only.

The total activity, which includes all the components of the dimension, is defined by a black outline and is displayed by default when you filter data.