Metrics for Oracle Exadata Database Service on Exascale Infrastructure in the Monitoring Service
learn about the metrics emitted by the Exadata Cloud Infrastructure Database service in the oci_database_cluster and oci_database namespaces for Oracle Databases.
Dimensions
All the metrics discussed in this topic include the following dimensions.
- RESOURCEID - The OCID of the VM Cluster.
- RESOURCENAME - The name of the VM Cluster.
The metrics listed in the following table are automatically available for the VM cluster.
| Metric Name | Metric Display Name | Unit | Description and Metric Chart Defaults | Collection Frequency | Dimensions |
|---|---|---|---|---|---|
CpuUtilization |
CPU Utilization | percentage | Percent CPU utilization | 1 minute |
hostName deploymentType |
FilesystemUtilization |
Filesystem Utilization | percentage | Percent utilization of provisioned filesystem | 1 minute |
hostName deploymentType filesystemName |
LoadAverage |
Load Average | integer | System load average over 5 minutes | 1 minute |
hostName deploymentType |
MemoryUtilization |
Memory Utilization | percentage | Percentage of memory available for starting new
applications, without swapping. The available memory can be obtained
via the following command: cat
/proc/meminfo |
1 minute |
hostName deploymentType |
NodeStatus |
Node Status | integer | Indicates whether the host is reachable. | 1 minute |
hostName deploymentType |
SwapUtilization |
Swap Utilization | percentage | Percent utilization of total swap space | 1 minute |
hostName deploymentType |
The metrics listed in the following table are automatically available for the database.
| Metric Name | Metric Display Name | Unit | Dsicription and Metric Chart Defaults | Collection Frequency | Dimensions |
|---|---|---|---|---|---|
CpuUtilization |
CPU Utilization | percentage | 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. | 5 minutes |
instanceNumber instanceName hostName deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
StorageUtilization |
Storage Utilization | percentage | The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. | 1 hour |
deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
BlockChanges |
DB Block Changes | Changes per second | The Average number of blocks changed per second. | 5 minutes |
instanceNumber instanceName hostName deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
ExecuteCount |
Execute Count | Count | The number of user and recursive calls that executed SQL statements during the selected interval. | 5 minutes |
instanceNumber instanceName hostName deploymentType |
ExecuteCount |
Execute Count | Count | The number of user and recursive calls that executed SQL statements during the selected interval. | 5 minutes |
instanceNumber instanceName hostName deploymentType |
CurrentLogons |
Current Logons | Count | The number of successful logons during the selected interval. | 5 minutes |
instanceNumber instanceName hostName deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
TransactionCount |
Transaction Count | Count | The combined number of user commits and user rollbacks during the selected interval. | 5 minutes |
instanceNumber instanceName hostName deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
UserCalls |
User Calls | Count | The combined number of logons, parses, and execute calls during the selected interval. | 5 minutes |
instanceNumber instanceName hostName deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
ParseCount |
Parse Count | Count | The number of hard and soft parses during the selected interval. | 5 minutes |
instanceNumber instanceName hostName deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
StorageUsed |
Storage Space Used | GB | Total amount of storage space used by the database at the collection time. | 1 hour |
deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
StorageAllocated |
Storage Space Allocated | GB | Total amount of storage space allocated to the database at the collection time | 1 hour |
deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
StorageUsedByTablespace |
Storage Space Used By Tablespace | GB | Total amount of storage space used by tablespace at the collection time. In case of container database, this metric provides root container tablespaces. | 1 hour |
tablespaceName, tablespaceType deploymentType resourceId_{database|pdb} resourceName_{database|pdb} |
| StorageAllocatedByTablespace | Allocated Storage Space By Tablespace | GB | Total amount of storage space allocated to the tablespace at the collection time. In case of container database, this metric provides root container tablespaces. | 1 hour |
TablespaceName, tablespaceType, deploymentType, resourceId_{database|pdb} resourceName_{database|pdb} |
StorageUtilizationByTablespace |
Storage Space Utilization By Tablespace | percentage | 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.. | 1 hour |
tablespaceName, tablespaceType deploymentType |