Available Metrics: oci_autonomous_database
This topic describes the metrics emitted by the Database service in the oci_autonomous_database namespace.
To access a subset of the metrics from the Autonomous AI Database details page:
See View Metrics for an Autonomous AI Database Instance for details.
To access the complete metrics for the service:
See View Metrics for Autonomous AI Databases in a Compartment for details.
To access the metrics from the Metrics Explorer:
-
Open the Oracle Cloud Infrastructure Console by clicking the
next to Cloud. -
From the Oracle Cloud Infrastructure left navigation menu click Observability & Management.
-
On the Observability & Management page, under Monitoring, select Metrics Explorer.
-
Use the Metrics Explorer to create a query and enter the Metric namespace value
oci_autonomous_database. -
Under Metric dimensions enter the deploymentType value Shared.
-
Enter a value in the Metric name field.
Database service metrics for Autonomous AI Databases include the following dimensions:
-
AUTONOMOUSDBTYPE
The type of Autonomous AI 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 AI Databases, you must specify this dimension.
This topic covers Oracle Autonomous AI Database Serverless metrics. See Monitor Databases with Autonomous AI Database Metrics for information on Oracle Autonomous AI Database on Dedicated Exadata Infrastructure metrics.
-
DISPLAYNAME
The friendly name of the Autonomous AI Database.
-
REGION
The region in which the Autonomous AI Database resides.
-
RESOURCEID
The OCID of the Autonomous AI Database.
-
RESOURCENAME
The name of the Autonomous AI Database.
The metrics listed in the following table are automatically available for any Autonomous AI 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.
All metrics can be filtered by the dimensions described in this topic.
| Metric | Metric Display Name | Unit | Description | Collection Frequency |
|---|---|---|---|---|
AverageActiveSessions |
Average Active Sessions | integer | The average number of sessions that are actively executing or waiting for resources. Statistic: Mean Interval: 1 minute |
1 minute |
BlockingSessions |
Blocking Sessions | count | The number of sessions that have been blocking other sessions for more than 60 seconds. Statistic: Max Interval: 1 minute |
1 minute |
Connectionlatency |
Connection Latency | Milliseconds | The time taken to connect to an Autonomous AI Database instance in each region from a VM in the same region. Statistic: Max Interval: 5 minutes |
|
ConnectionsDroppedByClient |
Connections Dropped By Client | count | The number of connections dropped by the client. Statistic: Sum Interval: 1 minute |
1 minute |
ConnectionsDroppedByServer |
Connections Dropped By Server | count | The number of connections dropped by the server. Statistic: Sum Interval: 1 minute |
1 minute |
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 |
DatabaseAvailability |
Database Availability | count | The database is available for connections during the selected time interval (data for this metric lags by 5 minutes). Possible values for this metric:
Notes for the
Statistic: Mean Interval: 1 minute |
5 minutes |
DBBlockChanges |
DB Block Changes | count | The number of changes that were part of an update or delete operation that were made to all blocks in the SGA. Such changes generate redo log entries and become permanent changes to the database if the transaction is committed. This approximates total database work. This statistic indicates the rate at which buffers are being dirtied, during the selected time interval. Statistic: Sum 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 |
ECPUs Allocated | count | The total ECPU billed for this database (which includes ECPUs billed for Local standbys and Database Tools). Statistic: Count Interval: 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 |
1 minute |
FailedConnections |
Failed Connections | count | 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: Statistic: Sum Interval: 1 minute |
1 minute |
FailedLogons |
Failed Logons | count | The number of logons that failed because of an invalid user name and/or password, during the selected interval. The counter is reset to 0 by a successful login. Statistic: Mean Interval: 1 minute |
1 minute |
HardParseCount |
Parse Count (Hard) | count | The number of parse calls (real parses) during the selected time interval. A hard parse is an expensive operation in terms of memory use, because it requires Oracle to allocate a workheap and other memory structures and then build a parse tree. Statistic: Sum Interval: 1 minute |
1 minute |
IOPS |
IOPS | Integer | The average number of I/O operations per second. Statistic: Mean Interval: 5 minutes |
|
IOThroughput |
IO Throughput | Integer | The average throughput in MB per second. Statistic: Mean Interval: 5 minutes |
|
LogicalBlocksRead |
Logical Reads | Integer | 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 |
|
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. | 1 minute |
ParsesByType |
Parses By Type | Integer | The number of hard or soft parses per second. Statistic: Mean Interval: 5 minutes |
|
ParseCount |
Parse Count (Total) | count | The number of hard and soft parses during the selected interval. Statistic: Sum Interval: 1 minute |
1 minute |
ParseFailureCount |
Parse Count (Failures) | count | The number of parse failures during the selected time interval. Statistic: Sum Interval: 1 minute |
1 minute |
PeerLag |
Peer Lag | Seconds | The total time in seconds by which the Disaster Recovery peer lags behind its Primary database. For a local Disaster Recovery peer, the metric is displayed under the Primary database. For a cross region Disaster Recovery peer, this metric is displayed under the Disaster Recovery peer. Statistic: Max Interval: 1 minute |
1 minute |
PgaUtilization |
PGA Utilization | percent | The percentage of maximum available PGA memory that is utilized, aggregated across all consumer groups. Statistic: Mean 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 |
1 minute |
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 |
1 minute |
PhysicalWrites |
Physical Writes | count | The number of data blocks written to disk, during the selected time interval. Statistic: Sum Interval: 1 minute |
1 minute |
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 |
1 minute |
QueryLatency |
Query Latency | Milliseconds | The time taken to display the results of a simple query on the user's screen. Statistic: Max Interval: 5 minutes |
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 |
NA |
RedoGenerated |
Redo Generated | count | Amount of redo generated in bytes, during the selected time interval. Statistic: Sum Interval: 1 minute |
1 minute |
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 |
SessionUtilization |
Session Utilization | Percent | The maximum session utilization expressed as a percentage, aggregated across all consumer groups. Statistic: Mean Interval: 1 minute |
1 minute |
SgaUtilization |
SGA Utilization | Percent | The percentage of maximum available SGA memory utilized, aggregated across all consumer groups. Statistic: Mean Interval: 1 minute |
5 minutes |
SQLNetBytesFromClient |
Bytes Received via SQL*Net 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 |
1 minute |
SQLNetBytesFromDBLink |
Bytes Received via SQL*Net 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 |
1 minute |
SQLNetBytesToClient |
Bytes Sent via SQL*Net 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 |
1 minute |
SQLNetBytesToDBLink |
Bytes Sent via SQL*Net to DBLink | count | The number of bytes sent over a database link, during the selected time interval. Statistic: Sum Interval: 1 minute |
1 minute |
StorageAllocated |
Storage Space Allocated | GB | Amount of space allocated to the database for all tablespaces, during the interval. Statistic: Max Interval: 1 hour |
1 hour |
StorageMax |
Maximum Storage Space | GB | Maximum amount of storage reserved for the database during the interval. Statistic: Max Interval: 1 hour |
1 hour |
StorageUsed |
Storage Space Used | GB | Maximum amount of space used during the interval. Statistic: Max Interval: 1 hour |
1 hour |
StorageUtilization |
Storage Utilization | percent | The percentage of the reserved maximum storage currently allocated for all database tablespaces. Represents the total reserved space for all tablespaces. Statistic: Mean Interval: 1 hour |
1 hour |
TransactionsByStatus |
Transactions By Status | Integer | The number of committed or rolled back transactions per second. Statistic: Mean Interval: 5 minutes |
|
TransactionCount |
Transaction Count | count | The combined number of user commits and user rollbacks during the selected interval. Statistic: Sum Interval: 1 minute |
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 |
UserCommits |
User Commits | count | The number of user commits during the selected time interval. When a user commits a transaction, the generated redo that reflects the changes made to database blocks must be written to disk. Commits often represent the closest thing to a user transaction rate. Statistic: Sum Interval: 1 minute |
1 minute |
UserRollbacks |
User Rollbacks | count | Number of times users manually issue the 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 |