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