21 Nov
Generating Workload Repository Performance Reports and the Future of Database Tuning
This blog should be a quick and easy read. I will admit that this is a weird combination of topics. We are going to learn how to generate traditional, Statspack-style performance reports from the Automatic Workload Repository. This blog also contains my thoughts on the future of database tuning. And the future does NOT include administrators poring over reams of database statistics to tune Oracle databases.
I absolutely and firmly believe that ADDM and the intelligent advisors are the future of database performance analysis. In my next blog, we let Oracle do all of the tuning work for us when we generate an ADDM task from the same set of beginning and ending snapshot IDs.