Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AWR generation in Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

tbhluehornOct 10 2016 — edited Nov 5 2017

Good Afternoon,

Please help me view an awr report. This is an 11.2.0.3.0 enterprise database.

I believe these reports are running because I can see snapshots in the dba_hist_snapshot view.

I tried to execute code replacing the DB ID and Snap ID's in the query with the ID's in the database I am working in.  Here is the code that I tried to use from Generating the AWR Report , I don't know if this code will work with a 11.2.0.3.0 database it looks like it was written for 10.1.0.2.0.

SELECT
   output
FROM
   TABLE
   (dbms_workload_repository.awr_report_text
      (37933856,1,2900,2911 )
   );

I need help finding a way to generate a text or html awr report from within SQL developer.

Thank you,

This post has been answered by AndrewSayer on Oct 26 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2016
Added on Oct 10 2016
5 comments
1,257 views