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 |
