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