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.

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