--- title: Oracle Database@Azure description: Track key metrics for Oracle databases running on Oracle Database@Azure. breadcrumbs: Docs > Integrations > Oracle Database@Azure --- > For the complete documentation index, see [llms.txt](https://docs.datadoghq.com/llms.txt). # Oracle Database@Azure 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 Database@Azure](https://learn.microsoft.com/en-us/azure/oracle/oracle-db/database-overview) runs Oracle databases on Oracle Cloud Infrastructure (OCI) hardware colocated in Microsoft Azure datacenters, giving you native access to Oracle Autonomous Database and Exadata Database Service directly from the Azure portal. Because the service runs on Azure infrastructure, it uses Azure networking and identity while Oracle continues to manage the underlying database software and patching. Use the Datadog Azure integration to collect metrics for the Autonomous Databases, Cloud VM Clusters, and DB Systems deployed through Oracle Database@Azure, including CPU and memory utilization, storage usage, session counts, and query performance indicators. ## Setup{% #setup %} ### Installation{% #installation %} If you haven't already, set up the [Microsoft Azure integration](https://docs.datadoghq.com/integrations/azure.md) first. There are no other installation steps that need to be performed. ## Data Collected{% #data-collected %} ### Metrics{% #metrics %} | | | | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_database_availability**(gauge) | Database is available for connections in the given minute, with possible values: 1 equals DB available, 0 equals DB unavailable. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_failed_connections**(gauge) | Number of failed database connections. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_failed_logons**(gauge) | Number of log ons that failed because of an invalid user name and/or password, during the selected interval. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_parse_failure_count**(gauge) | Number of parse failures during the selected time interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_apex_page_load_time**(gauge) | Average APEX page execution time over the time interval. | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_connection_latency**(gauge) | 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* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_peer_lag**(gauge) | 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* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_query_latency**(gauge) | Time taken to display the results of a simple query on the user's screen. (Statistic: max, interval: 5 minutes).*Shown as millisecond* | | **azure.oracle.database_autonomousdatabases.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). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_apex_apps**(gauge) | Number of APEX applications that had activity over the time interval. | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_apex_page_events**(gauge) | Number of APEX page events over the time interval. | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_apex_workspace_count**(gauge) | Total number of user-created APEX workspaces at given time. | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_blocking_sessions**(gauge) | Number of current blocking sessions. (Statistic: max, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.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). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_cpu_utilization**(gauge) | 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* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_db_block_changes**(gauge) | Number of changes that were part of an update or delete operation that were made to all blocks in the SGA. | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_db_time**(gauge) | Amount of time database user sessions spend executing database code (CPU time + waittime). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_hard_parse_count**(gauge) | 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). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_logical_reads**(gauge) | 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. | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_parse_count**(gauge) | Number of hard and soft parses during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_physical_reads**(gauge) | Number of data blocks read from disk, during the selected time interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_physical_read_total_bytes**(gauge) | 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). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_physical_writes**(gauge) | Number of data blocks written to disk, during the selected time interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_physical_write_total_bytes**(gauge) | 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). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_redo_generated**(gauge) | Amount of redo generated in bytes, during the selected time interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_sql_net_bytes_from_client**(gauge) | Number of bytes received from the client over oracle net services, during the selected time interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_sql_net_bytes_from_db_link**(gauge) | Number of bytes received from a database link over oracle net services, during the selected time interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_sql_net_bytes_to_client**(gauge) | Number of bytes sent to the client from the foreground processes, during the selected time interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_sql_net_bytes_to_db_link**(gauge) | Number of bytes sent over a database link, during the selected time interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_storage_allocated**(gauge) | Amount of space allocated to the database for all tablespaces, during the interval. (Statistic: max, interval: 1 hour).*Shown as byte* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_storage_max**(gauge) | Maximum amount of storage reserved for the database during the interval. (Statistic: max, interval: 1 hour).*Shown as byte* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_storage_used**(gauge) | Maximum amount of space used during the interval. (Statistic: max, interval: 1 hour).*Shown as byte* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_storage_utilization**(gauge) | 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).*Shown as percent* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_current_logons**(gauge) | Number of successful logons during the selected interval. (Statistic: count, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_execute_count**(gauge) | Number of user and recursive calls that executed SQL statements during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_queued_statements**(gauge) | Number of queued SQL statements, aggregated across all consumer groups, during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_running_statements**(gauge) | Number of running SQL statements, aggregated across all consumer groups, during the selected interval. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_sessions**(gauge) | Number of sessions in the database. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_transaction_count**(gauge) | Combined number of user commits and user rollbacks during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_user_calls**(gauge) | Combined number of logons, parses, and execute calls during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_user_commits**(gauge) | 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). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database_user_rollbacks**(gauge) | 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). | | **azure.oracle.database_cloudvmclusters.oci_database_cluster_node_status**(gauge) | Indicates whether the host is reachable. | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_monitoring_status**(gauge) | Monitoring status of the resource. If a metric collection fails, error information is captured in this metric. (Statistic: mean, interval: 5 minutes). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_problematic_scheduled_dbms_jobs**(gauge) | Problematic scheduled database jobs count. Not applicable for container databases. (Statistic: max, interval: 15 minutes). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_avg_gccr_block_receive_time**(gauge) | Average global cache CR (consistent-read) block receive time. For RAC / cluster databases only. (Statistic: mean, interval: 5 minutes).*Shown as millisecond* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_wait_time**(gauge) | Average rate of accumulation of non-idle wait time by foreground sessions in the database instance over the time interval. The wait time component of average active sessions. (Statistic: mean, interval: 5 minutes). | | **azure.oracle.database_cloudvmclusters.oci_database_cluster_asm_diskgroup_utilization**(gauge) | Percentage of usable space used in a disk group. Usable space is the space available for growth. DATA disk group stores our oracle database files. RECO disk group contains database files for recovery such as archives and flashback logs.*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oci_database_cluster_cpu_utilization**(gauge) | Percent CPU utilization.*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oci_database_cluster_filesystem_utilization**(gauge) | Percent utilization of provisioned filesystem.*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oci_database_cluster_load_average**(gauge) | System load average over 5 minutes. | | **azure.oracle.database_cloudvmclusters.oci_database_cluster_memory_utilization**(gauge) | Percentage of memory available for starting new applications, without swapping. The available memory can be obtained via the following command: cat /proc/meminfo.*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oci_database_cluster_ocpus_allocated**(gauge) | Number of ocpus allocated. | | **azure.oracle.database_cloudvmclusters.oci_database_cluster_swap_utilization**(gauge) | Percent utilization of total swap space.*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oci_database_block_changes**(gauge) | Average number of blocks changed per second. | | **azure.oracle.database_cloudvmclusters.oci_database_cpu_utilization**(gauge) | CPU utilization 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, which is two times the number of ocpus.*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oci_database_parse_count**(gauge) | Number of hard and soft parses during the selected interval. | | **azure.oracle.database_cloudvmclusters.oci_database_storage_allocated**(gauge) | Total amount of storage space allocated to the database at the collection time.*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oci_database_storage_allocated_by_tablespace**(gauge) | Total amount of storage space allocated to the tablespace at the collection time. In case of container database, this metric provides root container tablespaces.*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oci_database_storage_used**(gauge) | Total amount of storage space used by the database at the collection time.*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oci_database_storage_used_by_tablespace**(gauge) | Total amount of storage space used by tablespace at the collection time. In case of container database, this metric provides root container tablespaces.*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oci_database_storage_utilization**(gauge) | Percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oci_database_storage_utilization_by_tablespace**(gauge) | This indicates the percentage of storage space utilized by the tablespace at the collection time. In case of container database, this metric provides root container tablespaces..*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_allocated_storage_utilization_by_tablespace**(gauge) | Percentage of space used by tablespace, out of all allocated. For container databases, this metric provides data for root container tablespaces. (Statistic: mean, interval: 30 minutes).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_block_changes**(gauge) | Average number of blocks changed per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_cpu_time**(gauge) | Average rate of accumulation of CPU time by foreground sessions in the database instance over the time interval. The CPU time component of average active sessions. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_cpu_utilization**(gauge) | CPU utilization 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, which is two times the number of ocpus. (Statistic: mean, interval: 1 minute).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_dbmgmt_job_executions_count**(gauge) | Number of SQL job executions on a single managed database or a database group, and their status. Status dimensions can be the following values: 'succeeded,' 'failed,' 'inprogress.' (statistic: sum, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_db_time**(gauge) | Average rate of accumulation of database time (CPU + wait) by foreground sessions in the database instance over the time interval. Also known as average active sessions. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_fra_space_limit**(gauge) | Flash recovery area space limit. Not applicable for pluggable databases. (Statistic: max, interval: 15 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_fra_utilization**(gauge) | Flash recovery area utilization. Not applicable for pluggable databases. (Statistic: mean, interval: 15 minutes).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_gccr_blocks_received**(gauge) | Global cache CR (consistent-read) blocks received per second. For RAC / cluster databases only. (Statistic: mean, interval: 5 minutes). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_gc_current_blocks_received**(gauge) | Represents global cache current blocks received per second. Statistic reports the mean value. For real application cluster (RAC) databases only. (Statistic: mean, interval: 5 minutes). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_interconnect_traffic**(gauge) | Average internode data transfer rate. For RAC / cluster databases only. (Statistic: mean, interval: 5 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_iops**(gauge) | Average number of input-output operations per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_io_throughput**(gauge) | Average throughput in MB per second. (Statistic: mean, interval: 1 minute).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_logical_blocks_read**(gauge) | Average number of blocks read from sga/memory (buffer cache) per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_max_tablespace_size**(gauge) | Maximum possible tablespace size. For container databases, this metric provides data for root container tablespaces. (Statistic: max, interval: 30 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_memory_usage**(gauge) | Memory pool total size in MB. (Statistic: mean, interval: 15 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_non_reclaimable_fra**(gauge) | Non-reclaimable fast recovery area. Not applicable for pluggable databases. (Statistic: mean, interval: 15 minutes).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_ocpus_allocated**(gauge) | Actual number of ocpus allocated by the service during the selected interval of time. (Statistic: count, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_parse_count**(gauge) | Number of hard and soft parses during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_parses_by_type**(gauge) | Number of hard or soft parses per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_processes**(gauge) | Database processes count. Not applicable for pluggable databases. (Statistic: max, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_process_limit_utilization**(gauge) | Process limit utilization. Not applicable for pluggable databases. (Statistic: mean, interval: 1 minute).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_reclaimable_fra**(gauge) | Reclaimable fast recovery area. Not applicable for pluggable databases. (Statistic: mean, interval: 15 minutes).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_reclaimable_fra_space**(gauge) | Flash recovery area reclaimable space. Not applicable for pluggable databases. (Statistic: mean, interval: 15 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_redo_size**(gauge) | Average amount of redo generated, in MB per second. (Statistic: mean, interval: 1 minute).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_session_limit_utilization**(gauge) | Session limit utilization. Not applicable for pluggable databases. (Statistic: mean, interval: 1 minute).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_sessions**(gauge) | Number of sessions in the database. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_storage_allocated**(gauge) | Maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces. (Statistic: max, interval: 30 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_storage_allocated_by_tablespace**(gauge) | Maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces. (Statistic: max, interval: 30 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_storage_used**(gauge) | Maximum amount of space used during the interval. (Statistic: max, interval: 30 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_storage_used_by_tablespace**(gauge) | Maximum amount of space used by tablespace during the interval. For container databases, this metric provides data for root container tablespaces. (Statistic: max, interval: 30 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_storage_utilization**(gauge) | Percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. (Statistic: mean, interval: 30 minutes).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_storage_utilization_by_tablespace**(gauge) | Percentage of the space utilized, by tablespace. For container databases, this metric provides data for root container tablespaces. (Statistic: mean, interval: 30 minutes).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_unusable_indexes**(gauge) | Unusable indexes count in database schema. Not applicable for container databases. (Statistic: max, interval: 24 hours). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_usable_fra**(gauge) | Useable fast recovery area. Not applicable for pluggable databases.(statistic: mean, interval: 15 minutes).*Shown as percent* | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_used_fra_space**(gauge) | Flash recovery area space usage. Not applicable for pluggable databases. (Statistic: max, interval: 15 minutes).*Shown as byte* | | **azure.oracle.database_cloudvmclusters.oci_database_current_logons**(gauge) | Number of successful logons during the selected interval. | | **azure.oracle.database_cloudvmclusters.oci_database_execute_count**(gauge) | Number of user and recursive calls that executed SQL statements during the selected interval. | | **azure.oracle.database_cloudvmclusters.oci_database_transaction_count**(gauge) | Combined number of user commits and user rollbacks during the selected interval. | | **azure.oracle.database_cloudvmclusters.oci_database_user_calls**(gauge) | Combined number of logons, parses, and execute calls during the selected interval. | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_blocking_sessions**(gauge) | Current blocking sessions. Not applicable for container databases. (Statistic: max, interval: 15 minutes). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_current_logons**(gauge) | Number of successful logons during the selected interval. (Statistics: sum, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_execute_count**(gauge) | Number of user and recursive calls that executed SQL statements during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_invalid_objects**(gauge) | Invalid database objects count. Not applicable for container databases. (Statistic: max, interval: 24 hours). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_transaction_count**(gauge) | Combined number of user commits and user rollbacks during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_transactions_by_status**(gauge) | Number of committed or rolled back transactions per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_cloudvmclusters.oracle_oci_database_user_calls**(gauge) | Combined number of logons, parses, and execute calls during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_dbsystems.oci_database_cluster_node_status**(gauge) | Indicates whether the host is reachable in RAC environments. | | **azure.oracle.database_dbsystems.oracle_oci_database_monitoring_status**(gauge) | Monitoring status of the resource. If metric collection fails, error information is captured in this metric. (Statistic: mean, interval: 5 minutes). | | **azure.oracle.database_dbsystems.oracle_oci_database_wait_time**(gauge) | Average rate of accumulation of non-idle wait time by foreground sessions in the database instance over the time interval. The wait time component of average active sessions. (Statistic: mean, interval: 5 minutes). | | **azure.oracle.database_dbsystems.oci_database_cluster_cpu_utilization**(gauge) | Percent CPU utilization.*Shown as percent* | | **azure.oracle.database_dbsystems.oci_database_cluster_filesystem_utilization**(gauge) | Percent utilization of provisioned filesystem.*Shown as percent* | | **azure.oracle.database_dbsystems.oci_database_cluster_load_average**(gauge) | System load average over 5 minutes. | | **azure.oracle.database_dbsystems.oci_database_cluster_memory_utilization**(gauge) | Percentage of memory available for starting new applications, without swapping. The available memory can be obtained via the following command: cat/proc/meminfo.*Shown as percent* | | **azure.oracle.database_dbsystems.oci_database_cluster_ocpus_allocated**(gauge) | Number of ocpus allocated. | | **azure.oracle.database_dbsystems.oci_database_cluster_swap_utilization**(gauge) | Percent utilization of total swap space.*Shown as percent* | | **azure.oracle.database_dbsystems.oci_database_block_changes**(gauge) | Average number of blocks changed per second. | | **azure.oracle.database_dbsystems.oci_database_cpu_utilization**(gauge) | CPU utilization 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, which is two times the number of ocpus.*Shown as percent* | | **azure.oracle.database_dbsystems.oci_database_parse_count**(gauge) | Number of hard and soft parses during the selected interval. | | **azure.oracle.database_dbsystems.oci_database_storage_allocated**(gauge) | Total amount of storage space allocated to the database at the collection time.*Shown as byte* | | **azure.oracle.database_dbsystems.oci_database_storage_allocated_by_tablespace**(gauge) | Total amount of storage space allocated to the tablespace at the collection time. In case of container database, this metric provides root container tablespaces.*Shown as byte* | | **azure.oracle.database_dbsystems.oci_database_storage_used**(gauge) | Total amount of storage space used by the database at the collection time.*Shown as byte* | | **azure.oracle.database_dbsystems.oci_database_storage_used_by_tablespace**(gauge) | Total amount of storage space used by tablespace at the collection time. In case of container database, this metric provides root container tablespaces.*Shown as byte* | | **azure.oracle.database_dbsystems.oci_database_storage_utilization**(gauge) | Percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.*Shown as percent* | | **azure.oracle.database_dbsystems.oci_database_storage_utilization_by_tablespace**(gauge) | This indicates the percentage of storage space utilized by the tablespace at the collection time. In case of container database, this metric provides root container tablespaces.*Shown as percent* | | **azure.oracle.database_dbsystems.oracle_oci_database_block_changes**(gauge) | Average number of blocks changed per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_cpu_count**(gauge) | Number of cpus during the selected interval. | | **azure.oracle.database_dbsystems.oracle_oci_database_cpu_time**(gauge) | Average rate of accumulation of CPU time by foreground sessions in the database instance over the time interval. The CPU time component of average active sessions. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_cpu_utilization**(gauge) | CPU utilization 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, which is two times the number of ocpus. (Statistic: mean, interval: 1 minute).*Shown as percent* | | **azure.oracle.database_dbsystems.oracle_oci_database_db_time**(gauge) | Average rate of accumulation of database time (CPU + wait) by foreground sessions in the database instance over the time interval. Also known as average active sessions. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_fra_space_limit**(gauge) | Flash recovery area space limit. (Statistic: max, interval: 15 minutes) not applicable for pdbs.*Shown as byte* | | **azure.oracle.database_dbsystems.oracle_oci_database_fra_utilization**(gauge) | Flash recovery area utilization. (Statistic: mean, interval: 15 minutes) not applicable for pdbs.*Shown as percent* | | **azure.oracle.database_dbsystems.oracle_oci_database_iops**(gauge) | Average number of IO operations per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_io_throughput**(gauge) | Average throughput in MB per second. (Statistic: mean, interval: 1 minute).*Shown as byte* | | **azure.oracle.database_dbsystems.oracle_oci_database_logical_blocks_read**(gauge) | Average number of blocks read from sga/memory (buffer cache) per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_memory_usage**(gauge) | Total size of the memory pool. (Statistic: mean, interval: 15 minutes).*Shown as byte* | | **azure.oracle.database_dbsystems.oracle_oci_database_non_reclaimable_fra**(gauge) | Non-reclaimable fast recovery area. (Statistic: mean, interval: 15 minutes) not applicable for pdbs.*Shown as percent* | | **azure.oracle.database_dbsystems.oracle_oci_database_parse_count**(gauge) | Number of hard and soft parses during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_parses_by_type**(gauge) | Number of hard or soft parses per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_processes**(gauge) | Number of database processes. (Statistic: max, interval: 1 minute) not applicable for pdbs. | | **azure.oracle.database_dbsystems.oracle_oci_database_process_limit_utilization**(gauge) | Process limit utilization. (Statistic: mean, interval: 1 minute) not applicable for pdbs.*Shown as percent* | | **azure.oracle.database_dbsystems.oracle_oci_database_reclaimable_fra**(gauge) | Reclaimable fast recovery area. (Statistic: mean, interval: 15 minutes) not applicable for pdbs.*Shown as percent* | | **azure.oracle.database_dbsystems.oracle_oci_database_reclaimable_fra_space**(gauge) | Flash recovery area reclaimable space. (Statistic: mean, interval: 15 minutes) not applicable for pdbs.*Shown as byte* | | **azure.oracle.database_dbsystems.oracle_oci_database_redo_generation_rate**(gauge) | Redo generation rate on the primary database. (Statistic: mean, interval: 5 minutes, resource group: oracle_dataguard) not applicable for pdbs.*Shown as byte* | | **azure.oracle.database_dbsystems.oracle_oci_database_redo_size**(gauge) | Average amount of redo generated. (Statistic: mean, interval: 1 minute).*Shown as byte* | | **azure.oracle.database_dbsystems.oracle_oci_database_session_limit_utilization**(gauge) | Session limit utilization. (Statistic: mean, interval: 1 minute) not applicable for pdbs.*Shown as percent* | | **azure.oracle.database_dbsystems.oracle_oci_database_sessions**(gauge) | Number of sessions in the database. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_usable_fra**(gauge) | Usable fast recovery area. (Statistic: mean, interval: 15 minutes) not applicable for pdbs.*Shown as percent* | | **azure.oracle.database_dbsystems.oracle_oci_database_used_fra_space**(gauge) | Flash recovery area space usage. (Statistic: max, interval: 15 minutes) not applicable for pdbs.*Shown as byte* | | **azure.oracle.database_dbsystems.oci_database_current_logons**(gauge) | Number of successful logons during the selected interval. | | **azure.oracle.database_dbsystems.oci_database_execute_count**(gauge) | Number of user and recursive calls that executed SQL statements during the selected interval. | | **azure.oracle.database_dbsystems.oci_database_transaction_count**(gauge) | Combined number of user commits and user rollbacks during the selected interval. | | **azure.oracle.database_dbsystems.oci_database_user_calls**(gauge) | Combined number of logons, parses, and execute calls during the selected interval. | | **azure.oracle.database_dbsystems.oracle_oci_database_current_logons**(gauge) | Number of successful logons during the selected interval. (Statistics: sum, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_execute_count**(gauge) | Number of user and recursive calls that executed SQL statements during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_transaction_count**(gauge) | Combined number of user commits and user rollbacks during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_transactions_by_status**(gauge) | Number of committed or rolled back transactions per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_dbsystems.oracle_oci_database_user_calls**(gauge) | Combined number of logons, parses, and execute calls during the selected interval. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.connections_dropped_by_client**(gauge) | Number of connections dropped by the client. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.connections_dropped_by_server**(gauge) | Number of connections dropped by the server. (Statistic: sum, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.average_active_sessions**(gauge) | Average number of sessions that are actively executing or waiting for resources. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.ecp_us_allocated**(gauge) | Number of ecpus allocated to the database. (Statistic: max, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.iops**(gauge) | Average number of input-output operations per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.io_throughput**(gauge) | Average throughput in MB per second. (Statistic: mean, interval: 1 minute).*Shown as byte* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.logical_blocks_read**(gauge) | Average number of blocks read from memory per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.parses_by_type**(gauge) | Number of hard or soft parses per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.pga_utilization**(gauge) | PGA usage expressed as a percentage, aggregated across all consumer groups. (Statistic: mean, interval: 1 minute).*Shown as percent* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.session_utilization**(gauge) | Maximum session utilization expressed as a percentage, aggregated across all consumer groups. (Statistic: mean, interval: 1 minute).*Shown as percent* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.sga_utilization**(gauge) | SGA usage expressed as a percentage, aggregated across all consumer groups. (Statistic: mean, interval: 1 minute).*Shown as percent* | | **azure.oracle.database_autonomousdatabases.oci_autonomous_database.transactions_by_status**(gauge) | Number of committed or rolled back transactions per second. (Statistic: mean, interval: 1 minute). | | **azure.oracle.database_exadbvmclusters.oci_database_cluster_node_status**(gauge) | Indicates whether the host is reachable. | | **azure.oracle.database_exadbvmclusters.oci_database_block_changes**(gauge) | Average number of blocks changed per second. | | **azure.oracle.database_exadbvmclusters.oci_database_cluster_cpu_utilization**(gauge) | Percent CPU utilization.*Shown as percent* | | **azure.oracle.database_exadbvmclusters.oci_database_cluster_filesystem_utilization**(gauge) | Percent utilization of provisioned filesystem.*Shown as percent* | | **azure.oracle.database_exadbvmclusters.oci_database_cluster_load_average**(gauge) | System load average over 5 minutes. | | **azure.oracle.database_exadbvmclusters.oci_database_cluster_memory_utilization**(gauge) | Percentage of memory available for starting new applications, without swapping. The available memory can be obtained via the following command: cat /proc/meminfo.*Shown as percent* | | **azure.oracle.database_exadbvmclusters.oci_database_cluster_ocpus_allocated**(gauge) | Number of ocpus allocated. | | **azure.oracle.database_exadbvmclusters.oci_database_cluster_swap_utilization**(gauge) | Percent utilization of total swap space.*Shown as percent* | | **azure.oracle.database_exadbvmclusters.oci_database_cpu_utilization**(gauge) | CPU utilization 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.*Shown as percent* | | **azure.oracle.database_exadbvmclusters.oci_database_parse_count**(gauge) | Number of hard and soft parses during the selected interval. | | **azure.oracle.database_exadbvmclusters.oci_database_storage_allocated**(gauge) | Total amount of storage space allocated to the database at the collection time.*Shown as byte* | | **azure.oracle.database_exadbvmclusters.oci_database_storage_allocated_by_tablespace**(gauge) | Total amount of storage space allocated to the tablespace at the collection time. In case of container database, this metric provides root container tablespaces.*Shown as byte* | | **azure.oracle.database_exadbvmclusters.oci_database_storage_used**(gauge) | Total amount of storage space used by the database at the collection time.*Shown as byte* | | **azure.oracle.database_exadbvmclusters.oci_database_storage_used_by_tablespace**(gauge) | Total amount of storage space used by tablespace at the collection time. In case of container database, this metric provides root container tablespaces.*Shown as byte* | | **azure.oracle.database_exadbvmclusters.oci_database_storage_utilization**(gauge) | Percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.*Shown as percent* | | **azure.oracle.database_exadbvmclusters.oci_database_storage_utilization_by_tablespace**(gauge) | This indicates the percentage of storage space utilized by the tablespace at the collection time. In case of container database, this metric provides root container tablespaces..*Shown as percent* | | **azure.oracle.database_exadbvmclusters.oci_database_current_logons**(gauge) | Number of successful logons during the selected interval. | | **azure.oracle.database_exadbvmclusters.oci_database_execute_count**(gauge) | Number of user and recursive calls that executed SQL statements during the selected interval. | | **azure.oracle.database_exadbvmclusters.oci_database_transaction_count**(gauge) | Combined number of user commits and user rollbacks during the selected interval. | | **azure.oracle.database_exadbvmclusters.oci_database_user_calls**(gauge) | Combined number of logons, parses, and execute calls during the selected interval. | ### Events{% #events %} Oracle Database At Azure does not include any events. ### Service Checks{% #service-checks %} Oracle Database At Azure does not include any service checks. ## Troubleshooting{% #troubleshooting %} Need help? Contact [Datadog support](https://docs.datadoghq.com/help/).