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.
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.
Perform the following prerequisite steps as necessary:
-
Open the Oracle Cloud Infrastructure console by clicking the
next to Oracle Cloud.
- From the Oracle Cloud Infrastructure left navigation list click either Autonomous Data Warehouse, Autonomous Transaction Processing, or Autonomous JSON Database depending on the workload type of your Autonomous Database.
-
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:
- On the Details page, under Resources, click Metrics.
- 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.
-
Open the Oracle Cloud Infrastructure console by clicking the
next to Oracle Cloud.
-
From the left navigation list click Monitoring > Service Metrics.
To use the metrics service to view Autonomous Database metrics:
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.