Metrics for Oracle Exadata Database Service on Dedicated Infrastructure in the Monitoring Service
This article describes 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 |
|---|---|---|---|---|---|
ASMDiskgroupUtilization |
ASM Diskgroup Utilization | percentage | 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. | 10 minutes |
hostName deploymentType diskgroupName |
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 |
OcpusAllocated |
OCPU Allocated | integer | The number of OCPUs allocated | 1 minute | 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, which is two times the number of OCPUs. | 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 |
Parent topic: Reference Guides for Exadata Cloud Infrastructure