Monitor Performance with Autonomous Database Metrics

You can monitor the health, capacity, and performance of your Autonomous Data Warehouse 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.

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.

To view metrics for an Autonomous Database instance:

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.

  • On the Autonomous Databases page select an Autonomous Data Warehouse instance from the links under the Name column.

  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.

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.

To use the metrics service to view Autonomous Database metrics:

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • From the left navigation list click Monitoring > Service 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.