Recently i was asked a question on how can I load a SQL with its plan hash value in SQL Plan Baseline ? Because sometimes it becomes important when you have multiple child cursors and you would just like to load just one child cursor plan as 1 or 2 child cursors might not have a good plan. So the best strategy is to load the best plan. Here is how to do it
2 a pls_integer;
4 a := dbms_spm.load_plans_from_cursor_cache(
PL/SQL procedure successfully completed.