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, shared or dedicated. When using the Console to view default metric charts for multiple Autonomous Databases, you must specify this dimension.

    This topic covers Oracle Autonomous Database Serverless metrics. See Monitor Databases with Autonomous Database Metrics for information on Oracle Autonomous Database on Dedicated Exadata Infrastructure metrics.

  • 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
ConnectionLatency

Connection Latency

Milliseconds

The time taken to connect to an Oracle Autonomous Database Serverless instance in each region from a Compute service virtual machine in the same region.

Statistic: Max

Interval: 5 minutes

5 minutes

BlockingSessions

Blocking Sessions

count

The number of current blocking sessions.

Statistic: Max

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 in the given minute, with possible values:

  • 1 = DB Available
  • 0 = DB Unavailable

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

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

FailedConnections*

Failed Connections

count

The number of failed database connections.

Statistic: Sum

Interval: 1 minute

1 minute

FailedLogons

Failed Logons

count

The number of log ons 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

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

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

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

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

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 ROLLBACK statement or an error occurs during a user's transactions, during the selected time 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