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 - Metrics export using data collection rules and 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 |