version 3.2.20.09 Build MAIN-09.87
Under Reports when Clicking on Last AWR Report and ASH Report for the Past 30 Minutes
An error was encountered performing the requested opertation
PL/SQL ORA-00904: invalid identifier
ORA-06550: line 9 column 13
and further down loop index variable RC use is invalid
*Cause Usually a PL/SQL compilation error
vendor code 6550
Edited by: amin_adatia on Apr 12, 2013 4:59 AM
This is just a matter of the privileges you have. The Last AWR Report works for me as SYS or SYSTEM but not, for example, as HR.
See these posts from the Database -> General Questions forum: Privileges for generating AWR report AWR REPORT
SQL Developer Team
No time to research this thoroughly just now, but you do not need the DBA role. If you don't wish to follow the guidelines in the other links, or if they don't apply to your DB version, then probably, at a minimum, something quick and dirty like...
grant select any dictionary to <myuser>;
grant execute on dbms_workload_repository to <myuser>;
should do the trick. Also I saw a mention of
grant advisor to <myuser>;
so that may be required for certain bits of the report -- not sure.