--- title: Oracle AI Database@Google Cloud description: >- Oracle Database services running on OCI Exadata infrastructure inside Google Cloud data centers. breadcrumbs: Docs > Integrations > Oracle AI Database@Google Cloud --- > For the complete documentation index, see [llms.txt](https://docs.datadoghq.com/llms.txt). # Oracle AI Database@Google Cloud 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 AI Database@Google Cloud](https://cloud.google.com/oracle/database/docs/overview) runs Oracle Cloud Infrastructure (OCI) database services on Exadata hardware deployed inside Google Cloud data centers. Your applications and databases run side by side, with minimal latency between them. The offering includes Oracle Exadata Database Service, Oracle Exadata Database Service on Exascale Infrastructure, Oracle Autonomous AI Database Service, Oracle Base Database Service, and Oracle GoldenGate. Get metrics from Oracle AI Database@Google Cloud to: - Visualize the performance and availability of your Autonomous Databases, container databases, and pluggable databases. - Track CPU, memory, storage, and ASM disk group utilization across your Exadata VM clusters and DB systems. - Correlate Oracle database performance with the rest of your Google Cloud infrastructure. ## Setup{% #setup %} ### Installation{% #installation %} If you haven't already, set up the [Google Cloud Platform integration](https://docs.datadoghq.com/integrations/google-cloud-platform.md) first. There are no other installation steps. ### Log collection{% #log-collection %} Oracle AI Database@Google Cloud logs are collected with Google Cloud Logging and sent to a Dataflow job through a Cloud Pub/Sub topic. If you haven't already, [set up logging with the Datadog Dataflow template](https://docs.datadoghq.com/integrations/google-cloud-platform.md#log-collection). After this is done, export your Oracle AI Database@Google Cloud logs from Google Cloud Logging to the Pub/Sub topic: 1. Go to the [Google Cloud Logging page](https://console.cloud.google.com/logs/viewer) and filter the Oracle AI Database@Google Cloud logs. 1. Click **Create Export** and name the sink. 1. Choose **Cloud Pub/Sub** as the destination and select the Pub/Sub topic that was created for that purpose. **Note**: The Pub/Sub topic can be located in a different project. 1. Click **Create** and wait for the confirmation message to appear. ## Data collected{% #data-collected %} ### Metrics{% #metrics %} | | | | | **gcp.oracledatabase.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 your Oracle database files. RECO disk group contains database files for recovery such as archives and flashback logs.*Shown as percent* | | **gcp.oracledatabase.autonomousdatabase.apex_apps**(gauge) | Displays the number of active APEX applications over the time interval. | | **gcp.oracledatabase.autonomousdatabase.apex_page_events**(gauge) | Displays the number of page events over time. | | **gcp.oracledatabase.autonomousdatabase.apex_page_load_time**(gauge) | Average APEX page execution time over the time interval.*Shown as second* | | **gcp.oracledatabase.autonomousdatabase.apex_workspaces**(gauge) | Displays the number of APEX workspaces over the time interval. | | **gcp.oracledatabase.autonomousdatabase.average_active_sessions**(gauge) | The average number of sessions that are actively executing or waiting for resources. | | **gcp.oracledatabase.autonomousdatabase.block_changes**(gauge) | The number of changes that were part of an update or delete operation that were made to all blocks in the SGA. Such changes generate redo log entries and thus become permanent changes to the database if the transaction is committed. This approximates total database work. This statistic indicates the rate at which buffers are being dirtied, during the selected time interval. | | **gcp.oracledatabase.autonomousdatabase.blocking_sessions**(gauge) | The number of current blocking sessions. | | **gcp.oracledatabase.autonomousdatabase.connection_latency**(gauge) | The time taken to connect to an Oracle Autonomous Database Serverless instance in each region from a Compute service virtual machine in the same region.*Shown as millisecond* | | **gcp.oracledatabase.autonomousdatabase.connections_dropped_by_client**(gauge) | The number of connections dropped by the client. | | **gcp.oracledatabase.autonomousdatabase.connections_dropped_by_server**(gauge) | The number of connections dropped by the server. | | **gcp.oracledatabase.autonomousdatabase.cpu_time**(gauge) | Average rate of accumulation of CPU time by foreground sessions in the database over the time interval.*Shown as second* | | **gcp.oracledatabase.autonomousdatabase.cpu_utilization**(gauge) | The 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.*Shown as percent* | | **gcp.oracledatabase.autonomousdatabase.current_logons**(gauge) | The number of successful logons during the selected interval. | | **gcp.oracledatabase.autonomousdatabase.database_availability**(gauge) | Whether the database is available for connections in the given minute. Possible values: 1 (available) and 0 (unavailable). | | **gcp.oracledatabase.autonomousdatabase.db_time**(gauge) | The amount of time database user sessions spend executing database code (CPU time + wait time). DB Time is used to infer database call latency, because DB Time increases in direct proportion to both database call latency (response time) and call volume. It is calculated as the average rate of accumulation of database time by foreground sessions in the database over the time interval.*Shown as second* | | **gcp.oracledatabase.autonomousdatabase.executions**(gauge) | The number of user and recursive calls that executed SQL statements during the selected interval. | | **gcp.oracledatabase.autonomousdatabase.failed_connections**(gauge) | The number of failed database connections. | | **gcp.oracledatabase.autonomousdatabase.failed_logons**(gauge) | The number of logons that failed because of an invalid username, password, or both during the selected interval. | | **gcp.oracledatabase.autonomousdatabase.hard_parses**(gauge) | The 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. | | **gcp.oracledatabase.autonomousdatabase.logical_reads**(gauge) | The 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. | | **gcp.oracledatabase.autonomousdatabase.parse_failures**(gauge) | The number of parse failures during the selected time interval. | | **gcp.oracledatabase.autonomousdatabase.parses**(gauge) | The number of hard and soft parses during the selected interval. | | **gcp.oracledatabase.autonomousdatabase.peer_lag**(gauge) | The total time in seconds by which the Disaster Recovery peer lags behind its Primary database.*Shown as second* | | **gcp.oracledatabase.autonomousdatabase.physical_read_total_bytes**(gauge) | The 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.*Shown as byte* | | **gcp.oracledatabase.autonomousdatabase.physical_reads**(gauge) | The number of data blocks read from disk, during the selected time interval. | | **gcp.oracledatabase.autonomousdatabase.physical_write_total_bytes**(gauge) | The 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.*Shown as byte* | | **gcp.oracledatabase.autonomousdatabase.physical_writes**(gauge) | The number of data blocks written to disk, during the selected time interval. | | **gcp.oracledatabase.autonomousdatabase.query_latency**(gauge) | The time taken to display the results of a simple query on the user's screen.*Shown as millisecond* | | **gcp.oracledatabase.autonomousdatabase.queued_statements**(gauge) | The number of queued SQL statements, aggregated across all consumer groups, during the selected interval. | | **gcp.oracledatabase.autonomousdatabase.redo_generated**(gauge) | Amount of redo generated in bytes, during the selected time interval.*Shown as byte* | | **gcp.oracledatabase.autonomousdatabase.running_statements**(gauge) | The number of running SQL statements, aggregated across all consumer groups, during the selected interval. | | **gcp.oracledatabase.autonomousdatabase.session_utilization**(gauge) | The maximum session utilization expressed as a percentage, aggregated across all consumer groups.*Shown as percent* | | **gcp.oracledatabase.autonomousdatabase.sessions**(gauge) | The number of sessions in the database. | | **gcp.oracledatabase.autonomousdatabase.sqlnet_bytes_from_client**(gauge) | The number of bytes received from the client over Oracle Net Services, during the selected time interval.*Shown as byte* | | **gcp.oracledatabase.autonomousdatabase.sqlnet_bytes_from_dblink**(gauge) | The number of bytes received from a database link over Oracle Net Services, during the selected time interval.*Shown as byte* | | **gcp.oracledatabase.autonomousdatabase.sqlnet_bytes_to_client**(gauge) | The number of bytes sent to the client from the foreground processes, during the selected time interval.*Shown as byte* | | **gcp.oracledatabase.autonomousdatabase.sqlnet_bytes_to_dblink**(gauge) | The number of bytes sent over a database link, during the selected time interval.*Shown as byte* | | **gcp.oracledatabase.autonomousdatabase.storage_allocated**(gauge) | Amount of space allocated to the database for all tablespaces, during the interval. | | **gcp.oracledatabase.autonomousdatabase.storage_max**(gauge) | Maximum amount of storage reserved for the database during the interval. | | **gcp.oracledatabase.autonomousdatabase.storage_used**(gauge) | Maximum amount of space used during the interval. | | **gcp.oracledatabase.autonomousdatabase.storage_utilization**(gauge) | The percentage of the reserved maximum storage currently allocated for all database tablespaces. Represents the total reserved space for all tablespaces.*Shown as percent* | | **gcp.oracledatabase.autonomousdatabase.transactions**(gauge) | The combined number of user commits and user rollbacks during the selected interval. | | **gcp.oracledatabase.autonomousdatabase.user_calls**(gauge) | The combined number of logons, parses, and execute calls during the selected interval. | | **gcp.oracledatabase.autonomousdatabase.user_commits**(gauge) | The 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. | | **gcp.oracledatabase.autonomousdatabase.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. | | **gcp.oracledatabase.autonomousdatabase.wait_time**(gauge) | Average rate of accumulation of non-idle wait time by foreground sessions in the database over the time interval.*Shown as second* | | **gcp.oracledatabase.containerdatabase.block_changes**(gauge) | Changes per second. | | **gcp.oracledatabase.containerdatabase.cpu_utilization**(gauge) | Percent CPU utilization of container database.*Shown as percent* | | **gcp.oracledatabase.containerdatabase.current_logons**(gauge) | The number of successful logons during the selected interval. | | **gcp.oracledatabase.containerdatabase.executions**(gauge) | The number of user and recursive calls that executed SQL statements during the selected interval. | | **gcp.oracledatabase.containerdatabase.parses**(gauge) | The number of hard and soft parses during the selected interval. | | **gcp.oracledatabase.containerdatabase.storage_allocated**(gauge) | Total amount of storage space allocated to the database at the collection time.*Shown as gibibyte* | | **gcp.oracledatabase.containerdatabase.storage_allocated_by_tablespace**(gauge) | Total amount of storage space allocated to the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.containerdatabase.storage_used**(gauge) | Total amount of storage space used by the database at the collection time.*Shown as gibibyte* | | **gcp.oracledatabase.containerdatabase.storage_used_by_tablespace**(gauge) | Total amount of storage space used by the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.containerdatabase.storage_utilization**(gauge) | The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.*Shown as percent* | | **gcp.oracledatabase.containerdatabase.storage_utilization_by_tablespace**(gauge) | The percentage of storage space used by the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as percent* | | **gcp.oracledatabase.containerdatabase.transactions**(gauge) | The combined number of user commits and user rollbacks during the selected interval. | | **gcp.oracledatabase.containerdatabase.user_calls**(gauge) | The combined number of logons, parses, and execute calls during the selected interval. | | **gcp.oracledatabase.cpu_utilization**(gauge) | Percent CPU utilization of the Exadata VM cluster.*Shown as percent* | | **gcp.oracledatabase.db_system.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 your Oracle database files. RECO disk group contains database files for recovery such as archives and flashback logs.*Shown as percent* | | **gcp.oracledatabase.db_system.cpu_utilization**(gauge) | Percent CPU utilization.*Shown as percent* | | **gcp.oracledatabase.db_system.filesystem_utilization**(gauge) | Percent utilization of the provisioned file system.*Shown as percent* | | **gcp.oracledatabase.db_system.load_average**(gauge) | System load average over 5 minutes. | | **gcp.oracledatabase.db_system.memory_utilization**(gauge) | Percentage of memory available for starting new applications, without swapping.*Shown as percent* | | **gcp.oracledatabase.db_system.node_status**(gauge) | Indicates whether the host is reachable. | | **gcp.oracledatabase.db_system.ocpus_allocated**(gauge) | The number of OCPUs allocated. | | **gcp.oracledatabase.db_system.swap_utilization**(gauge) | Percent utilization of total swap space.*Shown as percent* | | **gcp.oracledatabase.db_system_container_database.block_changes**(gauge) | The average number of blocks changed per second. | | **gcp.oracledatabase.db_system_container_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* | | **gcp.oracledatabase.db_system_container_database.current_logons**(gauge) | The number of successful logons during the selected interval. | | **gcp.oracledatabase.db_system_container_database.executions**(gauge) | The number of user and recursive calls that executed SQL statements during the selected interval. | | **gcp.oracledatabase.db_system_container_database.parses**(gauge) | The number of hard and soft parses during the selected interval. | | **gcp.oracledatabase.db_system_container_database.storage_allocated**(gauge) | Total amount of storage space allocated to the database at the collection time.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_container_database.storage_allocated_by_tablespace**(gauge) | Total amount of storage space allocated to the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_container_database.storage_used**(gauge) | Total amount of storage space used by the database at the collection time.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_container_database.storage_used_by_tablespace**(gauge) | Total amount of storage space used by the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_container_database.storage_utilization**(gauge) | The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.*Shown as percent* | | **gcp.oracledatabase.db_system_container_database.storage_utilization_by_tablespace**(gauge) | The percentage of storage space used by the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as percent* | | **gcp.oracledatabase.db_system_container_database.transactions**(gauge) | The combined number of user commits and user rollbacks during the selected interval. | | **gcp.oracledatabase.db_system_container_database.user_calls**(gauge) | The combined number of logons, parses, and execute calls during the selected interval. | | **gcp.oracledatabase.db_system_pluggable_database.allocated_storage_utilization_by_tablespace**(gauge) | The percentage of space used by a tablespace, out of allocated space. For container databases, this metric provides data for root container tablespaces.*Shown as percent* | | **gcp.oracledatabase.db_system_pluggable_database.apply_lag**(gauge) | The number of seconds the standby database is behind the primary database.*Shown as second* | | **gcp.oracledatabase.db_system_pluggable_database.apply_lag_data_refresh_elapsed_time**(gauge) | The elapsed time since the ApplyLag metric sample was last collected.*Shown as second* | | **gcp.oracledatabase.db_system_pluggable_database.avg_gc_current_block_receive_time**(gauge) | The average global cache current blocks receive time. Statistic reports the mean value. For Real Application Cluster (RAC) databases only.*Shown as millisecond* | | **gcp.oracledatabase.db_system_pluggable_database.avg_gccr_block_receive_time**(gauge) | The average global cache consistent-read (CR) block receive time.*Shown as millisecond* | | **gcp.oracledatabase.db_system_pluggable_database.backup_duration**(gauge) | The duration of the last database backup.*Shown as second* | | **gcp.oracledatabase.db_system_pluggable_database.backup_size**(gauge) | The size of the last database backup.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_pluggable_database.block_changes**(gauge) | The average number of blocks changed per second. | | **gcp.oracledatabase.db_system_pluggable_database.blocking_sessions**(gauge) | The number of current blocking sessions. | | **gcp.oracledatabase.db_system_pluggable_database.cpu_time**(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 second* | | **gcp.oracledatabase.db_system_pluggable_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* | | **gcp.oracledatabase.db_system_pluggable_database.cpus**(gauge) | The number of CPUs during the selected interval. | | **gcp.oracledatabase.db_system_pluggable_database.cpus_enabled**(gauge) | The number of CPUs or processors available on the database instance. | | **gcp.oracledatabase.db_system_pluggable_database.current_logons**(gauge) | The number of successful logons during the selected interval. | | **gcp.oracledatabase.db_system_pluggable_database.db_mgmt_job_executions**(gauge) | The 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, and InProgress. | | **gcp.oracledatabase.db_system_pluggable_database.db_time**(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 second* | | **gcp.oracledatabase.db_system_pluggable_database.ecpus_allocated**(gauge) | The actual number of ECPUs allocated by the service during the selected interval. This metric is available if the VM cluster uses the ECPU compute model. | | **gcp.oracledatabase.db_system_pluggable_database.estimated_failover_time**(gauge) | The number of seconds required to fail over to the standby database.*Shown as second* | | **gcp.oracledatabase.db_system_pluggable_database.executions**(gauge) | The number of user and recursive calls that executed SQL statements during the selected interval. | | **gcp.oracledatabase.db_system_pluggable_database.fra_space_limit**(gauge) | The fast recovery area space limit.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_pluggable_database.fra_utilization**(gauge) | The fast recovery area utilization.*Shown as percent* | | **gcp.oracledatabase.db_system_pluggable_database.gcc_current_blocks_received**(gauge) | The global cache current blocks received per second. | | **gcp.oracledatabase.db_system_pluggable_database.gccr_blocks_received**(gauge) | The global cache CR blocks received per second. | | **gcp.oracledatabase.db_system_pluggable_database.interconnect_traffic**(gauge) | The average internode data transfer rate.*Shown as mebibyte* | | **gcp.oracledatabase.db_system_pluggable_database.invalid_objects**(gauge) | The number of invalid database objects. | | **gcp.oracledatabase.db_system_pluggable_database.io_throughput**(gauge) | The average throughput in MB per second.*Shown as mebibyte* | | **gcp.oracledatabase.db_system_pluggable_database.iops**(gauge) | The average number of IO operations per second. | | **gcp.oracledatabase.db_system_pluggable_database.logical_blocks_read**(gauge) | The average number of blocks read from the SGA buffer cache per second. | | **gcp.oracledatabase.db_system_pluggable_database.max_tablespace_size**(gauge) | The maximum possible tablespace size. For container databases, this metric provides data for root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_pluggable_database.memory_usage**(gauge) | The total size of the memory pool.*Shown as mebibyte* | | **gcp.oracledatabase.db_system_pluggable_database.monitoring_status**(gauge) | The monitoring status of the resource. If metric collection fails, error information is captured in this metric. | | **gcp.oracledatabase.db_system_pluggable_database.monitoring_user_password_expiration**(gauge) | The number of days left before the monitoring user password expires. | | **gcp.oracledatabase.db_system_pluggable_database.non_reclaimable_fra**(gauge) | The non-reclaimable fast recovery area.*Shown as percent* | | **gcp.oracledatabase.db_system_pluggable_database.ocpus_allocated**(gauge) | The actual number of OCPUs allocated by the service during the selected interval of time. | | **gcp.oracledatabase.db_system_pluggable_database.parses**(gauge) | The number of hard and soft parses during the selected interval. | | **gcp.oracledatabase.db_system_pluggable_database.parses_by_type**(gauge) | The number of hard or soft parses per second. | | **gcp.oracledatabase.db_system_pluggable_database.problematic_scheduled_dbms_jobs**(gauge) | The number of problematic scheduled database jobs. | | **gcp.oracledatabase.db_system_pluggable_database.process_limit_utilization**(gauge) | The process limit utilization.*Shown as percent* | | **gcp.oracledatabase.db_system_pluggable_database.processes**(gauge) | The number of database processes. | | **gcp.oracledatabase.db_system_pluggable_database.reclaimable_fra_space**(gauge) | The fast recovery area reclaimable space.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_pluggable_database.recoverable_fra**(gauge) | The reclaimable fast recovery area.*Shown as percent* | | **gcp.oracledatabase.db_system_pluggable_database.recovery_window**(gauge) | The current recovery window of a database.*Shown as second* | | **gcp.oracledatabase.db_system_pluggable_database.redo_apply_rate**(gauge) | The redo apply rate on the standby database.*Shown as mebibyte* | | **gcp.oracledatabase.db_system_pluggable_database.redo_generation_rate**(gauge) | The redo generation rate on the primary database.*Shown as mebibyte* | | **gcp.oracledatabase.db_system_pluggable_database.redo_size**(gauge) | The average amount of redo generated.*Shown as mebibyte* | | **gcp.oracledatabase.db_system_pluggable_database.retention_period**(gauge) | The number of days for which database backups are retained. | | **gcp.oracledatabase.db_system_pluggable_database.session_limit_utilization**(gauge) | The session limit utilization.*Shown as percent* | | **gcp.oracledatabase.db_system_pluggable_database.sessions**(gauge) | The number of sessions in the database. | | **gcp.oracledatabase.db_system_pluggable_database.storage_allocated**(gauge) | The total amount of storage space allocated to the database at collection time.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_pluggable_database.storage_allocated_by_tablespace**(gauge) | The total amount of storage space allocated to the tablespace at collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_pluggable_database.storage_used**(gauge) | The total storage used by the database at collection time, including the space used by tablespaces, fast recovery area, control files, and log files.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_pluggable_database.storage_used_by_tablespace**(gauge) | The total amount of storage space used by the tablespace at collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_pluggable_database.storage_utilization**(gauge) | The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.*Shown as percent* | | **gcp.oracledatabase.db_system_pluggable_database.storage_utilization_by_tablespace**(gauge) | The percentage of storage space used by the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as percent* | | **gcp.oracledatabase.db_system_pluggable_database.transactions**(gauge) | The combined number of user commits and user rollbacks during the selected interval. | | **gcp.oracledatabase.db_system_pluggable_database.transactions_by_status**(gauge) | The number of committed or rolled back transactions per second. | | **gcp.oracledatabase.db_system_pluggable_database.transport_lag**(gauge) | The number of seconds of redo not yet available on the standby database.*Shown as second* | | **gcp.oracledatabase.db_system_pluggable_database.transport_lag_data_refresh_elapsed_time**(gauge) | The elapsed time since the TransportLagDataRefreshElapsedTime metric sample was last collected.*Shown as second* | | **gcp.oracledatabase.db_system_pluggable_database.unprotected_data_window**(gauge) | The current unprotected data window of a database.*Shown as second* | | **gcp.oracledatabase.db_system_pluggable_database.unusable_indexes**(gauge) | The number of unusable indexes in the database schema. | | **gcp.oracledatabase.db_system_pluggable_database.usable_fra**(gauge) | The usable fast recovery area.*Shown as percent* | | **gcp.oracledatabase.db_system_pluggable_database.used_fra_space**(gauge) | The fast recovery area space usage.*Shown as gibibyte* | | **gcp.oracledatabase.db_system_pluggable_database.user_calls**(gauge) | The combined number of logons, parses, and execute calls during the selected interval. | | **gcp.oracledatabase.db_system_pluggable_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 second* | | **gcp.oracledatabase.exadb_containerdatabase.block_changes**(gauge) | Changes per second. | | **gcp.oracledatabase.exadb_containerdatabase.cpu_utilization**(gauge) | Percent CPU utilization of container database.*Shown as percent* | | **gcp.oracledatabase.exadb_containerdatabase.current_logons**(gauge) | The number of successful logons during the selected interval. | | **gcp.oracledatabase.exadb_containerdatabase.executions**(gauge) | The number of user and recursive calls that executed SQL statements during the selected interval. | | **gcp.oracledatabase.exadb_containerdatabase.parses**(gauge) | The number of hard and soft parses during the selected interval. | | **gcp.oracledatabase.exadb_containerdatabase.redo_generation_rate**(gauge) | The redo generation rate on the primary database.*Shown as mebibyte* | | **gcp.oracledatabase.exadb_containerdatabase.storage_allocated**(gauge) | Total amount of storage space allocated to the database at the collection time.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_containerdatabase.storage_allocated_by_tablespace**(gauge) | Total amount of storage space allocated to the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_containerdatabase.storage_used**(gauge) | Total amount of storage space used by the database at the collection time.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_containerdatabase.storage_used_by_tablespace**(gauge) | Total amount of storage space used by the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_containerdatabase.storage_utilization**(gauge) | The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.*Shown as percent* | | **gcp.oracledatabase.exadb_containerdatabase.storage_utilization_by_tablespace**(gauge) | The percentage of storage space used by the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces.*Shown as percent* | | **gcp.oracledatabase.exadb_containerdatabase.transactions**(gauge) | The combined number of user commits and user rollbacks during the selected interval. | | **gcp.oracledatabase.exadb_containerdatabase.user_calls**(gauge) | The combined number of logons, parses, and execute calls during the selected interval. | | **gcp.oracledatabase.exadb_pluggabledatabase.allocated_storage_utilization_by_tablespace**(gauge) | The percentage of space used by a tablespace, out of allocated space. For container databases, this metric provides data for root container tablespaces.*Shown as percent* | | **gcp.oracledatabase.exadb_pluggabledatabase.avg_gc_current_block_receive_time**(gauge) | The average global cache current blocks receive time. Statistic reports the mean value. For Real Application Cluster (RAC) databases only.*Shown as millisecond* | | **gcp.oracledatabase.exadb_pluggabledatabase.avg_gccr_block_receive_time**(gauge) | The average global cache CR (consistent-read) block receive time. For Real Application Cluster (RAC) databases only.*Shown as millisecond* | | **gcp.oracledatabase.exadb_pluggabledatabase.block_changes**(gauge) | The average number of blocks changed per second. | | **gcp.oracledatabase.exadb_pluggabledatabase.blocking_sessions**(gauge) | The number of current blocking sessions. Not applicable for container databases. | | **gcp.oracledatabase.exadb_pluggabledatabase.cpu_time**(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 second* | | **gcp.oracledatabase.exadb_pluggabledatabase.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* | | **gcp.oracledatabase.exadb_pluggabledatabase.cpus**(gauge) | The number of CPUs during the selected interval. | | **gcp.oracledatabase.exadb_pluggabledatabase.current_logons**(gauge) | The number of successful logons during the selected interval. | | **gcp.oracledatabase.exadb_pluggabledatabase.db_mgmt_job_executions**(gauge) | The number of SQL job executions on a single managed database or a database group, and their status. | | **gcp.oracledatabase.exadb_pluggabledatabase.db_time**(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 second* | | **gcp.oracledatabase.exadb_pluggabledatabase.ecpus_allocated**(gauge) | The actual number of ECPUs allocated by the service during the selected interval. This metric is available if the VM cluster uses the ECPU compute model. | | **gcp.oracledatabase.exadb_pluggabledatabase.executions**(gauge) | The number of user and recursive calls that executed SQL statements during the selected interval. | | **gcp.oracledatabase.exadb_pluggabledatabase.fra_space_limit**(gauge) | The fast recovery area space limit.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.fra_utilization**(gauge) | The fast recovery area utilization.*Shown as percent* | | **gcp.oracledatabase.exadb_pluggabledatabase.gc_current_blocks_received**(gauge) | The global cache current blocks received per second. Statistic reports the mean value. For Real Application Cluster (RAC) databases only. | | **gcp.oracledatabase.exadb_pluggabledatabase.gccr_blocks_received**(gauge) | The global cache CR (consistent-read) blocks received per second. For Real Application Cluster (RAC) databases only. | | **gcp.oracledatabase.exadb_pluggabledatabase.interconnect_traffic**(gauge) | The average internode data transfer rate. For Real Application Cluster (RAC) databases only.*Shown as mebibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.invalid_objects**(gauge) | The number of invalid database objects. Not applicable for container databases. | | **gcp.oracledatabase.exadb_pluggabledatabase.io_throughput**(gauge) | The average throughput in MB per second.*Shown as mebibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.iops**(gauge) | The average number of I/O operations per second. | | **gcp.oracledatabase.exadb_pluggabledatabase.logical_blocks_read**(gauge) | The average number of blocks read from the SGA buffer cache per second. | | **gcp.oracledatabase.exadb_pluggabledatabase.max_tablespace_size**(gauge) | The maximum possible tablespace size. For container databases, this metric provides data for root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.memory_usage**(gauge) | The total size of the memory pool.*Shown as mebibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.monitoring_status**(gauge) | The monitoring status of the resource. If metric collection fails, error information is captured in this metric. | | **gcp.oracledatabase.exadb_pluggabledatabase.monitoring_user_password_expiration**(gauge) | The number of days left before the monitoring user password expires. | | **gcp.oracledatabase.exadb_pluggabledatabase.non_reclaimable_fra**(gauge) | The non-reclaimable fast recovery area.*Shown as percent* | | **gcp.oracledatabase.exadb_pluggabledatabase.ocpus_allocated**(gauge) | The actual number of OCPUs allocated by the service during the selected interval of time. | | **gcp.oracledatabase.exadb_pluggabledatabase.parses**(gauge) | The number of hard and soft parses during the selected interval. | | **gcp.oracledatabase.exadb_pluggabledatabase.parses_by_type**(gauge) | The number of hard or soft parses per second. | | **gcp.oracledatabase.exadb_pluggabledatabase.problematic_scheduled_dbms_jobs**(gauge) | The number of problematic scheduled database jobs. Not applicable for container databases. | | **gcp.oracledatabase.exadb_pluggabledatabase.process_limit_utilization**(gauge) | The process limit utilization.*Shown as percent* | | **gcp.oracledatabase.exadb_pluggabledatabase.processes**(gauge) | The number of database processes. | | **gcp.oracledatabase.exadb_pluggabledatabase.reclaimable_fra_space**(gauge) | The fast recovery area reclaimable space.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.recoverable_fra**(gauge) | The reclaimable fast recovery area.*Shown as percent* | | **gcp.oracledatabase.exadb_pluggabledatabase.redo_size**(gauge) | The average amount of redo generated, in MB per second.*Shown as mebibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.session_limit_utilization**(gauge) | The session limit utilization.*Shown as percent* | | **gcp.oracledatabase.exadb_pluggabledatabase.sessions**(gauge) | The number of sessions in the database. | | **gcp.oracledatabase.exadb_pluggabledatabase.storage_allocated**(gauge) | The maximum amount of space allocated by tablespace during the interval.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.storage_allocated_by_tablespace**(gauge) | The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.storage_used**(gauge) | The maximum amount of space used during the interval.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.storage_used_by_tablespace**(gauge) | The maximum amount of space used by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.storage_utilization**(gauge) | The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.*Shown as percent* | | **gcp.oracledatabase.exadb_pluggabledatabase.storage_utilization_by_tablespace**(gauge) | The percentage of space used by a tablespace. For container databases, this metric provides data for root container tablespaces.*Shown as percent* | | **gcp.oracledatabase.exadb_pluggabledatabase.transactions**(gauge) | The combined number of user commits and user rollbacks during the selected interval. | | **gcp.oracledatabase.exadb_pluggabledatabase.transactions_by_status**(gauge) | The number of committed or rolled back transactions per second. | | **gcp.oracledatabase.exadb_pluggabledatabase.unusable_indexes**(gauge) | The number of unusable indexes in the database schema. Not applicable for container databases. | | **gcp.oracledatabase.exadb_pluggabledatabase.usable_fra**(gauge) | The usable fast recovery area.*Shown as percent* | | **gcp.oracledatabase.exadb_pluggabledatabase.used_fra_space**(gauge) | The fast recovery area space usage.*Shown as gibibyte* | | **gcp.oracledatabase.exadb_pluggabledatabase.user_calls**(gauge) | The combined number of logons, parses, and execute calls during the selected interval. | | **gcp.oracledatabase.exadb_pluggabledatabase.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 second* | | **gcp.oracledatabase.exadb_vm_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 your Oracle database files. RECO disk group contains database files for recovery such as archives and flashback logs.*Shown as percent* | | **gcp.oracledatabase.exadb_vm_cluster.cpu_utilization**(gauge) | Percent CPU utilization of the Exascale VM cluster.*Shown as percent* | | **gcp.oracledatabase.exadb_vm_cluster.ecpus_enabled**(gauge) | The actual number of ECPUs enabled by the service during the selected interval. This metric is available if the VM cluster uses the ECPU compute model. | | **gcp.oracledatabase.exadb_vm_cluster.exascale_vault_utilization**(gauge) | Percent utilization of the Exascale vault.*Shown as percent* | | **gcp.oracledatabase.exadb_vm_cluster.filesystem_utilization**(gauge) | Percent utilization of the provisioned file system.*Shown as percent* | | **gcp.oracledatabase.exadb_vm_cluster.load_average**(gauge) | System load average over 5 minutes. | | **gcp.oracledatabase.exadb_vm_cluster.memory_utilization**(gauge) | Percentage of memory available for starting new applications, without swapping.*Shown as percent* | | **gcp.oracledatabase.exadb_vm_cluster.node_status**(gauge) | Indicates whether the host is reachable. | | **gcp.oracledatabase.exadb_vm_cluster.ocpus_allocated**(gauge) | The number of OCPUs allocated. | | **gcp.oracledatabase.exadb_vm_cluster.swap_utilization**(gauge) | Percent utilization of total swap space.*Shown as percent* | | **gcp.oracledatabase.filesystem_utilization**(gauge) | Percent utilization of the provisioned file system.*Shown as percent* | | **gcp.oracledatabase.load_average**(gauge) | System load average over 5 minutes. | | **gcp.oracledatabase.memory_utilization**(gauge) | Percentage of memory available for starting new applications, without swapping.*Shown as percent* | | **gcp.oracledatabase.node_status**(gauge) | Indicates whether the host is reachable. | | **gcp.oracledatabase.ocpus_allocated**(gauge) | The number of OCPUs allocated. | | **gcp.oracledatabase.pluggabledatabase.allocated_storage_utilization_by_tablespace**(gauge) | The percentage of space used by a tablespace, out of allocated space. For container databases, this metric provides data for root container tablespaces.*Shown as percent* | | **gcp.oracledatabase.pluggabledatabase.avg_gc_current_block_receive_time**(gauge) | The average global cache current blocks receive time. Statistic reports the mean value. For Real Application Cluster (RAC) databases only.*Shown as millisecond* | | **gcp.oracledatabase.pluggabledatabase.avg_gccr_block_receive_time**(gauge) | The average global cache CR (consistent-read) block receive time. For Real Application Cluster (RAC) databases only.*Shown as millisecond* | | **gcp.oracledatabase.pluggabledatabase.block_changes**(gauge) | The average number of blocks changed per second. | | **gcp.oracledatabase.pluggabledatabase.blocking_sessions**(gauge) | The number of current blocking sessions. Not applicable for container databases. | | **gcp.oracledatabase.pluggabledatabase.cpu_time**(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 second* | | **gcp.oracledatabase.pluggabledatabase.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* | | **gcp.oracledatabase.pluggabledatabase.cpus**(gauge) | The number of CPUs during the selected interval. | | **gcp.oracledatabase.pluggabledatabase.current_logons**(gauge) | The number of successful logons during the selected interval. | | **gcp.oracledatabase.pluggabledatabase.db_mgmt_job_executions**(gauge) | The number of SQL job executions on a single managed database or a database group, and their status. | | **gcp.oracledatabase.pluggabledatabase.db_time**(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 second* | | **gcp.oracledatabase.pluggabledatabase.executions**(gauge) | The number of user and recursive calls that executed SQL statements during the selected interval. | | **gcp.oracledatabase.pluggabledatabase.fra_space_limit**(gauge) | The fast recovery area space limit.*Shown as gibibyte* | | **gcp.oracledatabase.pluggabledatabase.fra_utilization**(gauge) | The fast recovery area utilization.*Shown as percent* | | **gcp.oracledatabase.pluggabledatabase.gc_current_blocks_received**(gauge) | The global cache current blocks received per second. Statistic reports the mean value. For Real Application Cluster (RAC) databases only. | | **gcp.oracledatabase.pluggabledatabase.gccr_blocks_received**(gauge) | The global cache CR (consistent-read) blocks received per second. For Real Application Cluster (RAC) databases only. | | **gcp.oracledatabase.pluggabledatabase.interconnect_traffic**(gauge) | The average internode data transfer rate. For Real Application Cluster (RAC) databases only.*Shown as mebibyte* | | **gcp.oracledatabase.pluggabledatabase.invalid_objects**(gauge) | The number of invalid database objects. Not applicable for container databases. | | **gcp.oracledatabase.pluggabledatabase.io_throughput**(gauge) | The average throughput in MB per second.*Shown as mebibyte* | | **gcp.oracledatabase.pluggabledatabase.iops**(gauge) | The average number of I/O operations per second. | | **gcp.oracledatabase.pluggabledatabase.logical_blocks_read**(gauge) | The average number of blocks read from the SGA buffer cache per second. | | **gcp.oracledatabase.pluggabledatabase.max_tablespace_size**(gauge) | The maximum possible tablespace size. For container databases, this metric provides data for root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.pluggabledatabase.memory_usage**(gauge) | The total size of the memory pool.*Shown as mebibyte* | | **gcp.oracledatabase.pluggabledatabase.monitoring_status**(gauge) | The monitoring status of the resource. If metric collection fails, error information is captured in this metric. | | **gcp.oracledatabase.pluggabledatabase.non_reclaimable_fra**(gauge) | The non-reclaimable fast recovery area.*Shown as percent* | | **gcp.oracledatabase.pluggabledatabase.ocpus_allocated**(gauge) | The actual number of OCPUs allocated by the service during the selected interval of time. | | **gcp.oracledatabase.pluggabledatabase.parses**(gauge) | The number of hard and soft parses during the selected interval. | | **gcp.oracledatabase.pluggabledatabase.parses_by_type**(gauge) | The number of hard or soft parses per second. | | **gcp.oracledatabase.pluggabledatabase.problematic_scheduled_dbms_jobs**(gauge) | The number of problematic scheduled database jobs. Not applicable for container databases. | | **gcp.oracledatabase.pluggabledatabase.process_limit_utilization**(gauge) | The process limit utilization.*Shown as percent* | | **gcp.oracledatabase.pluggabledatabase.processes**(gauge) | The number of database processes. | | **gcp.oracledatabase.pluggabledatabase.reclaimable_fra_space**(gauge) | The fast recovery area reclaimable space.*Shown as gibibyte* | | **gcp.oracledatabase.pluggabledatabase.recoverable_fra**(gauge) | The reclaimable fast recovery area.*Shown as percent* | | **gcp.oracledatabase.pluggabledatabase.redo_size**(gauge) | The average amount of redo generated, in MB per second.*Shown as mebibyte* | | **gcp.oracledatabase.pluggabledatabase.session_limit_utilization**(gauge) | The session limit utilization.*Shown as percent* | | **gcp.oracledatabase.pluggabledatabase.sessions**(gauge) | The number of sessions in the database. | | **gcp.oracledatabase.pluggabledatabase.storage_allocated**(gauge) | The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.pluggabledatabase.storage_allocated_by_tablespace**(gauge) | The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.pluggabledatabase.storage_used**(gauge) | The maximum amount of space used during the interval.*Shown as gibibyte* | | **gcp.oracledatabase.pluggabledatabase.storage_used_by_tablespace**(gauge) | The maximum amount of space used by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.*Shown as gibibyte* | | **gcp.oracledatabase.pluggabledatabase.storage_utilization**(gauge) | The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.*Shown as percent* | | **gcp.oracledatabase.pluggabledatabase.storage_utilization_by_tablespace**(gauge) | The percentage of space used by a tablespace. For container databases, this metric provides data for root container tablespaces.*Shown as percent* | | **gcp.oracledatabase.pluggabledatabase.transactions**(gauge) | The combined number of user commits and user rollbacks during the selected interval. | | **gcp.oracledatabase.pluggabledatabase.transactions_by_status**(gauge) | The number of committed or rolled back transactions per second. | | **gcp.oracledatabase.pluggabledatabase.unusable_indexes**(gauge) | The number of unusable indexes in the database schema. Not applicable for container databases. | | **gcp.oracledatabase.pluggabledatabase.usable_fra**(gauge) | The usable fast recovery area.*Shown as percent* | | **gcp.oracledatabase.pluggabledatabase.used_fra_space**(gauge) | The fast recovery area space usage.*Shown as gibibyte* | | **gcp.oracledatabase.pluggabledatabase.user_calls**(gauge) | The combined number of logons, parses, and execute calls during the selected interval. | | **gcp.oracledatabase.pluggabledatabase.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 second* | | **gcp.oracledatabase.swap_utilization**(gauge) | Percent utilization of total swap space.*Shown as percent* | ### Events{% #events %} The Oracle AI Database@Google Cloud integration does not include any events. ### Service Checks{% #service-checks %} The Oracle AI Database@Google Cloud integration does not include any service checks. ## Troubleshooting{% #troubleshooting %} Need help? Contact [Datadog support](https://docs.datadoghq.com/help/).