OCI Autonomous Database

Overview

Oracle Autonomous Database automatically translates natural language into database queries and allows you to use SQL, JSON documents, Oracle Graph, Oracle Spatial, text, and vectors in a single database.

This integration allows you to monitor and alert on the current connections, statement count, CPU utilization, and backup time of your Autonomous Database by collecting metrics and tags from the oci_autonomous_database namespace.

Installing the Datadog Agent on your Oracle Databases provdes real-time insights into additional metrics such as active sessions, disk usage, table space usage, and more.

Enable Datadog’s Database Monitoring (DBM) for enhanced insights into query performance and database health. In addition to the standard integration features, Datadog DBM provides query-level metrics, live and historical query snapshots, wait event analysis, database load, query explain plans, and blocking query insights.

Setup

Installation

After you set up the Oracle Cloud Infrastructure integration, ensure that the oci_autonomous_database namespace is included in your Connector Hub.

Data Collected

Metrics

oci.autonomous_database.apply_lag
(gauge)
This metric displays (in seconds) how far the standby database is behind the primary database as of the time sampled.
Shown as second
oci.autonomous_database.block_changes
(gauge)
The average number of blocks changed per second.
Shown as update
oci.autonomous_database.cpu_time
(gauge)
Average rate of accumulation of CPU time by foreground sessions in the database over the time interval. Statistic: Mean. Interval: 1 minute.
Shown as second
oci.autonomous_database.cpu_utilization
(gauge)
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.
Shown as percent
oci.autonomous_database.current_logons
(count)
The number of successful logons during the selected interval. Statistic: Count. Interval: 1 minute.
Shown as operation
oci.autonomous_database.dbtime
(gauge)
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.
Shown as second
oci.autonomous_database.ecpus_allocated
(gauge)
The actual number of ECPUs allocated by the service during the selected interval of time.
Shown as cpu
oci.autonomous_database.execute_count
(count)
The number of user and recursive calls that executed SQL statements during the selected interval. Statistic: Sum. Interval: 1 minute.
Shown as execution
oci.autonomous_database.iops
(gauge)
The average number of I/O operations per second.
Shown as operation
oci.autonomous_database.iothroughput
(gauge)
The average throughput in MB per second.
Shown as megabyte
oci.autonomous_database.logical_blocks_read
(gauge)
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.
Shown as read
oci.autonomous_database.ocpus_allocated
(gauge)
The actual number of OCPUs allocated by the service during the selected interval of time.
Shown as cpu
oci.autonomous_database.parse_count
(count)
The number of hard and soft parses during the selected interval. Statistic: Sum. Interval: 1 minute.
Shown as event
oci.autonomous_database.parses_by_type
(count)
The number of hard or soft parses per second.
Shown as event
oci.autonomous_database.queued_statements
(count)
The number of queued SQL statements, aggregated across all consumer groups, during the selected interval. Statistic: Sum. Interval: 1 minute.
Shown as execution
oci.autonomous_database.redo_size
(gauge)
The average amount of redo generated in MB per second.
Shown as megabyte
oci.autonomous_database.running_statements
(count)
The number of running SQL statements, aggregated across all consumer groups, during the selected interval. Statistic: Mean. Interval: 1 minute.
Shown as execution
oci.autonomous_database.sessions
(count)
The number of sessions in the database. Statistic: Sum. Interval: 1 minute.
Shown as session
oci.autonomous_database.storage_allocated
(gauge)
Maximum amount of space allocated to the database during the interval. Statistic: Max. Interval: 1 hour.
Shown as gigabyte
oci.autonomous_database.storage_allocated_by_tablespace
(gauge)
Maximum amount of space allocated for each tablespace during the interval.
Shown as gigabyte
oci.autonomous_database.storage_used
(gauge)
Maximum amount of space used during the interval. Statistic: Max. Interval: 1 hour.
Shown as gigabyte
oci.autonomous_database.storage_used_by_tablespace
(gauge)
Maximum amount of space used by each tablespace during the interval.
Shown as gigabyte
oci.autonomous_database.storage_utilization
(gauge)
The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. Statistic: Mean. Interval: 1 hour.
Shown as percent
oci.autonomous_database.storage_utilization_by_tablespace
(gauge)
The percentage of space utilized by each tablespace.
Shown as percent
oci.autonomous_database.transaction_count
(count)
The combined number of user commits and user rollbacks during the selected interval. Statistic: Sum. Interval: 1 minute.
Shown as event
oci.autonomous_database.transactions_by_status
(count)
The number of committed or rolled back transactions per second.
Shown as transaction
oci.autonomous_database.transport_lag
(gauge)
The approximate number of seconds of redo not yet available on the standby database as of the time sampled.
Shown as second
oci.autonomous_database.user_calls
(count)
The combined number of logons, parses, and execute calls during the selected interval. Statistic: Sum. Interval: 1 minute.
Shown as event
oci.autonomous_database.wait_time
(gauge)
Average rate of accumulation of non-idle wait time by foreground sessions in the database over the time interval. Statistic: Mean. Interval: 1 minute.
Shown as second

Events

The OCI Autonomous Database integration does not include any events.

Service Checks

The OCI Autonomous Database integration does not include any service checks.

Troubleshooting

Need help? Contact Datadog support.

PREVIEWING: may/unit-testing