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 statementLOAD_PLANS_FROM_SQLSET
: loads plans stored in a SQL tuning set into SQL plan baselinesEVOLVE_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 actionDROP_SQL_PLAN_BASELINE
: drops a single plan or all the plans associated with a SQL statement
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.