Blog Aggregator - Amardeep Sidhu

Oracle has recently announced that 10GR2 for Linux is available for download from their technical website. If you read my last blog, you will probably agree that this release has some pretty interesting and beneficial features. But there are a few more enhancements that we need to cover before we can call ourselves 10G R2 new features experts. So, let’s forge ahead and continue our discussion on 10G Release 2.

OK, here comes another “Stop the Presses” blog. I intended to discuss the SQL Tuning Advisor, but Oracle 10G R2 intervened. Since Oracle is currently publicizing all of the features contained in the latest and greatest release of its flagship product, I thought it would be appropriate to spend a few blogs discussing them.

Rest assured, we will continue our discussion on the10G EM advisors once we have completed our review of 10G R2.

OK, let’s continue our review of 10G Enterprise Manager’s Advisors. In this blog, we turn our attention to the SQL Access Advisor (not to be confused with the SQL Tuning Advisor which is a totally different tool). We’ll begin by reviewing the benefits that the SQL Access Advisor provides and finish with a quick demo of the tool.

OK, now that I’ve given you a “brief” overview of the 10G Grid Control advisor toolsets, let’s start our in-depth discussions of them by reviewing Oracle’s Automatic Database Diagnostic Monitor (affectionately known as ADDM).


Once I cover all of the advisors, we’ll review what we have learned and then apply our newfound knowledge by running through a couple of performance tuning scenarios.