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. |
| Effective scope | |
| Involved in serialization | Yes |