load SPM baseline from cursor cache

set serveroutput on
accept v_sqlid prompt 'SQLID:'
accept v_phv prompt 'PHV:'

var pvm number
begin
:pvm := dbms_spm.load_plans_from_cursor_cache(sql_id=>'&v_sqlid', plan_hash_value=>&v_phv, fixed =>'NO', enabled=>'YES');
end;
/

EXEC dbms_output.put_line('Number of plans loaded: ' || :pvm);