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.
Note: In addition to the following metrics, Oracle analyzes additional metrics to provide the highest level of service operations and support for ensuring high availability of services.
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.
| 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 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.
| 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 metrics are not displayed on the Database Details page. Instead, you can view them using the Monitoring service.