Autonomous Database Performance

The Autonomous Database performance dashboard provides an overview of the performance of a single Autonomous Database over a specified time period.

To access the Autonomous Database performance dashboard from the Managed database details page of the Autonomous Database, click Dashboards and then click Autonomous Database performance.

In the Autonomous Database performance dashboard:

  • Select a time period for which you want to display data in the widgets. By default, the widgets in the dashboard display performance 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 Database fields above the widgets and make changes, if required. If the Compartment and Autonomous Database fields are not displayed, click the Open/close filter panel icon (Open/close filter panel) to view them.

Here's the list of widgets displayed in the Autonomous Database performance dashboard and a brief description of each widget.

Widget Description
Average Active Sessions

The average rate of accumulation of database time (CPU + Wait) by foreground sessions.

CPU utilization (%)

The percentage of CPU utilized, aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use.

CPU and wait (AAS)

The CPU time, wait time, and user I/O time used by foreground sessions in a single database.

Storage usage (GB)

The maximum amount of storage space used.

User calls

The total number of parse, logon and execute calls.

Current logons

The number of successful logons.

Transactions

The total number of user commits and user rollbacks.

Parse count

The total number of hard and soft parses.

Sessions

The number of sessions in the database.

Execution count

The total number of user and recursive calls that executed SQL statements.

Running statements

The number of running SQL statements, aggregated across all consumer groups.

Queued statements

The number of queued SQL statements, aggregated across all consumer groups.