Blog Aggregator - Amardeep Sidhu

I’ve been writing this blog for a while now. I have received a fair number of questions about my background. So I thought I would spend a few minutes in one blog discussing my “body of work” to date. Rest assured I won’t make this a habit. Mainly because I’m not that interesting. We’ll then get back on topic and continue our discussion on the 10G EM advisors.

In my last blog, I presented a quick overview of 10G Enterprise Manager’s database performance monitoring capabilities. Oracle’s latest release also contains numerous enhancements to Enterprise Manager’s advisor utilities. This blog contains a high level overview of the various advisors available in 10G Grid Control. In subsequent blogs, we’ll take an in-depth look at each one of them to see exactly what benefits they offer.

Before we begin our discussion on the intelligent advisors contained in Oracle10G, it is important that we review the entire architecture from a higher level. I want to make sure that we all have a firm understanding of 10G’s Common Manageability Infrastructure before we begin reviewing the individual advisors.

To ensure that we have this firm foundation, we must learn more about the Automatic Workload Repository and Active Session History which capture the data that many of the advisors use as input. Although, the Automatic Workload Repository and Active Session History may not be as exciting as the advice provided by the advisors and the automatic tuning recommendations provided by ADDM, it is important for us to understand the information used as input by these new components.