oracle学习11g性能调优官方PPTless_12.pptVIP

SQL Performance Management Objectives After completing this lesson, you should be able to: Manage changes to optimizer statistics Capture SQL profiles Use SQL Access Advisor Set up SQL Plan Management Set up various SQL Plan Management scenarios Maintaining SQL Performance Maintaining performance may require: Managing optimizer statistics Using SQL profiles Testing the data structure with SQL Access Advisor Using SQL plan baselines Maintaining Optimizer Statistics Optimizer statistics change over time Changes in statistics influence the optimizer To maintain optimum execution plans: Set stat