Monitor Performance with Autonomous Database Metrics

You can monitor the health, capacity, and performance of your databases with metrics, alarms, and notifications. You can use Oracle Cloud Infrastructure Console or Monitoring APIs to view metrics.

View Metrics for an Autonomous Database Instance

Shows the steps to view the Autonomous Database metrics.

Note:

To view metrics you must have the required access as specified in an Oracle Cloud Infrastructure policy (whether you're using the Console, the REST API, or another tool). See Getting Started with Policies for information on policies.

Perform the following steps as necessary:

  • Open the Oracle Cloud Infrastructure Console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation menu click Oracle Database and then, depending on your workload click one of: Autonomous Data Warehouse, Autonomous JSON Database, or Autonomous Transaction Processing.
  • On the Autonomous Databases page select an Autonomous Database from the links under the Display Name column.

To view metrics for an Autonomous Database instance:

  1. On the Details page, under Resources, click Metrics.
  2. There is a chart for each metric. In each chart you can select the Interval and Statistic or use the default values.

The following list shows the default Oracle Cloud Infrastructure Console metrics. See Database Metrics for a list of the database metrics and dimensions.

Metric Name Description

CPU Utilization

CPU utilization expressed as a percentage, aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use, which is two times the number of OCPUs.

Storage Utilization

The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.

Sessions

The number of sessions in the database.

Execute Count

The number of user and recursive calls that ran SQL statements during the selected interval.

Running Statements

The number of running SQL statements, aggregated across all consumer groups, during the selected interval.

Queued Statements

The number of queued SQL statements, aggregated across all consumer groups, during the selected interval.

Database Availability

The database is available for connections during the selected time interval (data for this metric lags by 1 hour). Possible values for this metric:

  • 1 = Database is Available
  • 0 = Database is Unavailable

You can set an alarm that is triggered if the database is not available (value 0).

Note:

Availability is calculated based on the "Monthly Uptime Percentage" described in the Oracle PaaS and IaaS Public Cloud Services Pillar Document, under Autonomous Database Availability Service Level Agreement.

Failed Connections

Shows the total number of failed connections to the database during the selected interval.

To create an alarm on a metric, click Options and select Create an Alarm on this Query. See Managing Alarms for information on setting and using alarms.

For more information about metrics see Database Metrics.

You can also use the Monitoring API to view metrics. See Monitoring API for more information.

View Metrics for Autonomous Databases in a Compartment

Shows the steps to view metrics for Autonomous Databases in a compartment.

To view metrics you must have the required access as specified in an Oracle Cloud Infrastructure policy (whether you're using the Console, the REST API, or other tool). See Getting Started with Policies for information on policies.

  • Open the Oracle Cloud Infrastructure Console by clicking the navigation icon next to Oracle Cloud.

  • From the left navigation list click Observability & Management. Under Monitoring, click Service Metrics.

To use the metrics service to view Autonomous Database metrics:

  1. On the Service Metrics page, under Compartment select your compartment.
  2. On the Service Metrics page, under Metric Namespace select oci_autonomous_database.
  3. If there are multiple Autonomous Databases in the compartment you can show metrics aggregated across the Autonomous Databases by selecting Aggregate Metric Streams.
  4. If you want to limit the metrics you see, next to Dimensions click Add (click Edit if you have already added dimensions).
    1. In the Dimension Name field select a dimension.
    2. In the Dimension Value field select a value.
    3. Click Done.

    In the Edit dimensions dialog click +Additional Dimension to add an additional dimension. Click x to remove a dimension.

To create an alarm on a specific metric, click Options and select Create an Alarm on this Query. See Managing Alarms for information on setting and using alarms.

Autonomous Database Metrics and Dimensions

You can limit the instances where you see metrics with dimensions. The available dimensions include: workload type, instance display name, region, and the instance OCID.

Use dimensions by selecting values in the Oracle Cloud Infrastructure Console Service Metrics page or by setting dimension values with the API. See View Metrics for Autonomous Databases in a Compartment to view metrics and to select metric dimensions.

See Database Metrics for a list of the database metrics and dimensions.