1. Using Oracle Database Management for Autonomous Databases
  2. Monitor and Diagnose the Performance of Autonomous Databases
  3. Monitor Workload Metrics

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 cpu-statistics.png follows
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.