Monitor Workload Metrics
On the Workload tab, you can monitor the various metrics supported for Autonomous Databases.
The metrics are displayed in the following charts:
- CPU Statistics
- Wait Time Statistics
- Workload Profile
- Sessions
On these charts you can view a metric by selecting it from the drop-down list above
the chart. For example, on the CPU Statistics chart, you can view
the CPU Utilization (%) and CPU Usage
metrics.
Description of the illustration cpu-statistics.png
The following table lists and provides more information on all the metrics that can be monitored on the Workload tab.
Chart | Metric | Unit | Description |
---|---|---|---|
CPU Statistics | CPU Utilization (%) | Percentage | The CPU utilization expressed as a percentage, aggregated across all consumer groups. This metric is reported based on the number of CPUs the database is allowed to use, which is two times the number of OCPUs. |
CPU Usage | Seconds per second | The average rate of accumulation of CPU time by foreground sessions in the database over the time interval. This is the CPU time component of Average Active Sessions. | |
Wait Time Statistics | Wait Time Statistics | Seconds per second | The average rate of accumulation of non-idle wait time by foreground sessions in the database over the time interval. This is the wait time component of Average Active Sessions. |
Database Time | Seconds per second | The average rate of accumulation of database time (CPU + Wait) by foreground sessions in the database over the time interval. This is also known as Average Active Sessions. | |
Workload Profile | User Calls | Per second | The combined number of logons, parses, and execute calls per second. |
Executions | Per second | The number of user and recursive calls that executed SQL statements per second. | |
Transactions | Per second | The combined number of user commits and user rollbacks per second. | |
Parse Count | Per second | The number of hard and soft parses per second. | |
Running Statements | Per second | The number of running SQL statements aggregated across all consumer groups per second. | |
Queued Parallel Statements | Per second | The number of queued parallel SQL statements aggregated across all consumer groups per second. | |
Sessions | Session Count | Per second | The number of sessions in the database per second. |
Current Logons | Per second | The number of successful logons per second. |