SQL Plan Baseline - Initialization Parameters (Oracle 12c)

Configuring the Capture and Use of SQL Plan Baselines

You control SQL plan management with initialization parameters.

The default values are as follows:

OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=false

For any repeatable SQL statement that does not already exist in the plan history, the database does not automatically create an initial SQL plan baseline for the statement.

OPTIMIZER_USE_SQL_PLAN_BASELINES=true

For any SQL statement that has an existing SQL plan baseline, the database automatically adds new plans to the SQL plan baseline as nonaccepted plans.

Note:
The settings of the preceding parameters are independent of each other. For example, if OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES is true, then the database creates initial plan baselines for new statements even if OPTIMIZER_USE_SQL_PLAN_BASELINES is false.