在甲骨文的AWR报告

我正在尝试在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

请帮帮我.

解决方法

引用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;

（编辑：晋中站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!