Supported metrics for Oracle.Database/cloudVmClusters

The following table lists the metrics available for the Oracle.Database/cloudVmClusters resource type.

Table headings

Metric - The metric display name as it appears in the Azure portal.
Name in Rest API - Metric name as referred to in the REST API.
Unit - Unit of measure.
Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, Count.
Dimensions - Dimensions available for the metric.
Time Grains - Intervals at which the metric is sampled. For example, PT1M indicates that the metric is sampled every minute, PT30M every 30 minutes, PT1H every hour, and so on.
DS Export- Whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.

For information on exporting metrics, see Create diagnostic settings in Azure Monitor.

For information on metric retention, see Azure Monitor Metrics overview.

Category Metric Name in REST API Unit Aggregation Dimensions Time Grains DS Export
Saturation ASM Diskgroup Utilization

Percentage of usable space used in a Disk Group. Usable space is the space available for growth. DATA disk group stores our Oracle database files. RECO disk group contains database files for recovery such as archives and flashback logs.
oci_database_cluster/ASMDiskgroupUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, diskgroupName PT1M Yes
Saturation CPU Utilization (OCI Database Cluster)

Percent CPU utilization
oci_database_cluster/CpuUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode PT1M Yes
Saturation Filesystem Utilization

Percent utilization of provisioned filesystem
oci_database_cluster/FilesystemUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode, filesystemName PT1M Yes
Saturation Load Average

System load average over 5 minutes
oci_database_cluster/LoadAverage Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode PT1M Yes
Saturation Memory Utilization

Percentage of memory available for starting new applications, without swapping. The available memory can be obtained via the following command: cat /proc/meminfo
oci_database_cluster/MemoryUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode PT1M Yes
Availability Node Status

Indicates whether the host is reachable.
oci_database_cluster/NodeStatus Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode PT1M Yes
Saturation OCPU Allocated (OCI Database Cluster)

The number of OCPUs allocated
oci_database_cluster/OcpusAllocated Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode PT1M Yes
Saturation Swap Utilization

Percent utilization of total swap space
oci_database_cluster/SwapUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode PT1M Yes
Saturation DB Block Changes (OCI Database)

The Average number of blocks changed per second.
oci_database/BlockChanges CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1M Yes
Saturation CPU Utilization (OCI Database)

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.
oci_database/CpuUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1M Yes
Traffic Current Logons (OCI Database)

The number of successful logons during the selected interval.
oci_database/CurrentLogons Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1M Yes
Traffic Execute Count (OCI Database)

The number of user and recursive calls that executed SQL statements during the selected interval.
oci_database/ExecuteCount Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1M Yes
Saturation Parse Count

The number of hard and soft parses during the selected interval.
oci_database/ParseCount Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1M Yes
Saturation Storage Space Allocated

Total amount of storage space allocated to the database at the collection time
oci_database/StorageAllocated Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1H, PT6H, PT12H, P1D Yes
Saturation Allocated Storage Space By Tablespace (OCI Database)

Total amount of storage space allocated to the tablespace at the collection time. In case of container database, this metric provides root container tablespaces.
oci_database/StorageAllocatedByTablespace Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, tablespaceName, tablespaceType, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Space Used (OCI Database)

Total amount of storage space used by the database at the collection time.
oci_database/StorageUsed Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Space Used By Tablespace (OCI Database)

Total amount of storage space used by tablespace at the collection time. In case of container database, this metric provides root container tablespaces.
oci_database/StorageUsedByTablespace Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, tablespaceName, tablespaceType, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Utilization (OCI Database)

The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.
oci_database/StorageUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Space Utilization By Tablespace (OCI Database)

This indicates the percentage of storage space utilized by the tablespace at the collection time. In case of container database, this metric provides root container tablespaces..
oci_database/StorageUtilizationByTablespace Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, tablespaceName, tablespaceType, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1H, PT6H, PT12H, P1D Yes
Traffic Transaction Count (OCI Database)

The combined number of user commits and user rollbacks during the selected interval.
oci_database/TransactionCount Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1M Yes
Traffic User Calls (OCI Database)

The combined number of logons, parses, and execute calls during the selected interval.
oci_database/UserCalls Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database PT1M Yes
Saturation Allocated Space Utilization By Tablespace

The percentage of space used by tablespace, out of all allocated. For container databases, this metric provides data for root container tablespaces. (Statistic: Mean, Interval: 30 minutes)
oracle_oci_database/AllocatedStorageUtilizationByTablespace Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, tablespaceName, Oracle.resourceType, tablespaceContents PT30M, PT1H, PT6H, PT12H, P1D Yes
Latency Average GC CR Block Receive Time

