Thursday, January 19, 2017

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

No comments:

Post a Comment