Metrics for Oracle Exadata Database Service on Cloud@Customer in the Monitoring Service

Review the metrics emitted by the Oracle Exadata Database Service on Cloud@Customer 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	`deploymentType` `diskgroupName`
`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`
`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` `resourceId_dbnode` `resourceName_dbnode`

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` `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 Cloud@Customer

Oracle Cloud Infrastructure Documentation

Metrics for Oracle Exadata Database Service on Cloud@Customer in the Monitoring Service