Summary

In this chapter, you saw how ADDM can be used as the first stop in detecting, diagnosing, and solving a performance problem. Although OEM hides a lot of the complexity of obtaining this information from the performance analyst, you can still get to this data quickly using the advisor views and the APIs. You also saw some of the shortfalls of ADDM, which you need to keep in mind while performing deeper analysis, and had a foretaste of what is to come yet in Oracle Database 10g Release 2.

Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.