Summary

This chapter covered the automatic statistics collection feature of Oracle Database 10g. It also reviewed how to collect statistics for various database needs and how to use the various AWR reports for analysis. It discussed the statistics collection before and after database upgrades to Oracle Database 10g and the differences between database versions. The next chapter further explores using automatic undo management and the Undo Advisor.

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.