optimizer_capture_sql_plan_baselines

2023-12-25 08:49:41  Updated

optimizer_capture_sql_plan_baselines specifies whether to automatically capture a new plan to the plan baseline.

Attribute Description
Type Boolean
Default value 0
Value range
  • 0: indicates that a new plan is not automatically captured to the plan baseline.
  • 1: If the SQL statement does not have a plan baseline, a newly generated plan is added to the SQL plan baseline. If the SQL statement has a plan baseline different from the new plan, plan evolution is triggered for verification to determine whether to replace the plan baseline with the new plan.
  • Applicable scope
  • Global
  • Session
  • Involved in serialization Yes

    Contact Us