AWR SQL report can be generated by calling the $ORACLE_HOME/rdbms/admin/awrsqrpt.sql file SQL> @$ORACLE_HOME/rdbms/admin/awrsqrptSpecify 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.