{ Abhilash Kumar Bhattaram : Follow on LinkedIn }
series : OCI – Database Metrics
As a part of efficient Database monitoring in OCI , Oracle provides built in monitoring capabilities. These are called Metrics which are collected from the various classes of Database Cloud Service.
This Blog will be regarding Basic Management Metrics.
Before we jump into understanding Basic Management metrics , we need to understand what Dimensions are about. Dimensions are properties of a cloud resource. In this case our cloud resource will be an OCI managed database service.
Dimension Description
————————————————————
resourceId The OCID of the database.
resourceName The name of the database.
deploymentType The deployment type of the database.
————————————————————
Understanding Namespaces
There are three types of OCI Database metric namespaces , It took a long time for me to understand what these namespaces stand for. In the end it boils down to “no options if you are not purchashing any management metrics” , “some essential metrics with Basic Management with some charges” and “all the metrics with the Full Management with relvant procing”. They are listed below
oci_database –> For Basic Database Management Metrics
oci_database_cluster –> For Cluster Management Metrics
oracle_oci_database –> For Full Database Management Metrics
NOTE : I am not very clear on how these charges would incur but that’s something I can get from OCI Cloud Calculator.
The official documentation for the OCI Cloud Database metrics is provided here
Basic Management Metrics
As a part of Basic Management the following metrics are available with relevant charts. The Oracle Documentation for the metrics is available here
2 CpuUtilization
3 CurrentLogons
4 ExecuteCount
5 MonitoringStatus
6 OcpusAllocated
7 ParseCount
8 StorageAllocated
9 StorageAllocatedByTablespace
10 StorageUsed
11 StorageUsedByTablespace
All the above metrics need to be configured in OCI Database System as “Basic Database Management” for the DB System and the PDB. Only with these the relevant Metrics , Charts and coresponding Alarms can be configured.
Since these are “Basic Database Management” only essential charts are allowed in metrics. These metrics can be treated as Alarms ( Alarms is not part of this blog and I will try to write about it later )
More on Full Management Metrics on my next series blog.
