Oracle Database

Supported OS Linux Windows Mac OS

Oracle Dashboard

Overview

The Oracle integration has been moved to https://github.com/DataDog/datadog-agent/tree/main/pkg/collector/corechecks/oracle. This folder is maintained only for the Oracle dashboard.

Setup

Please see https://docs.datadoghq.com/integrations/oracle for setup instructions.

Data Collected

Metrics

oracle.active_sessions
(gauge)
Number of active sessions
oracle.asm_diskgroup.free_mb
(gauge)
The unused capacity of a disk group in megabytes, tagged by state (DBM only)
oracle.asm_diskgroup.offline_disks
(gauge)
The number of disks in an ASM disk group that are offline, tagged by state (DBM only)
oracle.asm_diskgroup.total_mb
(gauge)
The total usable capacity of the disk group, tagged by state (DBM only)
oracle.buffer_cachehit_ratio
(gauge)
Ratio of buffer cache hits
Shown as percent
oracle.cache_blocks_corrupt
(gauge)
Corrupt cache blocks
Shown as block
oracle.cache_blocks_lost
(gauge)
Lost cache blocks
Shown as block
oracle.database_wait_time_ratio
(gauge)
Memory sorts per second
Shown as percent
oracle.disk_sorts
(gauge)
Disk sorts per second
Shown as operation
oracle.enqueue_timeouts
(gauge)
Enqueue timeouts per sec
Shown as timeout
oracle.gc_cr_block_received
(gauge)
GC CR block received
Shown as block
oracle.library_cachehit_ratio
(gauge)
Ratio of library cache hits
Shown as percent
oracle.logons
(gauge)
Number of logon attempts
oracle.long_table_scans
(gauge)
Number of long table scans per sec
Shown as scan
oracle.memory_sorts_ratio
(gauge)
Memory sorts ratio
Shown as percent
oracle.physical_reads
(gauge)
Physical reads per sec
Shown as read
oracle.physical_writes
(gauge)
Physical writes per sec
Shown as write
oracle.process.pga_allocated_memory
(gauge)
PGA memory allocated by process
Shown as byte
oracle.process.pga_freeable_memory
(gauge)
PGA memory freeable by process
Shown as byte
oracle.process.pga_maximum_memory
(gauge)
PGA maximum memory ever allocated by process
Shown as byte
oracle.process.pga_used_memory
(gauge)
PGA memory used by process
Shown as byte
oracle.rows_per_sort
(gauge)
Rows per sort
Shown as row
oracle.service_response_time
(gauge)
Service response time
Shown as second
oracle.session_count
(gauge)
Session count
oracle.session_limit_usage
(gauge)
Session limit usage
Shown as percent
oracle.shared_pool_free
(gauge)
Shared pool free memory %
Shown as percent
oracle.sorts_per_user_call
(gauge)
Sorts per user call
oracle.tablespace.in_use
(gauge)
Tablespace in-use
Shown as percent
oracle.tablespace.offline
(gauge)
Tablespace offline
oracle.tablespace.size
(gauge)
Tablespace size
Shown as byte
oracle.tablespace.used
(gauge)
Tablespace used
Shown as byte
oracle.temp_space_used
(gauge)
Temp space used
Shown as byte
oracle.user_rollbacks
(gauge)
number of user rollbacks
Shown as operation

Service Checks

oracle.can_connect

Returns OK if the integration can connect to the oracle database, CRITICAL otherwise

Statuses: ok, critical

oracle.can_query

Returns OK if the integration can run all the queries, CRITICAL otherwise

Statuses: ok, critical

Troubleshooting

Need help? Contact Datadog support.