The average global cache CR (consistent-read) block receive time. For RAC / cluster databases only. (Statistic: Mean, Interval: 5 minutes)
oracle_oci_database/AvgGCCRBlockReceiveTime Milliseconds Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation DB Block Changes (Oracle OCI Database)

The average number of blocks changed per second. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/BlockChanges CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Traffic Blocking Sessions

Current blocking sessions. Not applicable for container databases. (Statistic: Max, Interval: 15 minutes)
oracle_oci_database/BlockingSessions Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation CPU Time

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. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/CPUTime CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation CPU Utilization (Oracle OCI Database)

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. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/CpuUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Traffic Current Logons (Oracle OCI Database)

The number of successful logons during the selected interval. (Statistics: Sum, Interval: 1 minute)
oracle_oci_database/CurrentLogons Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation Job Executions

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," "InProgress." (Statistic: Sum, Interval: 1 minute)
oracle_oci_database/DbmgmtJobExecutionsCount Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, managedDatabaseId, managedDatabaseGroupId, jobId, status PT1M Yes
Saturation DB Time

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. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/DBTime CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Traffic Execute Count (Oracle OCI Database)

The number of user and recursive calls that executed SQL statements during the selected interval. (Statistic: Sum, Interval: 1 minute)
oracle_oci_database/ExecuteCount Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation Flash Recovery Area Limit

The flash recovery area space limit. Not applicable for pluggable databases. (Statistic: Max, Interval: 15 minutes)
oracle_oci_database/FRASpaceLimit Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Flash Recovery Area Utilization

The flash recovery area utilization. Not applicable for pluggable databases. (Statistic: Mean, Interval: 15 minutes)
oracle_oci_database/FRAUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation GC CR Blocks Received

The global cache CR (consistent-read) blocks received per second. For RAC / cluster databases only. (Statistic: Mean, Interval: 5 minutes)
oracle_oci_database/GCCRBlocksReceived CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation GC Current Blocks Received

Represents global cache current blocks received per second. Statistic reports the mean value. For Real Application Cluster (RAC) databases only. (Statistic: Mean, Interval: 5 minutes)
oracle_oci_database/GCCurrentBlocksReceived CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Average Interconnect Traffic

The average internode data transfer rate. For RAC / cluster databases only. (Statistic: Mean, Interval: 5 minutes)
oracle_oci_database/InterconnectTraffic BytesPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Traffic Invalid Objects

Invalid database objects count. Not applicable for container databases. (Statistic: Max, Interval: 24 hours)
oracle_oci_database/InvalidObjects Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, deploymentType P1D Yes
Saturation IOPS

The average number of input-output operations per second. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/IOPS CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, ioType, Oracle.resourceType PT1M Yes
Saturation IO Throughput

The average throughput in MB per second. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/IOThroughput BytesPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, ioType, Oracle.resourceType PT1M Yes
Saturation Logical Reads

The average number of blocks read from SGA/Memory (buffer cache) per second. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/LogicalBlocksRead CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation Max Tablespace Size

The maximum possible tablespace size. For container databases, this metric provides data for root container tablespaces. (Statistic: Max, Interval: 30 minutes)
oracle_oci_database/MaxTablespaceSize Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, tablespaceName, tablespaceContents, Oracle.resourceType PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Memory Usage

Memory pool total size in MB. (Statistic: Mean, Interval: 15 minutes)
oracle_oci_database/MemoryUsage Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, memoryType, memoryPool, Oracle.resourceType PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Error Monitoring Status

The monitoring status of the resource. If a metric collection fails, error information is captured in this metric. (Statistic: Mean, Interval: 5 minutes)
oracle_oci_database/MonitoringStatus Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, collectionName, Oracle.resourceType PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Non Reclaimable Fast Recovery Area

The Non-reclaimable fast recovery area. Not applicable for pluggable databases. (Statistic: Mean, Interval: 15 minutes)
oracle_oci_database/NonReclaimableFRA Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation OCPU Allocated (Oracle OCI Database)

The actual number of OCPUs allocated by the service during the selected interval of time. (Statistic: Count, Interval: 1 minute)
oracle_oci_database/OcpusAllocated Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, deploymentType PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Parse Count (Total)

The number of hard and soft parses during the selected interval. (Statistic: Sum, Interval: 1 minute)
oracle_oci_database/ParseCount Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation Parses By Type

