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. - View Metrics for Autonomous Databases in a Compartment
Shows the steps to view metrics for Autonomous Databases in a compartment. - 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.
Parent topic: Monitor and Manage Performance
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 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 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:
- 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.
The following list shows the default Oracle Cloud Infrastructure Console metrics. See Available Metrics: oci_autonomous_database 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 the number of ECPUs. If your database uses OCPUs, the number of CPUs allowed 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 5 minutes). Possible values for this metric:
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 document under Delivery Policies (see Autonomous Database Availability Service Level Agreement). |
Regional Availability |
Shows the average availability percentage of Autonomous Databases across a set of services in each region, ensuring that regions are performing as per Service Level Agreement. Availability data is updated daily for each region. |
Failed Connections |
Shows the total number of failed connections to the database during the selected interval. A connection is counted as failed when a connection attempt
reaches the database and logs any of the following errors:
|
Optionally, to view all the Autonomous Database metrics:
-
In the Metrics area click View all database metrics.
-
In the Metric namespace dropdown, select oci_autonomous_database.
-
Next to Dimensions, click Add.
-
In the Edit dimensions dialog, for deploymentType select Shared.
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 Available Metrics: oci_autonomous_database.
You can also use the Monitoring API to view metrics. See Monitoring API for more information.
- View Logs and Audit Trails
Shows the steps to view the Autonomous Database logs and audit trails.
Parent topic: Monitor Performance with Autonomous Database Metrics
View Logs and Audit Trails
Shows the steps to view the Autonomous Database logs and audit trails.
To view logs and audit trials 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.
To view audit trails and logs for an Autonomous Database instance:
- On the Details page, under Resources, click Metrics.
- In the Metrics area click View audit and logs.
- In the Logging area, click Logs to view log information.
- In the logging area, click Audit to view audit information.
See Audit Autonomous Database and Audit Logs for more information.
Parent topic: View Metrics for an Autonomous Database Instance
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 Observability & Management. Under Monitoring, click 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.
Parent topic: Monitor Performance with Autonomous Database Metrics
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.
Parent topic: Monitor Performance with Autonomous Database Metrics