AWR Report In Oracle

sqlplus / as sysdba

SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

Specify the Report Type AWR reports can be generated in the following formats. Please enter the name of the format at the prompt. Default value is 'html'.

'html' HTML format (default) 'text' Text format 'active-html' Includes Performance Hub active report

Enter value for report_type: html

Enter value for num_days: 1

Specify the Begin and End Snapshot Ids
Enter value for begin_snap: 880
Begin Snapshot Id specified: 880

Specify the Report Name press <return> to continue, otherwise enter an alternative.

Enter value for report_name: AWR_report.html

Report written to AWR_report.html