SQL Plan Management (SPM) is an exceptionally important feature to consider for critical applications that require guaranteed SQL execution plan stability.
SPM is furthermore fundamental for any database upgrade to evolve execution plans from one optimizer version to another in a controlled manner, managing execution plans and ensuring that only known or verified plans are used.
A number of enhancements were made to SQL plan management in Oracle Database 12c:
Automatic plan evolution
Filtered auto capture
Capture plans from AWR Repository
Oracle Database 18c adds:
Support for a subset of SQL plan management functionality in Oracle Database Standard Edition
Oracle Database 19c adds:
Prevention of SQL regression with a new default 'AUTO' evolution mode that locates and tests alternative SQL execution plans from multiple sources to find the most optimal.
No comments:
Post a Comment