How to Create AWR Report in Oracle 10g?

he remaining procedures in the dbms_workload_repository package are awr_report_text and awr_report_html, which generate the AWR report for the specified snapshot range in text or HTML formats, respectively.  The following script segment shows how to retrieve the AWR text report for any snapshot range or duration:

SELECT

   output 

FROM    TABLE(dbms_workload_repository.awr_report_text (45634523,1,5600,5612 ));

The sample output below shows the typical report generated for AWR data.  The output displays shows the four arguments to the awr_report_text stored procedure:

§       The database ID is 37933856.

§       The instance number for RAC is 1.

§       The starting snapshot number is5600

§       The ending snapshot number is5612