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 |
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 |
Some of the above metrics are not displayed on the Database Details page. Instead, you can view them using the Monitoring service.