View Metrics for Base Database Service Resources

This article provides the details and procedure to view metrics for the Base Database Service resources.

The following topics are covered in this article:

Required IAM Policy

To use Oracle Cloud Infrastructure, you must be granted security access in a policy by an administrator. This access is required whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you get a message that you don’t have permission or are unauthorized, verify with your administrator what type of access you have and which compartment to work in.

For administrators: The policy in Let database admins manage Oracle Cloud database systems lets the specified group do everything with databases and related Database resources.

If you're new to policies, see Getting Started with Policies and Common Policies. If you want to dig deeper into writing policies for databases, see Details for the Database Service.

Related Topics

General Information

The following are some general information for viewing the metrics:

  • By default, the metrics for the last one hour are displayed.
  • By default, the metrics from the oci_database namespace are displayed. If Database Management is enabled, then the metrics from oracle_oci_database are displayed. To enable Database Management for databases, see Enable Database Management for a Database.
  • When there is a network problem and Oracle Trace File Analyzer (TFA) is unable to post metrics, TFA will wait for one hour before attempting to retry posting the metrics. This is required to avoid creating a backlog of metrics processing on TFA.
  • Potentially one hour of metrics will be lost between network restore and the first metric posted.
  • If you don't see any metrics, check the network settings and AHF version listed in the prerequisites section.

Note:

Known Issue: When the DB System is deployed using the Logical Volume Manager storage management software, there may be missing metric collections, resulting in graphs with missing data points.

Prerequisites for Viewing Metrics

The following prerequisites are necessary for the DB system to generate metrics.

  1. Metrics on the DB system depends on TFA agent. Ensure that these components are up and running. AHF version 22.3.3 or higher is required for capturing metrics from the DB system. To start, stop, or check the status of TFA, see Manage Oracle Trace File Analyzer.
  2. The following network configurations are required.
    1. Egress rules for outgoing traffic: The default egress rules are sufficient to enable the required network path: For more information, see Default Security Lists in Security Lists. If you have blocked the outgoing traffic by modifying the default egress rules on your Virtual Cloud Network (VCN), you will need to revert the settings to allow outgoing traffic. The default egress rule allowing outgoing traffic (as shown in the Security Rules for the DB System article) is as follows:
      • Stateless: No (all rules must be stateful)
      • Destination Type: CIDR
      • Destination CIDR: All <region> Services in Oracle Services Network

      • IP Protocol: TCP

      • Destination Port: 443 (HTTPS)

    2. Public IP or Service Gateway: The database server host must have either a public IP address or a service gateway to be able to send database server host metrics to the Monitoring service.

      If the instance does not have a public IP address, set up a service gateway on the VCN. The service gateway lets the instance send database server host metrics to the Monitoring service without the traffic going over the internet. Here are special notes for setting up the service gateway to access the Monitoring service:
      1. When creating the service gateway, enable the service label called All <region> Services in Oracle Services Network. It includes the Monitoring service.
      2. When setting up routing for the subnet that contains the instance, set up a route rule with Target Type set to Service Gateway, and the Destination Service set to All <region> Services in Oracle Services Network.

      For detailed instructions, see Access to Oracle Services: Service Gateway.

View Metrics for a DB System

Perform the following steps to view the metrics for a DB system using the OCI Console:

  1. From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
  2. Select your Compartment. A list of DB systems is displayed.
  3. On the DB systems list page, select the DB system that you want to manage. The DB system details page is displayed.
  4. On the DB system details page, under Resources, select Metrics. A chart for each metric is displayed.
  5. By default, the metrics for the last one hour are displayed.
  6. If you want to change the interval, select the required start time and end time. Alternatively, you can select the interval from the Quick Selects drop-down menu. The metrics are refreshed immediately for the selected interval.
  7. For each metric, you can choose the interval and statistic independently.
    • Interval: The time period for which the metric is calculated.
    • Statistic: The mathematical method for which the metric is calculated.
  8. For each metric, you can choose the following options from the Options drop-down menu:
    • View query in Metrics Explorer
    • Copy chart URL
    • Copy query (MQL)
    • Create an alarm on this query
    • Table view

Note:

If you don't see any metrics, check the network settings and AHF version listed in the prerequisites section.

View Metrics for a Database

Perform the following steps to view the metrics for a database using the OCI Console:

  1. From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
  2. Select your Compartment. A list of DB systems is displayed.
  3. On the DB systems list page, select the DB system that contains the database that you want to manage. The DB system details page is displayed.
  4. On the DB system details page, select the database that you want to manage. The database details page is displayed.
  5. On the database details page, under Resources, select Metrics. A chart for each metric is displayed.
  6. Choose the metrics you want to view using the Metric namespace dropdown.

    Note:

    By default, the metrics from the oci_database namespace are displayed. If Database Management is enabled, then the metrics from oracle_oci_database are displayed. To enable Database Management for databases, see Enable Database Management for a Database.
  7. If you want to change the interval, select the required start time and end time. Alternatively, you can select the interval from the Quick Selects drop-down menu. The metrics are refreshed immediately for the selected interval.
  8. For each metric, you can choose the interval and statistic independently.
    • Interval: The time period for which the metric is calculated.
    • Statistic: The mathematical method for which the metric is calculated.
  9. For each metric, you can choose the following options from the Options drop-down menu:
    • View query in Metrics Explorer
    • Copy chart URL
    • Copy query (MQL)
    • Create an alarm on this query
    • Table view

Note:

If you don't see any metrics, check the network settings and AHF version listed in the prerequisites section.

View Metrics for a Database in a Compartment

Perform the following steps to view the metrics for databases in a compartment using the OCI Console:

  1. From the navigation menu, select Observability & Management, and then select Service Metrics under Monitoring.
  2. On the Service Metrics page, under Compartment, select your compartment.
  3. Select oci_database under the Metric namespace.
  4. If there are multiple databases in the compartment, you can show metrics aggregated across the databases by selecting Aggregate metric streams.
  5. If you want to limit the metrics you see, next to Dimensions select Add (select Edit if you have already added dimensions).
  6. In the Dimension name, select a dimension.
  7. In the Dimension Value, select a value.
  8. Select Done.
  9. In the Edit dimensions dialog, select +Additional dimension to add an additional dimension.
    • If not required, select X to remove a dimension.
  10. To create an alarm on a specific metric, select Options and select Create an alarm on this query. See Managing Alarms for information on setting and using alarms.

Note:

If you don't see any metrics, check the network settings and AHF version listed in the prerequisites section.

View Metrics for a Pluggable Database

Prerequisites

Procedure

Perform the following steps to view the metrics for pluggable databases using the OCI Console:

  1. From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
  2. Select your Compartment. A list of DB systems is displayed.
  3. On the DB systems list page, select the DB system that contains the pluggable database that you want to manage. The DB system details page is displayed.
  4. On the DB system details page, select the database that contains the pluggable database that you want to manage. The database details page is displayed.
  5. On the database details page, under Resources, select Pluggable Databases, and then select the pluggable database that you want to manage. The pluggable database details page is displayed.
  6. On the pluggable database details page, under Resources, select Metrics. The metrics for the database are displayed.