AWR report in oracle -

AWR report in oracle -

i trying generate awr study in oracle 11g. @ creation time, getting error message. error mentioned below

using study name awrrpt_1_2504_2709.html. select output table(dbms_workload_repository.awr_report_html( :dbid, * error @ line 1: ora-00904: : invalid identifier

steps using generate awr reports

@$oracle_home/rdbms/admin/awrrpt.sql

enter value report_type: html

enter value begin_snap: 2504 begin snapshot id specified: 2504

enter value end_snap: 2709 end snapshot id specified: 2709

please help me on this.

the user, you're using generate awr must not having execute privileges on dbms_workload_repository package.

to quote oracle documentation,

..to invoke these procedures, user must granted dba role.

here list of grants need generate awr

grant select on sys.v_$database my_user; grant select on sys.v_$instance my_user; grant execute on sys.dbms_workload_repository my_user; grant select on sys.dba_hist_database_instance my_user; grant select on sys.dba_hist_snapshot my_user; grant advisor my_user;

oracle