My Oracle Support Banner

OCI : Accessing Performance Hub Page Shows "Performance Hub requires granting of appropriate user privileges. After granting the required privileges, reopen Performance Hub" (Doc ID 2940759.1)

Last updated on AUGUST 03, 2024

Applies to:

OCI Database Management Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Database Management Enable operation was done without issues. Trying to click on the Performance Hub gives the following error,

Performance Hub requires granting of appropriate user privileges. After granting the required privileges, reopen Performance Hub.

GRANT CREATE PROCEDURE to <db_monitoring_user>
GRANT SELECT ANY DICTIONARY, SELECT_CATALOG_ROLE to <db_monitoring_user>
GRANT ALTER SYSTEM to <db_monitoring_user>
GRANT ADVISOR to <db_monitoring_user>
GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <db_monitoring_user>

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.