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

Advertisement