2.07.2010

How to Generating AWR report from sql

AWR SQL report can be generated by calling the $ORACLE_HOME/rdbms/admin/awrsqrpt.sql file

SQL> @$ORACLE_HOME/rdbms/admin/awrsqrpt

Specify the Report Type …

Would you like an HTML report, or a plain text report?

select html or plain text and you can use Oracle AWR report.