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.
View Performance Hub Metrics for a Database
Prerequisites
- The Database Management for databases must be enabled. To enable Database Management for databases, see Enable Database Management for a Database.
Procedure
Perform the following steps to view the Performance Hub for databases using the OCI Console:
- From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
- Select your Compartment. A list of DB systems is displayed.
- 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.
- On the DB system details page, select the database that you want to manage. The database details page is displayed.
- Select Performance Hub. The Performance Hub for the database is displayed.
View Performance Hub Metrics for a Pluggable Database
Prerequisites
- 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.
- The Database Management for pluggable databases must be enabled. To enable Database Management for pluggable databases, see Enable Database Management for a Pluggable Database.
Procedure
Perform the following steps to view the performance hub for pluggable databases using the OCI Console:
- From the navigation menu, select Oracle Database, and then select Oracle Base Database Service.
- Select your Compartment. A list of DB systems is displayed.
- 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.
- 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.
- 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.
- Select Performance Hub. The Performance Hub for the pluggable database is displayed.