Question: awr report how to generate?
Answer: At the SQL prompt, enter: @$ORACLE_HOME/rdbms/admin/awrgdrpt.sql. Specify whether you want an HTML or a text report: Enter value for report_type: html. ...  Specify the number of days for which you want to list snapshot IDs in the first time period.