Monitor Databases with Autonomous Database Metrics

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

The Autonomous Database metrics help you measure useful quantitative data, such as CPU and storage utilization, the number of successful and failed database logon and connection attempts, database operations, SQL queries, and transactions, and so on. You can use metrics data to diagnose and troubleshoot problems with your Autonomous Database resources.

Prerequisites

To monitor resources, you must be given the required type of access in a policy written by an administrator, whether you're using the Console or the REST API with an SDK, CLI, or another tool.

You need the following policies to access the monitoring services and the resources being monitored:

Allow group <Group_Name>
to read metrics
in compartment <Compartment_Name>

Allow group <Group_Name>
to inspect work-requests
in compartment <Compartment_Name>

Tip:

If you try to perform an action and get a message that you don't have permission or are unauthorized, confirm with your administrator the type of access you've been granted and which compartment you should work in.

For common policies that give groups access to metrics, see Let users view metric definitions in a compartment and Restrict user access to a specific metric namespace.

For common policies that give groups access to Notifications, see Allow a group to manage topics, Allow a group to manage topic subscriptions, and Allow a group to publish messages to topics.

Using the Console

You can use Oracle Cloud Infrastructure console to:

• View Autonomous Database Metrics for a Database

• View Autonomous Database Metrics for Databases in a Compartment

Using the API

You can use the following APIs for monitoring:

• Monitoring API for metrics and alarms.

• Notifications API for notifications (used with alarms).

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

Available Metrics: oci_autonomous_database

This topic describes the metrics emitted by the Database service in the oci_autonomous_database namespace.

Database service metrics for Autonomous Databases include the following dimensions:

• AUTONOMOUSDBTYPE

  The type of Autonomous Database, Autonomous Data Warehouse (ADW) or Autonomous Transaction Processing (ATP).

• deploymentType

  The Exadata infrastructure type, serverless or dedicated. When using the Console to view default metric charts for multiple Autonomous Databases, you must specify this dimension.

• DISPLAYNAME

  The friendly name of the Autonomous Database.

• REGION

  The region in which the Autonomous Database resides.

• RESOURCEID

  The OCID of the Autonomous Database.

• RESOURCENAME

  The name of the Autonomous Database.

The metrics listed in the following table are automatically available for any Autonomous Database that you create. You do not need to enable monitoring on the resource to get these metrics.

Note:

Valid alarm intervals are 5 minutes or greater due to the frequency at which these metrics are emitted. See To create an alarm for details on creating alarms.

In the following table, metrics that are marked with an asterisk (*) can be viewed only on the Service Metrics page of the Oracle Cloud Infrastructure console. All metrics can be filtered by the dimensions described in this topic.

Metric	Metric Display Name	Unit	Description	Collection Frequency
ApplyLag	Apply Lag	seconds	This metric displays (in seconds) how far the standby database is behind the primary database as of the time sampled.	NA
BlockChanges	DB Block Changes	changes per second	The average number of blocks changed per second.	NA
CpuTime*	CPU Time	seconds per second	Average rate of accumulation of CPU time by foreground sessions in the database over the time interval. Statistic: Mean Interval: 1 minute	NA
CpuUtilization	CPU Utilization	percent	The CPU usage 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. Statistic: Mean Interval: 1 minute	NA
CurrentLogons*	Current Logons	count	The number of successful logons during the selected interval. Statistic: Count Interval: 1 minute	1 minute
DBTime*	DB Time	seconds per second	The amount of time database user sessions spend executing database code (CPU Time + WaitTime). DB Time is used to infer database call latency, because DB Time increases in direct proportion to both database call latency (response time) and call volume. It is calculated as the average rate of accumulation of database time by foreground sessions in the database over the time interval. Statistic: Mean Interval: 1 minute	NA
ECPUsAllocated	ECPU Allocated	integer	The actual number of ECPUs allocated by the service during the selected interval of time.	NA
ExecuteCount	Execute Count	count	The number of user and recursive calls that executed SQL statements during the selected interval. Statistic: Sum Interval: 1 minute	NA
IOPS	IOPS	operations per second	The average number of I/O operations per second.	NA
IOThroughput	IO Throughput	MB per second	The average throughput in MB per second.	NA
LogicalBlocksRead	Logical Reads	reads per second	The average number of logical block reads ("db block gets" plus "consistent gets") per second. Includes buffered and direct I/O. Statistic: Sum Interval: 1 minute	NA
OCPUsAllocated	OCPU Allocated	integer	The actual number of OCPUs allocated by the service during the selected interval of time.	NA
ParsesByType	Parses By Type	parses per second	The number of hard or soft parses per second.	NA
ParseCount*	Parse Count (Total)	count	The number of hard and soft parses during the selected interval. Statistic: Sum Interval: 1 minute	1 minute
QueuedStatements	Queued Statements	count	The number of queued SQL statements, aggregated across all consumer groups, during the selected interval. Statistic: Sum Interval: 1 minute	NA
RedoSize	Redo Generated	MB per second	The Average amount of redo generated in MB per second.	NA
RunningStatements	Running Statements	count	The number of running SQL statements, aggregated across all consumer groups, during the selected interval. Statistic: Mean Interval: 1 minute	1 minute
Sessions	Sessions	count	The number of sessions in the database. Statistic: Sum Interval: 1 minute	1 minute
StorageAllocated*	Storage Space Allocated	GB	Maximum amount of space allocated to the database during the interval. Statistic: Max Interval: 1 hour	1 hour
StorageAllocatedByTablespace*	Allocated Storage Space By Tablespace	GB	Maximum amount of space allocated for each tablespace during the interval.	NA
StorageUsed*	Maximum Storage Space	GB	Maximum amount of space used during the interval. Statistic: Max Interval: 1 hour	1 hour
StorageUsedByTablespace*	Storage Space Used By Tablespace	GB	Maximum amount of space used by each tablespace during the interval.	NA
StorageUtilization	Storage Utilization	percent	The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. Statistic: Mean Interval: 1 hour	1 hour
StorageUtilizationByTablespace*	Storage Space Utilization By Tablespace	percent	The percentage of space utilized by each tablespace.	NA
TransactionsByStatus	Transactions By Status	transactions per second	The number of committed or rolled back transactions per second.	NA
TransactionCount*	Transaction Count	count	The combined number of user commits and user rollbacks during the selected interval. Statistic: Sum Interval: 1 minute	1 minute
TransportLag	Transport Lag	seconds	The approximate number of seconds of redo not yet available on the standby database as of the time sampled.	1 minute
UserCalls*	User Calls	count	The combined number of logons, parses, and execute calls during the selected interval. Statistic: Sum Interval: 1 minute	1 minute
WaitTime*	Wait Time	seconds per second	Average rate of accumulation of non-idle wait time by foreground sessions in the database over the time interval. Statistic: Mean Interval: 1 minute	1 minute

---

Title and Copyright Information

Monitor Databases with Autonomous Database Metrics

Copyright © 2021, 2023, Oracle and/or its affiliates.