www.oracle-wiki.net SQL Library
-- -- 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; /