Remember These Points

• SQL Plan Management offers a superior form of plan stability than the deprecated features known as stored outlines and private outlines.
• While the Optimizer ability to dynamically re?generate and utilize new execution plans can be powerful, on occasions circumstances will occur which may result in dramatic performance regressions at very inopportune times.
• Plan Management allows proven execution plans to be used and for the execution plan to evolve into better plans only under strict control.
• Plan Management utilizes a SQL Management Base (SMB) stored within the SYSAUX tablespace, which allows one to store a SQL Profile, verified high?performance execution plans within the plan baseline, and candidate execution plans within a plan history.