This discussion is archived
1 Reply Latest reply: May 27, 2011 6:46 AM by orawiss RSS

Privileges for generating AWR report

rahulras Explorer
Currently Being Moderated
Hi All,

If I want the capability of generating AWR report, what privileges do I need?

I do not have access to grid control and enterprise manager. I want to run $ORACLE_HOME/rdbms/admin/awrrpt.sql and generate the (html) report.
I have SELECT_CATALOG_ROLE, bit that is not good enough. I need the capability to execute package DBMS_WORKLOAD_REPOSITORY. Is there a system privilege or role, which gives me this capacity?

If I am not an all powerful DBA, but a developer and need the capability of generating AWR report, what is the best way to achieve this?

Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points