View Autonomous Database Metrics for Databases in a Compartment

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

Required IAM Policies

  • read metrics

  • inspect work-requests

See Prerequisites for Monitoring Autonomous Database Metrics for more details.

Procedure

  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 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 databases whose metrics you want to view.

    See Understanding 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.