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/exadbVmClusters 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.
- Advanced platform metrics - A premium, paid tier of platform metrics in Azure Monitor that provide more granular observability for Azure resources.
- 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,
PT1Mindicates that the metric is sampled every minute,PT30Mevery 30 minutes,PT1Hevery hour, and so on. - DS Export -S 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.
For a list of supported logs, see Supported log categories - Oracle.Database/exadbVmClusters
Category: Availability
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Node Status Indicates whether the host is reachable. |
oci_database_cluster_NodeStatus |
No | Count | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | No |
Category: Saturation
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| DB Block Changes The Average number of blocks changed per second. |
oci_database_BlockChanges |
No | CountPerSecond | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1M | No |
| CPU Utilization (OCI Database Cluster) Percent CPU utilization |
oci_database_cluster_CpuUtilization |
No | Percent | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | No |
| Filesystem Utilization Percent utilization of provisioned filesystem |
oci_database_cluster_FilesystemUtilization |
No | Percent | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode, filesystemName |
PT1M | No |
| Load Average System load average over 5 minutes |
oci_database_cluster_LoadAverage |
No | Count | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | No |
| 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 |
No | Percent | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | No |
| OCPU Allocated The number of OCPUs allocated |
oci_database_cluster_OcpusAllocated |
No | Count | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, deploymentType |
PT1M | No |
| Swap Utilization Percent utilization of total swap space |
oci_database_cluster_SwapUtilization |
No | Percent | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, hostName, deploymentType, Oracle.resourceId_dbnode, Oracle.resourceName_dbnode |
PT1M | No |
| 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. |
oci_database_CpuUtilization |
No | Percent | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1M | No |
| Parse Count The number of hard and soft parses during the selected interval. |
oci_database_ParseCount |
No | Count | Minimum, Maximum, Average, Total (Sum) | Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1M | No |
| Storage Space Allocated Total amount of storage space allocated to the database at the collection time |
oci_database_StorageAllocated |
No | Bytes | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1H, PT6H, PT12H, P1D | No |
| Allocated Storage Space By Tablespace 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 |
No | Bytes | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, TablespaceName, tablespaceType, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1H, PT6H, PT12H, P1D | No |
| Storage Space Used Total amount of storage space used by the database at the collection time. |
oci_database_StorageUsed |
No | Bytes | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1H, PT6H, PT12H, P1D | No |
| Storage Space Used By Tablespace 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 |
No | Bytes | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, tablespaceName, tablespaceType, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1H, PT6H, PT12H, P1D | No |
| Storage Utilization The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. |
oci_database_StorageUtilization |
No | Percent | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1H, PT6H, PT12H, P1D | No |
| Storage Space Utilization By Tablespace 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 |
No | Percent | Minimum, Maximum, Average | Oracle.resourceId, Oracle.resourceName, tablespaceName, tablespaceType, deploymentType |
PT1H, PT6H, PT12H, P1D | No |
Category: Traffic
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Current Logons The number of successful logons during the selected interval. |
oci_database_CurrentLogons |
No | Count | Minimum, Maximum, Average, Total (Sum) | Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1M | No |
| Execute Count The number of user and recursive calls that executed SQL statements during the selected interval. |
oci_database_ExecuteCount |
No | Count | Minimum, Maximum, Average, Total (Sum) | Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType |
PT1M | No |
| Transaction Count The combined number of user commits and user rollbacks during the selected interval. |
oci_database_TransactionCount |
No | Count | Minimum, Maximum, Average, Total (Sum) | Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1M | No |
| User Calls The combined number of logons, parses, and execute calls during the selected interval. |
oci_database_UserCalls |
No | Count | Minimum, Maximum, Average, Total (Sum) | Oracle.resourceId, Oracle.resourceName, instanceNumber, instanceName, hostName, deploymentType, Oracle.resourceId_database, Oracle.resourceName_database |
PT1M | No |