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.

baselinesdbms_spmload_plans_from_cursor_cacheplansspm
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License