Blog Aggregator - Amardeep Sidhu

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.

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.

It looks like I am going to have to deviate from my intended topic of discussion for one blog. Oracle has recently announced 10G Express Edition with great fanfare. I thought that I would provide you with a quick overview of the product. We’ll then get back on track next week when I discuss 10G EM performance snapshot reports.

Now that we have a good overview of 10G AWR snapshots, let’s continue our discussion by learning how to tailor the 10G AWR snapshot environment to meet our specific needs.


If you are like me, I’m sure you would rather learn how to use the performance statistics captured in the snapshots to monitor and tune your databases. But we must spend one blog learning how to configure 10G Grid Control to ensure that we have the information we need. We can’t tune if we don’t have adequate performance measurements!