Accessing Oracle Database Monitoring Metrics

You can access the Oracle Database monitoring metrics through Prometheus dashboard and visualize the metrics through Grafana dashboard.

This topic contains the following sections:

Prometheus Dashboard

You can access the Prometheus dashboard either through the load balancer URL or a node port, depending on the ingress service type. The Prometheus dashboard URL is available in the urls section of the Siebel CRM deployment API response and in the GET response of the environment API. You can use the URL ending with /Prometheus to access the Prometheus dashboard. All metrics prefixed with oracledb_ represent the Oracle Database monitoring metrics in the Prometheus dashboard.

Sample Grafana Dashboard

You can download and access the sample Grafana dashboard through the API GET request as follows:

  • Oracle Database dashboard:
    GET https://<SCM_instance_IP>:<port_num>/scm/api/v1.0/environment/{env_id}/observability/download/Oracle-Database-Dashboard.json
  • Order Management dashboard for the telecommunications industry:
    GET https://<SCM_instance_IP>:<port_num>/scm/api/v1.0/environment/{env_id}/observability/download/Oracle-Order-Management-Database-Dashboard.json