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,