Create sql baseline from cursor cache - Oracle Database Script.
DECLARE l_plans_loaded PLS_INTEGER;
BEGIN l_plans_loaded := DBMS_SPM.load_plans_from_cursor_cache(sql_id => '&sql_id');
END;
/ -- Create baseline with a particular hash value DECLARE l_plans_loaded PLS_INTEGER; BEGIN l_plans_loaded := DBMS_SPM.load_plans_from_cursor_cache( sql_id => '&sql_id', plan_hash_value => '&plan_hash_value'); END; /