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

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.

Start your free trial