Pages

Saturday, February 20, 2016

Generating different types of AWR Reports

Generating different types of AWR Reports

Generating Automatic Workload Repository Reports

AWR- Automatic Workload Repository report shows the data captured between two point in time (Two snapshots), Here we are discussing about AWR report generation using sqlplus. We have six sql files to generate AWR reports, means in six different way we can generate this report.

Types of AWR sqls

The awrrpt.sql :- Generates an HTML or text report that displays statistics for a range of snapshot Ids.

The awrrpti.sql :- Generates an HTML or text report that displays statistics for a range of snapshot
Ids on a specified database and instance.

The awrsqrpt.sql :- Generates an HTML or text report that displays statistics of a particular SQL statement for a range of snapshot Ids.
Run this report to inspect or debug the performance of a SQL statement.

The awrsqrpi.sql :- Generates an HTML or text report that displays statistics of a particular SQL statement for a range of snapshot Ids on a specified database and instance.
Run this report to inspect or debug the performance of a SQL statement on a specific database and instance

The awrddrpt.sql SQL script generates an HTML or text report that compares
detailed performance attributes and configuration settings between two selected
time periods.

The awrddrpi.sql SQL script generates an HTML or text report that compares
detailed performance attributes and configuration settings between two selected
time periods on a specific database and instance.

Here awrrpt.sql is commonly used and awrddrpt.sql is very much use full when have set baseline snapshots(to compare good and bad time)

To run this report you should have DBA role granted.

No comments:

Post a Comment