--- title: OCI Autonomous AI Database description: >- Oracle Autonomous AI Database automates database management with self-tuning, patching, and scaling. breadcrumbs: Docs > Integrations > OCI Autonomous AI Database --- # OCI Autonomous AI Database Integration version1.0.0 {% callout %} # Important note for users on the following Datadog sites: us2.ddog-gov.com {% alert level="info" %} To find out if this integration is available in your organization, see your [Datadog Integrations](https://app.datadoghq.com/integrations) page or ask your organization administrator. To initiate an exception request to enable this integration for your organization, email [support@ddog-gov.com](mailto:support@ddog-gov.com). {% /alert %} {% /callout %} ## Overview{% #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](https://docs.oracle.com/en-us/iaas/autonomous-database/doc/monitor-databases-autonomous-database-metrics.html) namespace. Installing the [Datadog Agent](https://docs.datadoghq.com/integrations/oracle.md) 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)](https://docs.datadoghq.com/database_monitoring.md) 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{% #setup %} ### Installation{% #installation %} After you set up the [Oracle Cloud Infrastructure](https://docs.datadoghq.com/integrations/oracle_cloud_infrastructure.md) integration, ensure that the `oci_autonomous_database` namespace is included in your [Connector Hub](https://cloud.oracle.com/connector-hub/service-connectors). ## Data Collected{% #data-collected %} ### Metrics{% #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.Also available for OCI Autonomous AI Database Serverless as `dbblock_changes`.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*Shown as percent* | | **oci.autonomous\_database.current\_logons**(count) | The number of successful logons during the selected interval.Statistic: Count. Interval: 1 minute.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*Shown as execution* | | **oci.autonomous\_database.session\_utilization**(gauge) | The maximum session utilization expressed as a percentage, aggregated across all consumer groups.Statistic: Mean Interval: 1 minute.Also available for OCI Autonomous AI Database Serverless.*Shown as percent* | | **oci.autonomous\_database.sessions**(count) | The number of sessions in the database.Statistic: Sum. Interval: 1 minute.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*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.Also available for OCI Autonomous AI Database Serverless.*Shown as second* | | **oci.autonomous\_database.average\_active\_sessions**(count) | The average number of sessions that are actively executing or waiting for resources. Statistic: Mean Interval: 1 minute.*Shown as session* | | **oci.autonomous\_database.blocking\_sessions**(count) | The number of sessions that have been blocking other sessions for more than 60 seconds. Statistic: Max Interval: 1 minute.*Shown as session* | | **oci.autonomous\_database.connection\_latency**(gauge) | 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.*Shown as millisecond* | | **oci.autonomous\_database.connections\_dropped\_by\_client**(count) | The number of connections dropped by the client. Statistic: Sum Interval: 1 minute.*Shown as connection* | | **oci.autonomous\_database.connections\_dropped\_by\_server**(count) | The number of connections dropped by the server. Statistic: Sum Interval: 1 minute.*Shown as connection* | | **oci.autonomous\_database.database\_availability**(gauge) | The database is available for connections during the selected time interval (data for this metric lags by 5 minutes). Possible values for this metric: 1 = Database is Available, 0 = Database is Unavailable. You can set an alarm that is triggered if the database is not available (value 0). | | **oci.autonomous\_database.dbblock\_changes**(gauge) | 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.*Shown as update* | | **oci.autonomous\_database.failed\_connections**(count) | The number of failed database connections. Statistic: Sum Interval: 1 minute.*Shown as connection* | | **oci.autonomous\_database.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.*Shown as operation* | | **oci.autonomous\_database.hard\_parse\_count**(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.*Shown as event* | | **oci.autonomous\_database.logical\_reads**(gauge) | 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.*Shown as read* | | **oci.autonomous\_database.parse\_failure\_count**(count) | The number of parse failures during the selected time interval. Statistic: Sum Interval: 1 minute.*Shown as event* | | **oci.autonomous\_database.peer\_lag**(gauge) | 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.*Shown as second* | | **oci.autonomous\_database.physical\_read\_total\_bytes**(gauge) | 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.*Shown as byte* | | **oci.autonomous\_database.physical\_reads**(gauge) | The number of data blocks read from disk, during the selected time interval. Statistic: Sum Interval: 1 minute.*Shown as read* | | **oci.autonomous\_database.physical\_write\_total\_bytes**(gauge) | 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.*Shown as byte* | | **oci.autonomous\_database.physical\_writes**(gauge) | The number of data blocks written to disk, during the selected time interval. Statistic: Sum Interval: 1 minute.*Shown as write* | | **oci.autonomous\_database.query\_latency**(gauge) | The time taken to display the results of a simple query on the user's screen. Statistic: Max Interval: 5 minutes.*Shown as millisecond* | | **oci.autonomous\_database.redo\_generated**(gauge) | Amount of redo generated in bytes, during the selected time interval. Statistic: Sum Interval: 1 minute.*Shown as byte* | | **oci.autonomous\_database.sqlnet\_bytes\_from\_client**(gauge) | The number of bytes received from the client over Oracle Net Services, during the selected time interval. Statistic: Sum Interval: 1 minute.*Shown as byte* | | **oci.autonomous\_database.sqlnet\_bytes\_from\_dblink**(gauge) | The number of bytes received from a database link over Oracle Net Services, during the selected time interval. Statistic: Sum Interval: 1 minute.*Shown as byte* | | **oci.autonomous\_database.sqlnet\_bytes\_to\_client**(gauge) | The number of bytes sent to the client from the foreground processes, during the selected time interval. Statistic: Sum Interval: 1 minute.*Shown as byte* | | **oci.autonomous\_database.sqlnet\_bytes\_to\_dblink**(gauge) | The number of bytes sent over a database link, during the selected time interval. Statistic: Sum Interval: 1 minute.*Shown as byte* | | **oci.autonomous\_database.storage\_max**(gauge) | Maximum amount of storage reserved for the database during the interval. Statistic: Max Interval: 1 hour.*Shown as gigabyte* | | **oci.autonomous\_database.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.*Shown as commit* | | **oci.autonomous\_database.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.*Shown as event* | #### Oracle Autonomous AI Database Serverless metrics{% #oracle-autonomous-ai-database-serverless-metrics %} | | | | | oci.autonomous_database.dbblock_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.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.logical_reads(gauge) | 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.*Shown as read* | | 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.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.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.session_utilization(gauge) | The maximum session utilization expressed as a percentage, aggregated across all consumer groups.Statistic: Mean Interval: 1 minute.*Shown as percent* | | 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_used(gauge) | Maximum amount of space used during the interval.Statistic: Max. Interval: 1 hour.*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.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.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{% #events %} The OCI Autonomous Database integration does not include any events. ### Service Checks{% #service-checks %} The OCI Autonomous Database integration does not include any service checks. ## Troubleshooting{% #troubleshooting %} Need help? Contact [Datadog support](https://docs.datadoghq.com/help/).