Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following table lists the metrics available for the Oracle.Database/dbSystems 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.
For a list of supported logs, see Supported log categories - Oracle.Database/dbSystems
Category: Availability
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Node Status Indicates whether the host is reachable in RAC environments. |
oci_database_cluster/NodeStatus |
Count | Minimum, Maximum, Average | hostName, deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | Yes |
Category: Error
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Monitoring Status The monitoring status of the resource. If metric collection fails, error information is captured in this metric. (Statistic: Mean, Interval: 5 minutes) |
oracle_oci_database/MonitoringStatus |
Count | Minimum, Maximum, Average | collectionName, deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType, errorCode, errorSeverity |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
Category: Latency
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| 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 | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType, waitClass |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
Category: Saturation
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| CPU Utilization (OCI Database Cluster) Percent CPU utilization. |
oci_database_cluster/CpuUtilization |
Percent | Minimum, Maximum, Average | hostName, deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | Yes |
| Filesystem Utilization Percent utilization of provisioned filesystem. |
oci_database_cluster/FilesystemUtilization |
Percent | Minimum, Maximum, Average | hostName, deploymentType, filesystemName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | Yes |
| Load Average System load average over 5 minutes. |
oci_database_cluster/LoadAverage |
Count | Minimum, Maximum, Average | hostName, deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | Yes |
| 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 | hostName, deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | Yes |
| OCPU Allocated (OCI Database Cluster) The number of OCPUs allocated. |
oci_database_cluster/OcpusAllocated |
Count | Minimum, Maximum, Average | deploymentType, Oracle.resourceId, Oracle.resourceName |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Swap Utilization Percent utilization of total swap space. |
oci_database_cluster/SwapUtilization |
Percent | Minimum, Maximum, Average | hostName, deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | Yes |
| DB Block Changes (OCI Database) The Average number of blocks changed per second. |
oci_database/BlockChanges |
CountPerSecond | Minimum, Maximum, Average | instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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 | instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Parse Count The number of hard and soft parses during the selected interval. |
oci_database/ParseCount |
Count | Minimum, Maximum, Average, Total (Sum) | instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Storage Space Allocated Total amount of storage space allocated to the database at the collection time. |
oci_database/StorageAllocated |
Bytes | Minimum, Maximum, Average | deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT1H, PT6H, PT12H, P1D | Yes |
| 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 | tablespaceName, tablespaceType, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT1H, PT6H, PT12H, P1D | Yes |
| 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 | deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT1H, PT6H, PT12H, P1D | Yes |
| 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 | tablespaceName, tablespaceType, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT1H, PT6H, PT12H, P1D | Yes |
| 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 | deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT1H, PT6H, PT12H, P1D | Yes |
| 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 | tablespaceName, tablespaceType, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT1H, PT6H, PT12H, P1D | Yes |
| 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 | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| CPU Count The number of CPUs during the selected interval |
oracle_oci_database/CpuCount |
Count | Minimum, Maximum, Average, Total (Sum) | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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 | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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 | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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 | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Flash Recovery Area Limit The flash recovery area space limit. (Statistic: Max, Interval: 15 minutes) Not applicable for PDBs. |
oracle_oci_database/FRASpaceLimit |
Bytes | Minimum, Maximum, Average | deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Flash Recovery Area Utilization The flash recovery area utilization. (Statistic: Mean, Interval: 15 minutes) Not applicable for PDBs. |
oracle_oci_database/FRAUtilization |
Percent | Minimum, Maximum, Average | deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| IOPS The average number of IO operations per second. (Statistic: Mean, Interval: 1 minute) |
oracle_oci_database/IOPS |
CountPerSecond | Minimum, Maximum, Average | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType, ioType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| IO Throughput The average throughput in MB per second. (Statistic: Mean, Interval: 1 minute) |
oracle_oci_database/IOThroughput |
BytesPerSecond | Minimum, Maximum, Average | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType, ioType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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 | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Memory Usage The total size of the memory pool. (Statistic: Mean, Interval: 15 minutes) |
oracle_oci_database/MemoryUsage |
Bytes | Minimum, Maximum, Average | instanceNumber, instanceName, hostName, memoryType, memoryPool, deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Non Reclaimable Fast Recovery Area The non-reclaimable fast recovery area. (Statistic: Mean, Interval: 15 minutes) Not applicable for PDBs. |
oracle_oci_database/NonReclaimableFRA |
Percent | Minimum, Maximum, Average | deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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, Total (Sum) | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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 | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType, parseType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Process Count The number of database processes. (Statistic: Max, Interval: 1 minute) Not applicable for PDBs. |
oracle_oci_database/Processes |
Count | Minimum, Maximum, Average | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Process Limit Utilization The process limit utilization. (Statistic: Mean, Interval: 1 minute) Not applicable for PDBs. |
oracle_oci_database/ProcessLimitUtilization |
Percent | Minimum, Maximum, Average | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Reclaimable Fast Recovery Area The reclaimable fast recovery area. (Statistic: Mean, Interval: 15 minutes) Not applicable for PDBs. |
oracle_oci_database/ReclaimableFRA |
Percent | Minimum, Maximum, Average | deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Flash Recovery Area Reclaimable Space The flash recovery area reclaimable space. (Statistic: Mean, Interval: 15 minutes) Not applicable for PDBs. |
oracle_oci_database/ReclaimableFRASpace |
Bytes | Minimum, Maximum, Average | deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Redo Generation Rate The redo generation rate on the primary database. (Statistic: Mean, Interval: 5 minutes, Resource group: oracle_dataguard) Not applicable for PDBs. |
oracle_oci_database/RedoGenerationRate |
BytesPerSecond | Minimum, Maximum, Average | deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Redo Generated The average amount of redo generated. (Statistic: Mean, Interval: 1 minute) |
oracle_oci_database/RedoSize |
BytesPerSecond | Minimum, Maximum, Average | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Session Limit Utilization The session limit utilization. (Statistic: Mean, Interval: 1 minute) Not applicable for PDBs. |
oracle_oci_database/SessionLimitUtilization |
Percent | Minimum, Maximum, Average | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Sessions The number of sessions in the database. (Statistic: Mean, Interval: 1 minute) |
oracle_oci_database/Sessions |
Count | Minimum, Maximum, Average | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Usable Fast Recovery Area The usable fast recovery area. (Statistic: Mean, Interval: 15 minutes) Not applicable for PDBs. |
oracle_oci_database/UsableFRA |
Percent | Minimum, Maximum, Average | deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Flash Recovery Area Usage The flash recovery area space usage. (Statistic: Max, Interval: 15 minutes) Not applicable for PDBs. |
oracle_oci_database/UsedFRASpace |
Bytes | Minimum, Maximum, Average | deploymentType, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
Category: Traffic
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Current Logons (OCI Database) The number of successful logons during the selected interval. |
oci_database/CurrentLogons |
Count | Minimum, Maximum, Average, Total (Sum) | instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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) | instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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) | instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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) | instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database, Oracle.resourceId, Oracle.resourceName |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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) | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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) | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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) | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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 | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType, transactionStatus |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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) | deploymentType, instanceNumber, instanceName, hostName, Oracle.resourceId, Oracle.resourceName, Oracle.resourceType |
PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |