awrrpt.sql -- Displays statistics for a range of snapshot Ids.
awrrpti.sql -- Displays statistics for a range of snapshot Ids on a specified database and instance.
awrsqrpt.sql -- Displays statistics of a particular SQL statement for a range of snapshot Ids. Run this report to investigate the performance of a SQL statement.
awrsqrpi.sql -- Displays statistics of a particular SQL statement for a range of snapshot Ids on a specified database and instance. Run this to investigate performance of a SQL statement on a specific database and instance.
awrddrpt.sql -- Compares detailed performance attributes and configuration settings between two selected time periods.
awrddrpi.sql --Compares detailed performance attributes and configuration settings between two selected time periods on a specific database and instance.
awrsqrpt.sql -- SQL performance report
No comments:
Post a Comment