The number of hard or soft parses per second. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/ParsesByType CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, parseType, Oracle.resourceType PT1M Yes
Error Problematic Scheduled DBMS Jobs

The problematic scheduled database jobs count. Not applicable for container databases. (Statistic: Max, Interval: 15 minutes)
oracle_oci_database/ProblematicScheduledDBMSJobs Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, deploymentType, type PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Process Count

The database processes count. Not applicable for pluggable databases. (Statistic: Max, Interval: 1 minute)
oracle_oci_database/Processes Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation Process Limit Utilization

The process limit utilization. Not applicable for pluggable databases. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/ProcessLimitUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation Reclaimable Fast Recovery Area

The reclaimable fast recovery area. Not applicable for pluggable databases. (Statistic: Mean, Interval: 15 minutes)
oracle_oci_database/ReclaimableFRA Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Flash Recovery Area Reclaimable Space

The flash recovery area reclaimable space. Not applicable for pluggable databases. (Statistic: Mean, Interval: 15 minutes)
oracle_oci_database/ReclaimableFRASpace Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Redo Generated

The average amount of redo generated, in MB per second. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/RedoSize BytesPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation Session Limit Utilization

The session limit utilization. Not applicable for pluggable databases. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/SessionLimitUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation Sessions

The number of sessions in the database. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/Sessions Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Saturation Allocated Storage Space

The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces. (Statistic: Max, Interval: 30 minutes)
oracle_oci_database/StorageAllocated Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Allocated Storage Space By Tablespace (Oracle OCI Database)

The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces. (Statistic: Max, Interval: 30 minutes)
oracle_oci_database/StorageAllocatedByTablespace Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, tablespaceName, tablespaceContents, Oracle.resourceType PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Space Used (Oracle OCI Database)

The maximum amount of space used during the interval. (Statistic: Max, Interval: 30 minutes)
oracle_oci_database/StorageUsed Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Space Used By Tablespace (Oracle OCI Database)

The maximum amount of space used by tablespace during the interval. For container databases, this metric provides data for root container tablespaces. (Statistic: Max, Interval: 30 minutes)
oracle_oci_database/StorageUsedByTablespace Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, tablespaceName, tablespaceContents, Oracle.resourceType PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Utilization (Oracle OCI Database)

The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. (Statistic: Mean, Interval: 30 minutes)
oracle_oci_database/StorageUtilization Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Storage Space Utilization By Tablespace (Oracle OCI Database)

The percentage of the space utilized, by tablespace. For container databases, this metric provides data for root container tablespaces. (Statistic: Mean, Interval: 30 minutes)
oracle_oci_database/StorageUtilizationByTablespace Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, tablespaceName, tablespaceContents, Oracle.resourceType PT30M, PT1H, PT6H, PT12H, P1D Yes
Traffic Transaction Count (Oracle OCI Database)

The combined number of user commits and user rollbacks during the selected interval. (Statistic: Sum, Interval: 1 minute)
oracle_oci_database/TransactionCount Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Traffic Transactions By Status

The number of committed or rolled back transactions per second. (Statistic: Mean, Interval: 1 minute)
oracle_oci_database/TransactionsByStatus CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, transactionStatus, Oracle.resourceType PT1M Yes
Saturation Unusable Indexes

Unusable indexes count in database schema. Not applicable for container databases. (Statistic: Max, Interval: 24 hours)
oracle_oci_database/UnusableIndexes Count Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, schemaName P1D Yes
Saturation Usable Fast Recovery Area

The useable fast recovery area. Not applicable for pluggable databases.(Statistic: Mean, Interval: 15 minutes)
oracle_oci_database/UsableFRA Percent Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Saturation Flash Recovery Area Usage

The flash recovery area space usage. Not applicable for pluggable databases. (Statistic: Max, Interval: 15 minutes)
oracle_oci_database/UsedFRASpace Bytes Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceType PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes
Traffic User Calls (Oracle OCI Database)

The combined number of logons, parses, and execute calls during the selected interval. (Statistic: Sum, Interval: 1 minute)
oracle_oci_database/UserCalls Count Minimum, Maximum, Average, Total (Sum) Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceType PT1M Yes
Latency Wait Time

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. (Statistic: Mean, Interval: 5 minutes)
oracle_oci_database/WaitTime CountPerSecond Minimum, Maximum, Average Oracle.resourceId, Oracle.resourceName, deploymentType, instanceNumber, instanceName, hostName, waitClass, Oracle.resourceType PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D Yes

Next steps