在甲骨文的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;

（编辑：湖南网）

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