OCI - Database Cloud Metrics - #1 Basic Management Metrics
Tags: oci, database, metrics, monitoring
Published: 2024-04-21 10:21:18


[](
      <style>
        .libutton {
          display: flex;
          flex-direction: column;
          justify-content: center;
          padding: 7px;
          text-align: center;
          outline: none;
          text-decoration: none !important;
          color: #ffffff !important;
          width: 200px;
          height: 32px;
          border-radius: 16px;
          background-color: #0A66C2;
          font-family: "SF Pro Text", Helvetica, sans-serif;
        { Abhilash Kumar Bhattaram : </style> <a class="libutton" href="https://www.linkedin.com/comm/mynetwork/discovery-see-all?usecase=PEOPLE_FOLLOWS&followMember=abhilash-kumar-85b92918" target="_blank">Follow on LinkedIn</a>) }

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


1. oci_database --> For Basic Database Management Metrics
2. oci_database_cluster --> For Cluster Management Metrics
3. 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](https://docs.oracle.com/en-us/iaas/database-management/doc/oracle-cloud-database-metrics.html)


## 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](https://docs.oracle.com/en-us/iaas/database-management/doc/oracle-cloud-database-metrics.html) 

```
1  BlockChanges						
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.