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.