With Performance Hub, you can monitor your databases for defined time periods and download statistical reports.

What is Performance Hub?

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.

Performance Hub supports:

• Autonomous AI Database on shared and dedicated Exadata infrastructure

• Databases running on Base Database Service and Exadata Database Service on Dedicated Infrastructure systems

• Databases managed with OCI's External Database

How Performance Hub Works

For Autonomous AI Database, you can access the Performance Hub feature from the Autonomous AI Database Details page.

To use Performance Hub for databases running on Base Database Service, Exadata Cloud Service, or databases managed with the External Database Service:

• Enable Database Management

While enabling Database Management for Base Database Service or Exadata Cloud service, the database administrator can select from two options, Basic Management or Full Management. For more information, see Enable Database Management.

To use advanced features of Autonomous AI Database with Performance Hub:

• Enable Database Management.

  If Database Management is already enabled, configure the connection for advanced features of Autonomous AI Database.

• Configure an admin user for Performance Hub.

Note

If you enable Database Management for Autonomous AI Database, you can access Performance Hub from the Database Management service also.

In Database Management, you can set preferred credentials for users so they can automatically connect to the Managed Database and use Performance Hub.

For information about preferred credentials in Database Management, see Set Preferred Credentials.

Note

Using Oracle Identity Cloud Service (IAM), you can create a policy that grants users access to Performance Hub while limiting actions they can take on the Oracle Database being analyzed. For more information, about policies and how to use them, see How Policies Work.

The following example shows a policy that grants access only to performance data without allowing general use access on Autonomous AI Databases.

Allow group <groupname> 
   to inspect autonomous-database-family in compartment <name> 
Allow group <groupname> 
   to use autonomous-database-family in compartment <name> 
   where request.operation = 'RetrieveAutonomousDatabasePerformanceBulkData'