AWR Report Extraction

AWR Report

 AWR:-(Automatic Workload Repository) is a report of statistics of database between varios snapshots.This report is used for investigate Performances and issues.AWR reports can be generated by SQL scripts available on path $ORACLE_HOME/RDBMS/ADMIN/. AWR reports can be extracted in HTML or TXT format

Types of AWR Reports:-

1) awrrpt.sql :-Displays various statistics for a range of snapshots Ids for standalone database.

2) awrrpti.sql:-Displays statistics for a range of snapshot Ids on a specified database Nodes (For RAC).

3) awrsqrpt.sql:-Displays statistics of a particular SQL statement for a range of snapshot Ids for standalone database. This report is use to inspect performance of a particular SQL statement.

4) awrsqrpi.sql:-Displays statistics of a particular SQL statement for a range of snapshot Ids on a specified SQL of a specified database Nodes(For RAC).

5) awrddrpt.sql:-Compares detailed performance attributes and configuration settings between two selected time periods for standalone database.

6) awrddrpi.sql:-Compares detailed performance attributes and configuration settings between two selected time periods on a specific database nodes(For RAC).

AWR Report Extraction Steps :- We can execute awr sql script on SQL prompt . Below are the steps

Note :- Below parameter values need to put 

1) Report Type : Default is HTML
2) Number of Days : Any numeric values for ex. 7 if you want see 7 days reports
3) Value of Begin Snap ID
4) Values of End Snap ID
5) Name of Report

Now report will be available on default path of your command prompt.

You can get the default path by run the "cmd" command on run prompt

Go to the path and see the report and Open in any Browser

After open in browser you will see the report . below is the snap