28 Nov
The Future of Database Tuning - Using ADDM Tasks and Intelligent Advisors to Solve Database Performance Problems
Now that we have learned how to create Statspack-Style performance reports from Automatic Workload Repository snapshots, let’s run an ADDM task and an intelligent advisor or two and let 10G Grid Control do the diagnostic grunt work for us. As I ranted in my previous blog, ADDM and the intelligent advisors are the future of database performance analysis. The era of relying totally on DBA experience and expertise to tune Oracle is rapidly drawing to a close.
We’ll create a not-so mythical performance problem and use the output from an ADDM task to provide us with the diagnostic information and recommendations we need to solve the issue. Along the way we’ll look at some of the different features and functionality that ADDM offers.