Observe Autonomous Database on Dedicated Exadata Infrastructure with Autonomous Database Metrics
You can observe the health, capacity, and performance of your Autonomous Databases with metrics, alarms, and notifications. You can use Oracle Cloud Infrastructure console or observability 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.
Related Topics
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.
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 API
-
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.
- AUTONOMOUSDBTYPE
The type of Autonomous Database, Autonomous Data Warehouse (ADW) or Autonomous Transaction Processing (ATP).
- deploymentType
The Exadata infrastructure type, shared 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. Statistic: Mean Interval: 5 minutes |
5 minutes |
BlockChanges |
DB Block Changes |
changes per second |
The average number of blocks changed per second. Statistic: Mean Interval: 1 minute |
5 minutes |
BlockingSessions |
Blocking Sessions Count |
count |
The number of sessions that have been blocking other sessions for more than 60 seconds. Statistic: Max Interval: 1 minute |
5 minutes |
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 |
5 minutes |
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 |
5 minutes |
CurrentLogons *
|
Current Logons |
count |
The number of successful logons during the selected interval. Statistic: Sum Interval: 1 minute |
5 minutes |
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 (CPU + Wait) by foreground sessions in the database over the time interval. It is also known as Average Active Sessions. |
5 minutes |
ECPUsAllocated |
ECPUs Allocated |
count |
The actual number of ECPUs allocated by the service during the selected interval of time. Statistic: Count Interval: 5 minutes |
5 minutes |
ExecuteCount |
Execute Count |
count |
The number of user and recursive calls that executed SQL statements during the selected interval. Statistic: Sum Interval: 1 minute |
5 minutes |
HardParseCount |
Parse Count (Hard) |
count |
Currently allocated CPUs count. Statistic: Sum Interval: 1 minute |
5 minutes |
IOPS |
IOPS |
operations per second |
The average number of I/O operations per second. Statistic: Mean Interval: 1 minute |
5 minutes |
IOThroughput |
IO Throughput |
MB per second |
The average throughput in MB per second. Statistic: Mean Interval: 1 minute |
5 minutes |
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: Mean Interval: 1 minute |
5 minutes |
LogicalReads |
Session Logical Reads |
count |
The sum of "db block gets" plus "consistent gets", during the selected time interval. This includes logical reads of database blocks from either the buffer cache or process private memory. Statistic: Sum Interval: 1 minute |
5 minutes |
OCPUsAllocated |
OCPU Allocated |
integer |
The actual number of OCPUs allocated by the service during the selected interval of time. Statistic: Count Interval: 1 minute |
5 minutes |
ParsesByType |
Parses By Type |
parses per second |
The number of hard or soft parses per second. Statistic: Mean Interval: 1 minute |
5 minutes |
ParseCount *
|
Parse Count (Total) |
count |
The number of hard and soft parses during the selected interval. Statistic: Sum Interval: 1 minute |
5 minutes |
ParseFailureCount |
Parse Failures Count |
count |
The number of parse failures during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
PhysicalReads |
Physical Reads |
count |
The number of data blocks read from disk, during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
PhysicalReadTotalBytes |
Physical Read Total Bytes |
count |
The size in bytes of disk reads by all database instance activity including application reads, backup and recovery, and other utilities, during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
PhysicalWrites |
Physical Writes |
count |
The number of data blocks written to disk, during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
PhysicalWriteTotalBytes |
Physical Write Total Bytes |
count |
The size in bytes of all disk writes for the database instance including application activity, backup and recovery, and other utilities, during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
QueuedStatements |
Queued Statements |
count |
The number of queued SQL statements, aggregated across all consumer groups, during the selected interval. Statistic: Sum Interval: 1 minute |
5 minutes |
RedoGenerated |
Redo Generated |
count |
Amount of redo generated in bytes, during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
RedoSize |
Redo Generated |
MB per second |
The Average amount of redo generated in MB per second. Statistic: Mean Interval: 1 minute |
5 minutes |
RunningStatements |
Running Statements |
count |
The number of running SQL statements, aggregated across all consumer groups, during the selected interval. Statistic: Sum Interval: 1 minute |
5 minutes |
Sessions |
Sessions |
count |
The number of sessions in the database. Statistic: Sum Interval: 1 minute |
5 minutes |
SessionUtilization |
Session Utilization |
Percent |
The maximum session utilization expressed as a percentage, aggregated across all consumer groups. Statistic: Mean Interval: 1 minute |
5 minutes |
SQLNetBytesFromClient |
SQL Net Bytes Received from Client |
count |
The number of bytes received from the client over Oracle Net Services, during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
SQLNetBytesFromDBLink |
SQL Net Bytes Received from DBlink |
count |
The number of bytes received from a database link over Oracle Net Services, during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
SQLNetBytesToClient |
SQL Net Bytes Sent to Client |
count |
The number of bytes sent to the client from the foreground processes, during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
SQLNetBytesToDBLink |
SQL Net Bytes Sent to DBlink |
count |
The number of bytes sent over a database link, during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
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. Statistic: Max Interval: 1 hour |
1 hour |
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. |
1 hour |
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. Statistic: Mean Interval: 1 hour |
1 hour |
TransactionsByStatus |
Transactions By Status |
transactions per second |
The number of committed or rolled back transactions per second. Statistic: Mean Interval: 1 minute |
5 minutes |
TransactionCount *
|
Transaction Count |
count |
The combined number of user commits and user rollbacks during the selected interval. Statistic: Sum Interval: 1 minute |
5 minutes |
TransportLag |
Transport Lag |
seconds |
The approximate number of seconds of redo not yet available on the standby database as of the time sampled. Statistic: Mean Interval: 5 minutes |
5 minutes |
UserCalls *
|
User Calls |
count |
The combined number of logons, parses, and execute calls during the selected interval. Statistic: Sum Interval: 1 minute |
5 minutes |
UserCommits |
User Commits |
count |
The number of user commits during the selected time interval. Statistic: Sum Interval: 1 minute |
5 minutes |
UserRollbacks |
User Rollbacks |
count |
Number of times users manually issue the Statistic: Sum Interval: 1 minute |
5 minutes |
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. The wait time component of Average Active Sessions. Statistic: Mean Interval: 1 minute |
5 minutes |