Search notes:

Oracle: SQL Plan Management

SQL plan managment monitors execution plans over time in order to check if they deteriorate. With SQL plan management, stability of an SQL plan can be guaranteed, especially when upgrading the database or optimizer version.
SQL plan management is preferred over stored outlines.
Enhancements for SPM in 12c include

See also

dbms_spm
SQL plan management is an «option», see v$option

Index