OCI Database

Cette page n'est pas encore disponible en français, sa traduction est en cours.
Si vous avez des questions ou des retours sur notre projet de traduction actuel, n'hésitez pas à nous contacter.

Overview

Oracle Cloud Infrastructure (OCI) provides flexible, high-performance, and secure databases for any workload.

This integration collects key metrics to monitor and alert on CPU and storage utilization, the number of successful and failed database logon and connection attempts, database operations, SQL queries, and transactions.

It collects tags and metrics from Oracle Base Databases and Exadata VM Clusters resources from the following namespaces:

If Oracle Database Management is enabled, this integration also receives metrics from features such as fleet monitoring and SQL Tuning Advisor through the oracle_oci_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_database and oci_database_cluster namespaces are included in your Connector Hub.

Data Collected

Metrics

oci.database.block_changes
(gauge)
The Average number of blocks changed per second.
Shown as update
oci.database.cpu_utilization
(gauge)
The 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
oci.database.current_logons
(count)
The number of successful logons during the selected interval.
oci.database.execute_count
(count)
The number of user and recursive calls that executed SQL statements during the selected interval.
oci.database.parse_count
(count)
The number of hard and soft parses during the selected interval.
oci.database.storage_allocated
(gauge)
Total amount of storage space allocated to the database at the collection time.
Shown as gigabyte
oci.database.storage_allocated_by_tablespace
(gauge)
Total amount of storage space allocated to the tablespace at the collection time. For container databases, this metric provides root container tablespaces.
Shown as gigabyte
oci.database.storage_used
(gauge)
Total amount of storage space used by the database at the collection time.
Shown as gigabyte
oci.database.storage_used_by_tablespace
(gauge)
Total amount of storage space used by tablespace at the collection time. For container databases, this metric provides root container tablespaces.
Shown as gigabyte
oci.database.storage_utilization
(gauge)
The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.
Shown as percent
oci.database.storage_utilization_by_tablespace
(gauge)
This indicates the percentage of storage space utilized by the tablespace at the collection time. For container databases, this metric provides root container tablespaces.
Shown as percent
oci.database.transaction_count
(count)
The combined number of user commits and user rollbacks during the selected interval.
Shown as transaction
oci.database.user_calls
(count)
The combined number of logons, parses, and execute calls during the selected interval.
oci.database_cluster.asmdiskgroup_utilization
(gauge)
Percentage of usable space used in a Disk Group. Usable space is the space available for growth. DATA disk group stores Oracle database files. RECO disk group contains database files for recovery such as archives and flashback logs.
Shown as percent
oci.database_cluster.cpu_utilization
(gauge)
Percent CPU utilization.
Shown as percent
oci.database_cluster.filesystem_utilization
(gauge)
Percent utilization of provisioned filesystem.
Shown as percent
oci.database_cluster.load_average
(gauge)
System load average over 5 minutes.
Shown as process
oci.database_cluster.memory_utilization
(gauge)
Percentage of memory available for starting new applications, without swapping. The available memory can be obtained with the following command: cat/proc/meminfo.
Shown as percent
oci.database_cluster.node_status
(gauge)
Indicates whether the host is reachable in RAC environments.
oci.database_cluster.ocpus_allocated
(gauge)
The number of OCPUs allocated.
Shown as cpu
oci.database_cluster.swap_utilization
(gauge)
Percent utilization of total swap space.
Shown as percent
oci.oracle_oci_database.allocated_storage_utilization_by_tablespace
(gauge)
The percentage of space used by a tablespace, out of allocated space.
Shown as percent
oci.oracle_oci_database.apply_lag
(gauge)
The number of seconds the standby database is behind the primary database. Statistic: Mean. Interval: 5 minutes. Resource group: oracle_dataguard. Not applicable for PDBs.
Shown as second
oci.oracle_oci_database.apply_lag_data_refresh_elapsed_time
(gauge)
The elapsed time since the ApplyLag metric sample was last collected. Statistic: Mean. Interval: 5 minutes. Resource group: oracle_dataguard. Not applicable for PDBs.
Shown as second
oci.oracle_oci_database.avg_gc_cr_block_receive_time
(gauge)
The average global cache consistent-read (CR) block receive time.
Shown as millisecond
oci.oracle_oci_database.backup_duration
(gauge)
The duration of the last database backup. Statistic: Mean. Interval: 30 minutes. Only applicable for SI and RAC CDBs.
Shown as second
oci.oracle_oci_database.backup_size
(gauge)
The size of the last database backup. Statistic: Mean. Interval: 30 minutes. Only applicable for SI and RAC CDBs.
Shown as gigabyte
oci.oracle_oci_database.block_changes
(gauge)
The average number of blocks changed per second.
Shown as update
oci.oracle_oci_database.blocking_sessions
(gauge)
The current blocking sessions.
oci.oracle_oci_database.cputime
(gauge)
The 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.
Shown as fraction
oci.oracle_oci_database.cpu_utilization
(gauge)
The 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
oci.oracle_oci_database.current_logons
(count)
The number of successful logons during the selected interval.
oci.oracle_oci_database.dbtime
(gauge)
The 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.
Shown as fraction
oci.oracle_oci_database.estimated_failover_time
(gauge)
The number of seconds required to fail over to the standby database. Statistic: Mean. Interval: 5 minutes. Resource group: oracle_dataguard. Not applicable for PDBs.
Shown as second
oci.oracle_oci_database.execute_count
(count)
The number of user and recursive calls that executed SQL statements during the selected interval.
Shown as execution
oci.oracle_oci_database.fraspace_limit
(gauge)
The flash recovery area space limit.
Shown as gigabyte
oci.oracle_oci_database.frautilization
(gauge)
The flash recovery area utilization.
Shown as percent
oci.oracle_oci_database.gc_cr_blocks_received
(gauge)
The global cache CR blocks received per second.
Shown as block
oci.oracle_oci_database.gc_current_blocks_received
(gauge)
The global cache current blocks received per second.
Shown as block
oci.oracle_oci_database.iops
(gauge)
The average number of I/O operations per second.
Shown as operation
oci.oracle_oci_database.io_throughput
(gauge)
The average throughput in MB per second.
Shown as megabyte
oci.oracle_oci_database.interconnect_traffic
(gauge)
The average internode data transfer rate.
Shown as megabyte
oci.oracle_oci_database.invalid_objects
(gauge)
The number of invalid database objects.
oci.oracle_oci_database.logical_blocks_read
(gauge)
The average number of blocks read from SGA/Memory (buffer cache) per second.
Shown as read
oci.oracle_oci_database.max_tablespace_size
(gauge)
The maximum possible tablespace size. For CDBs, this metric provides data for root container tablespaces.
Shown as gigabyte
oci.oracle_oci_database.memory_usage
(gauge)
The total size of the memory pool.
Shown as megabyte
oci.oracle_oci_database.monitoring_status
(gauge)
The monitoring status of the resource. If a metric collection fails, error information is captured in this metric.
oci.oracle_oci_database.non_reclaimable_fra
(gauge)
The non-reclaimable fast recovery area.
Shown as percent
oci.oracle_oci_database.ocpus_allocated
(count)
The actual number of OCPUs allocated by the service during the selected interval of time.
oci.oracle_oci_database.parse_count
(count)
The number of hard and soft parses during the selected interval.
oci.oracle_oci_database.parses_by_type
(gauge)
The number of hard or soft parses per second.
Shown as event
oci.oracle_oci_database.problematic_scheduled_dbmsjobs
(gauge)
The number of problematic scheduled database jobs.
Shown as job
oci.oracle_oci_database.process_limit_utilization
(gauge)
The process limit utilization.
Shown as percent
oci.oracle_oci_database.processes
(gauge)
The number of database processes.
Shown as process
oci.oracle_oci_database.reclaimable_fra
(gauge)
The reclaimable fast recovery area.
Shown as percent
oci.oracle_oci_database.reclaimable_fraspace
(gauge)
The flash recovery area reclaimable space.
Shown as gigabyte
oci.oracle_oci_database.recovery_window
(gauge)
The current recovery window of a database. Statistic: Mean. Interval: 15 minutes. Only applicable for SI and RAC CDBs version 19c and later.
Shown as second
oci.oracle_oci_database.redo_apply_rate
(gauge)
The redo apply rate on the standby database. Statistic: Mean. Interval: 5 minutes. Resource group: oracle_dataguard. Not applicable for PDBs.
Shown as megabyte
oci.oracle_oci_database.redo_generation_rate
(gauge)
The redo generation rate on the primary database. Statistic: Mean. Interval: 5 minutes. Resource group: oracle_dataguard. Not applicable for PDBs.
Shown as megabyte
oci.oracle_oci_database.redo_size
(gauge)
The average amount of redo generated.
Shown as megabyte
oci.oracle_oci_database.session_limit_utilization
(gauge)
The session limit utilization.
Shown as percent
oci.oracle_oci_database.sessions
(gauge)
The number of sessions in the database.
Shown as session
oci.oracle_oci_database.storage_allocated
(gauge)
The total amount of storage space allocated to the database at collection time.
Shown as gigabyte
oci.oracle_oci_database.storage_allocated_by_tablespace
(gauge)
The total amount of storage space allocated to the tablespace at collection time. For CDBs, this metric provides root container tablespaces.
Shown as gigabyte
oci.oracle_oci_database.storage_used
(gauge)
The total storage used by the database at collection time, including the space used by tablespaces, flash recovery area, control files, and log files.
Shown as gigabyte
oci.oracle_oci_database.storage_used_by_tablespace
(gauge)
The total amount of storage space used by tablespace at collection time. For CDBs, this metric provides root container tablespace.
Shown as gigabyte
oci.oracle_oci_database.storage_utilization
(gauge)
The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.
Shown as percent
oci.oracle_oci_database.storage_utilization_by_tablespace
(gauge)
The percentage of storage space utilized by the tablespace at the collection time. For CDBs, this metric provides root container tablespaces.
Shown as percent
oci.oracle_oci_database.transaction_count
(count)
The combined number of user commits and user rollbacks during the selected interval.
Shown as transaction
oci.oracle_oci_database.transactions_by_status
(gauge)
The number of committed or rolled back transactions per second.
Shown as transaction
oci.oracle_oci_database.transport_lag
(gauge)
The number of seconds of redo not yet available on the standby database. Statistic: Mean. Interval: 5 minutes. Resource group: oracle_dataguard. Not applicable for PDBs.
Shown as second
oci.oracle_oci_database.transport_lag_data_refresh_elapsed_time
(gauge)
The elapsed time since the TransportLagDataRefreshElapsedTime metric sample was last collected. Statistic: Mean. Interval: 5 minutes. Resource group: oracle_dataguard. Not applicable for PDBs.
Shown as second
oci.oracle_oci_database.unprotected_data_window
(gauge)
The current unprotected data window of a database. Statistic: Mean. Interval: 15 minutes. Only applicable for SI and RAC CDBs version 19c and later.
Shown as second
oci.oracle_oci_database.unusable_indexes
(gauge)
The number of unusable indexes in the database schema.
Shown as index
oci.oracle_oci_database.usable_fra
(gauge)
The usable fast recovery area.
Shown as percent
oci.oracle_oci_database.used_fraspace
(gauge)
The flash recovery area space usage.
Shown as gigabyte
oci.oracle_oci_database.user_calls
(count)
The combined number of logons, parses, and execute calls during the selected interval.
oci.oracle_oci_database.wait_time
(gauge)
The 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.
Shown as fraction
oci.oracle_oci_database.dbmgmt_job_executions_count
(count)
The number of SQL job executions on a single Managed Database or a Database Group, and their status.
Shown as execution

Events

The OCI Database integration does not include any events.

Service Checks

The OCI Database integration does not include any service checks.

Troubleshooting

Need help? Contact Datadog support.