View Performance Hub Metrics for Base Database Service Resources

You can use the Performance Hub to monitor database activity, diagnose issues, and tune queries to improve the performance of Oracle Databases. This article describes the procedure to view Performance Hub in Base Database Service.

Performance Hub displays information about the performance of your database for the time period you specify. With this tool, you can view real-time and historical performance data. For more information about Performance Hub, see About Performance Hub.

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

View Performance Hub Metrics for a Database

To view the Performance Hub metrics for a database, the following prerequisite is required.

Perform the following steps to view the Performance Hub for databases.

  1. Open the navigation menu. Select Oracle Database, then select 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 Performance Hub. 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 Performance Hub. Details of the database you selected are displayed.
  5. Click Performance Hub. The Performance Hub for the database are displayed.

View Performance Hub Metrics for a Pluggable Database

To view the Performance Hub metrics for a Pluggable Database , the following prerequisites are required.

  1. The Database Management for databases with Full Management option must be enabled. To enable Database Management for databases, see Enable Database Management for a Database.
  2. The Database Management for Pluggable Databases must be enabled. To enable Database Management for Pluggable Databases, see Enable Database Management for a Pluggable Database.

Perform the following steps to view the Performance Hub for Pluggable Databases.

  1. Open the navigation menu. Select Oracle Database, then select 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 Performance Hub . 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 Performance Hub . 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 Performance Hub . Details of the Pluggable Database you selected are displayed.
  7. Click Performance Hub. The Performance Hub for the Pluggable Database are displayed.