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:

   • For Autonomous Database
   • For Base Database Service and Exadata Databases
   • For External Database Service

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.