Tuesday, April 15, 2008

run awrrpt

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_1068_1073.html. To use this name,
press to continue, otherwise enter an alternative.

Enter value for report_name: ssonp_awrrpt_0415.html

Using the report name ssonp_awrrpt_0415.html
select output from table(dbms_workload_repository.awr_report_html( :dbid,
*
ERROR at line 1:
ORA-00904: : invalid identifier


Report written to ssonp_awrrpt_0415.html


[SOLUTION]
grant EXECUTE on DBMS_WORKLOAD_REPOSITORY to liqy;