17 lines
841 B
SQL
17 lines
841 B
SQL
--|-------------------------------------------------------------|
|
|
--| Author : Mohamed Houri --|
|
|
--| Date : 08/06/2022 --|
|
|
--| Scope : Create a SPM baseline from a cursor cache --|
|
|
--| Usage : @loadSPMfromCache --|
|
|
--| Remarks : --|
|
|
--|-------------------------------------------------------------|
|
|
set serveroutput on
|
|
declare
|
|
spm_op pls_integer;
|
|
begin
|
|
spm_op := dbms_spm.load_plans_from_cursor_cache (sql_id => '&sqlid'
|
|
,plan_hash_value => to_number(trim('&plan_hash_value'))
|
|
);
|
|
dbms_output.put_line('Plans Loaded into SPB :'||spm_op);
|
|
end;
|
|
/ |