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

Automatic Statistics Collection Fundamentals

Automatic diagnosis and correction of existing and potential performance problems is an important feature in Oracle Database 10g. This is mostly accomplished by automatic statistics collection and retention and reporting using ADDM. The automatic statistics collection is done by the Automatic Workload Repository (AWR) as explained in Chapter 1, “Exploring Oracle Database 10g Architecture.”

Database statistics are effective in diagnosing various performance problems within the database. When you analyze a performance problem, you look at the cumulative difference (delta) in statistics values between the starting point and the end. These cumulative statistics are available through dynamic performance ...

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