Load SQL Plans from the Cache
-- -- Load SQL Plans from the Cache -- DECLARE l_plans_loaded PLS_INTEGER; BEGIN l_plans_loaded := DBMS_SPM.load_plans_from_cursor_cache( sql_id => '&sqlid'); END; /
Note
Manually loaded plans are automatically marked as accepted, so there is no need to evolve them.