obsdog

Oracle Database integration metrics

The official Datadog integration for monitoring Oracle Database. It collects 88 metrics.

Official summary

Oracle relational database system designed for enterprise grid computing

Metric types

  • gauge (value at a point in time): 88

Metrics

Descriptions are the official definitions, unedited.

MetricTypeUnit
oracle.active_backgroundActive background sessionsgauge-
oracle.active_background_on_cpuActive background sessions on CPUgauge-
oracle.active_sessionsNumber of active sessionsgauge-
oracle.active_sessions_on_cpuActive sessions on CPUgauge-
oracle.asm_diskgroup.free_mbThe unused capacity of a disk group in megabytes, tagged by state (DBM only)gauge-
oracle.asm_diskgroup.offline_disksThe number of disks in an ASM disk group that are offline, tagged by state (DBM only)gauge-
oracle.asm_diskgroup.total_mbThe total usable capacity of the disk group, tagged by state (DBM only)gauge-
oracle.avg_synchronous_single_block_read_latencyAverage synchronous single-block read latencygaugemillisecond
oracle.branch_node_splitsBranch node splits per secondgauge-
oracle.buffer_cachehit_ratioRatio of buffer cache hitsgaugepercent
oracle.cache_blocks_corruptCorrupt cache blocksgaugeblock
oracle.cache_blocks_lostLost cache blocksgaugeblock
oracle.consistent_read_changesConsistent read changes per secondgauge-
oracle.consistent_read_getsConsistent read gets per secondgauge-
oracle.data_guard.apply_lagData Guard apply laggaugesecond
oracle.data_guard.transport_lagData Guard transport laggaugesecond
oracle.database_cpu_time_ratioDatabase CPU time ratiogaugepercent
oracle.database_wait_time_ratioMemory sorts per secondgaugepercent
oracle.db_block_changesDB block changes per secondgaugeblock/second
oracle.db_block_getsDB block gets per secondgaugeblock/second
oracle.dbwr_checkpointsDBWR checkpoints per secondgauge-
oracle.disk_sortsDisk sorts per secondgaugeoperation/second
oracle.enqueue_deadlocksEnqueue deadlocks per secondgauge-
oracle.enqueue_timeoutsEnqueue timeouts per secgaugetimeout/second
oracle.execute_without_parseExecute without parse ratiogaugepercent
oracle.gc_average_cr_get_timeGC average CR get timegaugemillisecond
oracle.gc_average_current_get_timeGC average current get timegaugemillisecond
oracle.gc_cr_block_receivedGC CR block receivedgaugeblock/second
oracle.gc_current_block_receivedGC current block received per secondgaugeblock/second
oracle.hard_parsesHard parses per secondgauge-
oracle.host_cpu_utilizationHost CPU utilizationgaugepercent
oracle.leaf_nodes_splitsLeaf node splits per secondgauge-
oracle.library_cachehit_ratioRatio of library cache hitsgaugepercent
oracle.logical_readsLogical reads per secondgaugeread/second
oracle.logonsNumber of logon attemptsgauge-
oracle.long_table_scansNumber of long table scans per secgaugescan/second
oracle.memory_sorts_ratioMemory sorts ratiogaugepercent
oracle.network_traffic_volumeNetwork traffic volume per secondgaugebyte/second
oracle.num_cpusNumber of CPUsgauge-
oracle.os_loadOperating system loadgauge-
oracle.parse_failuresParse failures per secondgauge-
oracle.pga_cache_hitPGA cache hit percentagegaugepercent
oracle.physical_memory_gbPhysical memorygaugegibibyte
oracle.physical_read_bytesPhysical read bytes per secondgaugebyte/second
oracle.physical_read_io_requestsPhysical read IO requests per secondgaugerequest/second
oracle.physical_read_total_bytesPhysical read total bytes per secondgaugebyte/second
oracle.physical_read_total_io_requestsPhysical read total IO requests per secondgaugerequest/second
oracle.physical_readsPhysical reads per secgaugeread/second
oracle.physical_reads_directDirect physical reads per secondgaugeread/second
oracle.physical_reads_direct_lobsDirect physical reads (LOBs) per secondgaugeread/second
oracle.physical_write_bytesPhysical write bytes per secondgaugebyte/second
oracle.physical_write_io_requestsPhysical write IO requests per secondgaugerequest/second
oracle.physical_write_total_bytesPhysical write total bytes per secondgaugebyte/second
oracle.physical_write_total_io_requestsPhysical write total IO requests per secondgaugerequest/second
oracle.physical_writesPhysical writes per secgaugewrite/second
oracle.physical_writes_directDirect physical writes per secondgaugewrite/second
oracle.physical_writes_direct_lobsDirect physical writes (LOBs) per secondgaugewrite/second
oracle.process.pga_allocated_memoryPGA memory allocated by processgaugebyte
oracle.process.pga_freeable_memoryPGA memory freeable by processgaugebyte
oracle.process.pga_max_memoryPGA maximum memory by processgaugebyte
oracle.process.pga_maximum_memoryPGA maximum memory ever allocated by processgaugebyte
oracle.process.pga_used_memoryPGA memory used by processgaugebyte
oracle.process_limitProcess limit usagegaugepercent
oracle.redo_allocation_hit_ratioRedo allocation hit ratiogaugepercent
oracle.redo_generatedRedo generated per secondgaugebyte/second
oracle.redo_writesRedo writes per secondgaugewrite/second
oracle.resource_manager.cpu_consumed_timeResource manager CPU consumed timegaugemillisecond
oracle.resource_manager.cpu_wait_timeResource manager CPU wait timegaugemillisecond
oracle.row_cache_hit_ratioRow cache hit ratiogaugepercent
oracle.rows_per_sortRows per sortgaugerow/operation
oracle.service_response_timeService response timegaugesecond
oracle.session.inactive_secondsSession inactive timegaugesecond
oracle.session_countSession countgauge-
oracle.session_limit_usageSession limit usagegaugepercent
oracle.shared_memory.sizeShared memory sizegaugebyte
oracle.shared_pool_freeShared pool free memory %gaugepercent
oracle.soft_parse_ratioSoft parse ratiogaugepercent
oracle.sorts_per_user_callSorts per user callgauge-
oracle.tablespace.in_useTablespace in-usegaugepercent
oracle.tablespace.maxsizeTablespace maximum sizegaugebyte
oracle.tablespace.offlineTablespace offlinegauge-
oracle.tablespace.sizeTablespace sizegaugebyte
oracle.tablespace.usedTablespace usedgaugebyte
oracle.temp_space_usedTemp space usedgaugebyte
oracle.total_parse_countTotal parse count per secondgauge-
oracle.user_commitsUser commits per secondgauge-
oracle.user_rollbacksnumber of user rollbacksgaugeoperation
oracle.user_sessionsNumber of user sessionsgauge-

Official documentation

Official documentation for the Oracle Database integration

Metric names and descriptions are the official Datadog integration definitions (Copyright Datadog, Inc., BSD-3-Clause), reproduced unedited. The full license terms are on the About page.

Related products

IntegrationsIntegrations are the bundle of entry points that pour data from external systems such as AWS and MySQL into Datadog. Where you configure them splits into two families, the Agent side and the cloud account side, and which one you choose changes both what you can see and how billing is counted.Foundation and data collectionDatabase MonitoringDatabase Monitoring (DBM) lets you identify slow queries, inspect execution plans, and correlate them with the resource state of the database host, all on one screen. It answers the question that collecting DB metrics or viewing queries in APM cannot reach: why is this query slow?Infrastructure monitoringNetwork MonitoringA group of features for finding failures that happen not inside a server but "between servers." With two pillars, CNM, which follows traffic flows on the cloud side, and NDM, which watches routers and switches via SNMP, it fills the blind spot of host monitoring.Infrastructure monitoringDatadog AgentSoftware that runs resident on the servers and containers you monitor and delivers metrics, logs, and traces to Datadog.Foundation and data collection

Other Oracle integrations

WebLogic40 metricsOracle Container Engine for Kubernetes5 metrics