DBMS_SPM

This package provides an interface to manipulate plan history and SQL plan baselines.

Procedures

The most relevant procedures are:

• LOAD_PLANS_FROM_CURSOR_CACHE : loads one or more plans from the cursor cache for a SQL statement

• LOAD_PLANS_FROM_SQLSET : loads plans stored in a SQL tuning set into SQL plan baselines

• EVOLVE_SQL_PLAN_BASELINE : evolves SQL plan baselines associated with one or more SQL statements, changing them to accepted if they are found to be better than the SQL plan baseline performance and if the user asks such action

• DROP_SQL_PLAN_BASELINE : drops a single plan or all the plans associated with a SQL statement