我正在尝试在Oracle 11G中生成AWR报告.在创建时,我收到一些错误消息.错误在下面提到
Using the report name awrrpt_1_2504_2709.html. select output from
table(dbms_workload_repository.awr_report_html( :dbid,
* ERROR at line 1: ORA-00904: : invalid identifier
我用于生成AWR报告的步骤
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
Enter value for report_type: html
Enter value for begin_snap: 2504 Begin Snapshot Id specified: 2504
Enter value for end_snap: 2709 End Snapshot Id specified: 2709
请帮帮我.
解决方法
您用于生成AWR的用户必须不具有DBMS_WORKLOAD_REPOSITORY包的执行权限.
引用Oracle文档,
..To invoke these procedures,a user must be granted the DBA role.
以下是生成AWR所需的GRANTS列表
GRANT SELECT ON SYS.V_$DATABASE TO MY_USER; GRANT SELECT ON SYS.V_$INSTANCE TO MY_USER; GRANT EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY TO MY_USER; GRANT SELECT ON SYS.DBA_HIST_DATABASE_INSTANCE TO MY_USER; GRANT SELECT ON SYS.DBA_HIST_SNAPSHOT TO MY_USER; GRANT ADVISOR TO MY_USER;
