View Metrics for Base Database Service Resources

This article describes the procedures to view metrics for Base Database service using the Console.

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

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the DB system for which you want to view the metrics. Details of the DB system you selected are displayed.
  4. In the Resources section, click Metrics. A chart for each metrics 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 console.

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the DB system that contains the database for which you want to view the metrics. Details of the DB system you selected are displayed.
  4. In the list of databases, click the database for which you want to view the metrics.
  5. In the Resources section, click Metrics. A chart for each metrics 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 console.

  1. Open the navigation menu. Click Observability & Management.
  2. Under Monitoring, click Service Metrics.
  3. On the Service Metrics page, under Compartment, select your compartment.
  4. Select oci_database under Metric namespace.
  5. If there are multiple databases in the compartment you can show metrics aggregated across the databases by selecting Aggregate metric streams.
  6. If you want to limit the metrics you see, next to Dimensions click Add (click Edit if you have already added dimensions).
  7. In the Dimension name, select a dimension.
  8. In the Dimension Value, select a value.
  9. Click Done.
  10. In the Edit dimensions dialog click +Additional dimension to add an additional dimension. Click X to remove a dimension.
  11. To create an alarm on a specific metric, click 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

To view the metrics for a pluggable database , the following prerequisites are additionally required.

Perform the following steps to view the metrics for pluggable databases.

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the DB system that contains the database for which you want to view the metrics. Details of the DB system you selected are displayed.
  4. In the list of databases, click the database for which you want to view the metrics. Details of the database you selected are displayed.
  5. Click Pluggable Databases in the Resources section of the page.
  6. In the list of pluggable databases, click the pluggable database for which you want to view the metrics. Details of the pluggable database you selected are displayed.
  7. Click Metrics in the Resources section of the page. The metrics for the database are displayed.