The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views.
Features of AWR:
@?/rdbms/admin/awrrpt.sql --> Generates an HTML or text report that displays statistics for a range of snapshot Ids.
@?/rdbms/admin/awrrpti.sql --> Generates an HTML or text report that displays statistics for a range of snapshot
Ids on a specified database and instance.
@?/rdbms/admin/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.
@?/rdbms/admin/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
@?/rdbms/admin/awrddrpt.sql SQL script generates an HTML or text report that compares detailed performance attributes and
configuration settings between two selected time periods.
@?/rdbms/admin/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.
In order to run this reports you should have DBA role granted and you need to choose the snap id's interval based on your issue time.
Features of AWR:
- Some of the system and session statistics collected from V$SYSSTAT and V$SESSTAT views
- Object statistics that determine both access and usage statistics of DB segments.
- ASH statistics.
- Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views
- SQL statements that are producing the highest load on the system, based on elapsed time and CPU time.
@?/rdbms/admin/awrrpt.sql --> Generates an HTML or text report that displays statistics for a range of snapshot Ids.
@?/rdbms/admin/awrrpti.sql --> Generates an HTML or text report that displays statistics for a range of snapshot
Ids on a specified database and instance.
@?/rdbms/admin/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.
@?/rdbms/admin/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
@?/rdbms/admin/awrddrpt.sql SQL script generates an HTML or text report that compares detailed performance attributes and
configuration settings between two selected time periods.
@?/rdbms/admin/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.
In order to run this reports you should have DBA role granted and you need to choose the snap id's interval based on your issue time.
awrrpt.sql is the most key common report and that is very helpful when you start investigating your journey on performance issues.
No comments:
Post a Comment