8.5. Summary
This chapter took an in-depth look at the Automatic Database Management features available in Oracle 10g. You saw how Oracle's Common Manageability Infrastructure (CMI) has delivered on the promise of a self-managing database. By automating many common administrative tasks and simplifying others, you saw how Oracle 10g has freed you to focus on the bigger issues of database management.
We covered statistics collection by first classifying the types of available statistics (optimizer statistics, performance statistics, dictionary statistics, system statistics, and user-defined statistics). You learned that without adequate, up-to-date statistics, the query optimizer often produces sub-optimal execution plans.
You learned that optimizer ...
Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 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.
