When you run the awr report with non privileged user i.e custom user (even with dba privilege) you may receive the following error.
@?/rdbms/admin/awrrpt.sql
ORA-13605: The specified task or object does not exist for the current user.Error encountered in special section 99995
The possible cases are,
- missing grant on sys.dbms_advisor
- bug 17588463 -- found reference to where tasks are stored in table WRI$_ADV_TASKS
Our case is resolved when we granted the following privilege.
GRANT ADMINISTER ANY SQL TUNING SET TO <user>;
Update: 16-Feb-2017 (Thanks Vasu)
The issue still reports, but the following patch is permanent fix.
.(Bug 25059420: Schemas with Non-SYSDBA Privileges Get ORA-13605 in AWR Reports)
Patch ## 25105847
Hope this helps
-Thanks
Geek DBA
Follow Me!!!