O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Making Sense of ADDM Data

The best way to make sense of ADDM data is to look at the details of the ADDM report that we generated as shown in Listing 12.4. We will use portions of the report and comment on how it can be interpreted and used. This example showed many types of findings, typical in such tuning scenarios.

Finding 1: SQL Statements Consuming Significant Time

As stated previously, application-generated SQL statements are the cause of most of the issues. After all, what use would a database (and hence a database administrator!) be without users and the SQLs that they execute? Listing 12.7 shows one such section. It is, in fact, the first of the various findings.

Listing 12.7. Details of Finding 1 from the ADDM Report
							FINDING 1: 100% ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required