Step To Generate AWR Report

Step 1: Go to $ORACLE_HOME/rdbms/admin

                

Step 2: Run command ls -lrt awr*

                

Step 3: Connect to sqlplus

                 

Step 4:  From the sql prompt run awrrpt (or) awrrpti (for specified instance)

             @awrrpt.sql (if u are in $ORACLE_HOME/rdbms/admin)

             or if You are at any location then

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

Step 5: it will now ask for the report as either ‘HTML’ or ‘TEXT’. (choose one)

             SQL> @awrrpt.sql

            Current Instance

            ~~~~~~~~~~~~~~~~

             DB Id              DB Name      Inst Num    Instance

            -----------            ------------ -------- --------    ----

            2735184012      ABC                1               ABC

            Specify the Report Type

             ~~~~~~~~~~~~~~~~~~~~~~~

           Would you like an HTML report, or a plain text report?

           Enter 'html' for an HTML report, or 'text' for plain text

           Defaults to 'html'

           Enter value for report_type: HTML(I am selecting HTML)

Step 6: Select number of days you want to go back or just hit enter for listing all completed snapshots.

           For Example

          Specify the number of days of snapshots to choose from

          ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

          Entering the number of days (n) will result in the most recent

          (n) days of snapshots being listed.  Pressing <return> without

          specifying a number lists all completed snapshots.

           Enter value for num_days:

          (just Hit enter to get all snapshot details)

Step 7: Then specify Begin and End snapshot Ids.

 

            For E.g

            Specify the Begin and End Snapshot Ids

            ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

            Enter value for begin_snap: 20429

            Begin Snapshot Id specified: 20429

            Enter value for end_snap: 20431

Step 8: Here you specify the name of the report or select the default name assigned.

Step 9: The report gets generated.

Step 10: Exit SQLPLUS.

Step 11: Run command ls –ltr newname to show the new file created under the path you are in