Plan change using load_plans_from_cursor_cache

This post is more of a note for myself and might be helpful to few other. Assuming db is 11gR2 and baselines/spm is used. When a new query is introduced in db, it might be that it runs with the good plan, but sometimes it picks up wrong plan. It could be that Index Range … Continue reading Plan change using load_plans_from_cursor_cache

Loading SQL Plans into SPM using AWR

SPM (SQL Plan Management) has been an useful solution for performance issues due to change in execution plan.As mentioned in Oracle Optimizer team's blog -- SQL Plan Management (SPM) allows database users to maintain stable yet optimal performance for a set of SQL statements. SPM incorporates the positive attributes of plan adaptability and plan stability, … Continue reading Loading SQL Plans into SPM using AWR