DBA Hub

📋Steps in this guide1/1

drop a sql baseline

declare drop_result pls_integer; begin drop_result := DBMS_SPM.DROP_SQL_PLAN_BASELINE( plan_name => '&sql_plan_baseline_name'); dbms_output.put_line(drop_result); end; /

oracle configurationintermediate
by OracleDba
12 views
1

drop a sql baseline

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
declare
drop_result pls_integer;
begin
drop_result := DBMS_SPM.DROP_SQL_PLAN_BASELINE(
plan_name => '&sql_plan_baseline_name');
dbms_output.put_line(drop_result);
end;
/
You can get the sql baseline from a sql_id from below command:
SELECT sql_handle, plan_name FROM dba_sql_plan_baselines WHERE signature IN
( SELECT exact_matching_signature FROM gv$sql WHERE sql_id='&SQL_ID');

Comments (0)

Please to add comments

No comments yet. Be the first to comment!