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. |