Managing Automatic Workload Repository (AWR)

To Generate the AWR report run the following query:
1)
SELECT
   output
FROM  
   TABLE
   (dbms_workload_repository.awr_report_text
      (1226709381,1,15276,15277 )
   );


2)

Save the data into a flat file


Another way to generate the Report

1)
BEGIN
DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();
END;
/

2)
SQL> sqlplus / as sysdba

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

First, you need to specify whether you want an HTML or a text report.

the

Enter value for report_type:

Specify the number of days for which you want to list snapshot Ids.

Enter value for num_days: 1

After the list displays, you are prompted for the beginning and ending snapshot Id for the workload repository report.

Enter value for begin_snap: 95
Enter value for end_snap: 97

Next, accept the default report name or enter a report name. The default name is accepted in the following example:

Enter value for report_name:
Using the report name awrrpt_1_95_97

The workload repository report is generated.