Available Metrics for Base Database Service Resources

This article describes the metrics emitted by the Base Database service in the oci_database_cluster and oci_database namespaces.

Dimensions

All the metrics discussed in this article include the following dimensions.

  • RESOURCEID - The OCID of the DB system.
  • RESOURCENAME - The name of the DB system.

Metrics for the DB System in the oci_database_cluster Namespace

The metrics listed in the following table are automatically available for the DB system.

Table 5-1 Metrics in oci_database_cluster Namespace

Metric Name Metric Display Name Unit Description and Metric Chart Defaults Collection Frequency Dimensions Whether Visible in the DB System Details page
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

Yes
FilesystemUtilization Filesystem Utilization percentage Percent utilization of provisioned filesystem. 1 minute

hostName

deploymentType

filesystemName

No
CpuUtilization CPU Utilization percentage Percent CPU utilization. 1 minute

hostName

deploymentType

Yes
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

Yes
SwapUtilization Swap Utilization percentage Percent utilization of total swap space. 1 minute

hostName

deploymentType

Yes
LoadAverage Load Average integer System load average over 5 minutes. 1 minute

hostName

deploymentType

Yes
NodeStatus Node Status integer Indicates whether the host is reachable in RAC environments. 1 minute

hostName

deploymentType

Yes
OcpusAllocated OCPU Allocated integer The number of OCPUs allocated. 1 minute deploymentType No
Note

Some of the above metrics are not displayed on the DB System Details page. Instead, you can view them using the Monitoring service.

Metrics for the Database in the oci_database Namespace

The metrics listed in the following table are automatically available for the database.

Table 5-2 Metrics in oci_database Namespace

Metric Name Metric Display Name Unit Description and Metric Chart Defaults Collection Frequency Dimensions Whether Visible in the DB System Details page
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}

Yes
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}

Yes
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}

Yes
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

Yes
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}

Yes
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}

No
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}

No
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}

Yes
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}

No
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}

No
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}

No
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}

No
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

No
Note

Some of the above metrics are not displayed on the Database Details page. Instead, you can view them using the Monitoring service.