Alter/disable a sql plan baseline - Oracle Database Script. --- To disable a baseline: Begin dbms_spm.alter_sql_plan_baseline(sql_handle =>'SQL_SQL_5818768f40d7be2a', plan_name => 'SQL_PLAN_aaxsg8yktm4h100404251', attribute_name=> 'enabled', attribute_value=>'NO'); END; / Begin dbms_spm.alter_sql_plan_baseline(sql_handle =>'SQL_SQL_5818768f40d7be2a', plan_name => 'SQL_PLAN_aaxsg8yktm4h100404251', attribute_name=> 'fixed', attribute_value=>'NO'); END; / -- To enable again, just modify the attribute_value to YES,
--- To disable a baseline: Begin dbms_spm.alter_sql_plan_baseline(sql_handle =>'SQL_SQL_5818768f40d7be2a', plan_name => 'SQL_PLAN_aaxsg8yktm4h100404251', attribute_name=> 'enabled', attribute_value=>'NO'); END; / Begin dbms_spm.alter_sql_plan_baseline(sql_handle =>'SQL_SQL_5818768f40d7be2a', plan_name => 'SQL_PLAN_aaxsg8yktm4h100404251', attribute_name=> 'fixed', attribute_value=>'NO'); END; / -- To enable again, just modify the attribute_value to YES,