Use Autonomous Database Metrics to Monitor Databases

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

View Autonomous Database Metrics for a Database

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.

  1. Go to the Details page of the Autonomous Transaction Processing dedicated database whose metrics you want to view.
  2. On the Details page, under Resources, select Metrics.
  3. 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 Autonomous Database Metrics for 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.

  1. Sign in to your Oracle Cloud Account at cloud.oracle.com.
  2. Click the Menu icon menu icon in the top corner to display the navigation menu, then click Monitoring and then click Service Metrics.
  3. If needed, switch to the region hosting the dedicated databases whose metrics you want to view.

    See Switching Regions for information on switching regions and working in multiple regions.

  4. If needed, switch to the compartment hosting the dedicated databases whose metrics you want to view.

    See Compartments for information on using and managing compartments.

  5. Under Metric Namespace select oci_autonomous_database.
  6. Specify Dedicated as the deploymentType dimension.
    1. Next to Dimensions select Add.
    2. In the Dimension Name field select deploymentType.
    3. In the Dimension Value field select Dedicated.
    4. Click Done.
  7. If there are multiple Autonomous Databases in the compartment you can show metrics aggregated across the Autonomous Databases by selecting Aggregate Metric Streams.
  8. If you want to limit the metrics you see, add more dimensions.

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.