DBC:Errors/DBC-E040

[DBC-E040] <sid>: [%s] Cannot execute AWR generation procedure [ORA-???:<message>]

Creating AWR reports failed with the given Oracle message. More debug info should be in the dbcollect.log file. The most likely cause is not having EXECUTE privileges on the DBMS_WORKLOAD_REPOSITORY procedures.

Solution: GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <user>

Page