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

Note

In addition to the metrics listed in the following section, Oracle analyzes additional metrics to provide the highest level of service operations and support for ensuring high availability of services.

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` `resourceId_dbnode` `resourceName_dbnode`
`FilesystemUtilization`	Filesystem Utilization	percentage	Percent utilization of provisioned filesystem	1 minute	`hostName` `deploymentType` `filesystemName` `resourceId_dbnode` `resourceName_dbnode`
`LoadAverage`	Load Average	number	System load average over 5 minutes	1 minute	`hostName` `deploymentType` `resourceId_dbnode` `resourceName_dbnode`
`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` `resourceId_dbnode` `resourceName_dbnode`
`NodeStatus`	Node Status	integer	Indicates whether the host is reachable	1 minute	`hostName` `deploymentType` `resourceId_dbnode` `resourceName_dbnode`
`SwapUtilization`	Swap Utilization	percentage	Percent utilization of total swap space	1 minute	`hostName` `deploymentType` `resourceId_dbnode` `resourceName_dbnode`
`EcpusEnabled`	ECPUs Enabled	integer	Number of ECPUs enabled.	1 minute	`deploymentType`
`ExascaleVaultUtilization`	Exascale Vault Utilization	percentage	Percent utilization of vault.	1 minute	`deploymentType` `vaultName`

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` `resourceId_{database\|pdb}` `resourceName_{database\|pdb}`
`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` `resourceId_{database\|pdb}` `resourceName_{database\|pdb}`

Parent topic: Reference Guides for Oracle Exadata Database Service on Exascale Infrastructure

Oracle Cloud Infrastructure Documentation

Metrics for Oracle Exadata Database Service on Exascale Infrastructure in the Monitoring Service