DBA Hub

📋Steps in this guide1/1

Alter/disable a sql plan baseline

--- To disable a baseline:

oracle configurationintermediate
by OracleDba
13 views
1

Alter/disable a sql plan baseline

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
--- 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,

Comments (0)

Please to add comments

No comments yet. Be the first to comment!