Generating Automatic Workload Repository Reports: Oracle provide following scripts to produce Automatic workload repository reports . They are similar in format to the statspack reports and give the option of HTML or plain text formats. The…
Category: Performance Tuning
Introduction of Automatic Workload Repository (AWR)
Automatic Workload Repository (AWR) in Oracle 11g : Oracle has provided many performance gathering and reporting tools time to time. Before oracle 8i UTLBSTAT / UTLESTAT scripts were used to monitor performance…
Automatic Workload Repository Views
Automatic Workload Repository Views : Historical data (snapshot) stored in AWR can be seen using the following views: Thank you for reading …..This is Airy…Enjoy 🙂