STEPS TO GENERATE AND ANALYSE AWR REPORT

Steps 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)

    EX: From sql> @?/rdbms/admin/awrrpt.sql


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


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


Step 7: Then specify Begin and End snapshot Ids.

Step 8: Here you specify the name of the report or select the default name assigned. (or) select default name "Press enter"

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




Analyse Statistics from report:


step 1: Go to my computer on linux machine

    select and click on file system ==>  click on "home" folder ==> click on "oracle" folder
   
    ==> select and Right click on awrrpt icon .. open with Web Browser