Autonomous AI Database Activity Overview
The Autonomous AI Database activity overview dashboard provides a consolidated view of database activity, workload, and resource utilization for a single Autonomous AI Database over a specified time period.
To access the Autonomous AI Database activity overview dashboard from the Managed database details page of the Autonomous AI Database, click More actions, Dashboards, and then click Autonomous AI Database Activity Overview.
In Management Dashboards, the Autonomous AI Database activity overview dashboard is available for all Autonomous AI Databases, including those for which Diagnostics & Management is not enabled.
In the Autonomous AI Database activity overview dashboard:
- Select a time period for which you want to display data in the widgets. By default, the widgets in the dashboard display data for the last 60 minutes, however, you can select a different time period in the upper-right corner of the dashboard.
- Review the options selected in the Compartment
and Autonomous AI Database fields above the widgets and make
changes, if required. If the Compartment and
Autonomous AI Database fields are not displayed, click
the Open/close filter panel icon (
) to view them.
- Click Performance Hub in the banner below the filters to perform deeper analysis of the selected Autonomous AI Database using ASH Analytics, SQL Monitor, and ADDM. When you close Performance Hub, you return to the Autonomous AI Database activity overview dashboard.
The top row of the Autonomous AI Database activity overview dashboard displays summary tiles. The widgets below the summary tiles display charts with additional details for the selected time period.
| Widget | Description |
|---|---|
| Running statements |
The number of running SQL statements, aggregated across all consumer groups. The tile displays a summary value aggregated over the last five minutes and a chart for the selected time period. |
| Queued statements | The number of queued SQL statements, aggregated across all consumer groups. The tile displays a summary value aggregated over the last five minutes and a chart for the selected time period. |
| CPU utilization (%) | The percentage of CPU utilized. The tile displays a summary value aggregated over the last five minutes and a chart for the selected time period. |
| Average Active Sessions |
The average rate of accumulation of database time (CPU + Wait) by foreground sessions. The tile displays a summary value aggregated over the last five minutes and a chart for the selected time period. |
| Storage |
The total storage utilized as a percentage of the allocated storage and the total allocated storage. The widget displays summary data aggregated over the last five minutes. |
| ECPU allocated |
The amount of elastic CPU (ECPU) allocated. |
| CPU utilization (%) |
The percentage of CPU utilized by the database, broken down by consumer group. |
| CPU and wait (AAS) |
The CPU time and wait time used by foreground sessions in the database, broken down by CPU, user I/O, and wait activity. |
| Running statements |
The number of running SQL statements for the database, broken down by consumer group. |
| Queued statements |
The number of queued SQL statements for the database, broken down by consumer group. |