This chapter has covered the automatic shared-memory management feature of Oracle Database 10g. It reviewed how to turn ASMM on and off, and how to use the various memory advisors to get optimum size recommendations. Setting the appropriate statistics level is also important for utilizing the self-management features. In Chapter 6, "Monitoring with Automatic Statistics Collection," you will learn more about database metrics and statistics-collection processes, the basis for any well-managed database. |