{SQL計画管理}SQL計画ベースラインにカーソルから手動ロード

https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-plan-baselines.html#GUID-C7C5AEF7-5833-4780-81CF-C40CE6B43571

select max(prod_id) from sh.sales;
select sql_id from v$sql where sql_text like 'select max(prod_id) from sh.sales%';

DECLARE
  my_plans PLS_INTEGER;
BEGIN
  my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE( sql_id => 'fuc85shvfvu8n');
END;
/

SELECT SQL_HANDLE, PLAN_NAME, ENABLED, ACCEPTED, FIXED ,origin, created, SQL_TEXT
FROM   DBA_SQL_PLAN_BASELINES
where sql_text like 'select max(prod_id) from sh.sales%';