{SQL計画管理}SPMで実行計画を使用可能

 

https://docs.oracle.com/cd/F19136_01/arpls/DBMS_SPM.html#GUID-0E915A6D-F783-4BE6-9E5A-C2B756666341

SELECT SQL_HANDLE, PLAN_NAME, ENABLED, ACCEPTED, FIXED ,origin, created, SQL_TEXT
FROM   DBA_SQL_PLAN_BASELINES
order by CREATED;

declare
n number;
begin
n := DBMS_SPM.ALTER_SQL_PLAN_BASELINE (
   sql_handle        =>'SQL_8a11ed0e44302a1b',
   attribute_name    =>'enabled' ,
   attribute_value   =>'NO' );
end;
/

declare
n number;
begin
n := DBMS_SPM.ALTER_SQL_PLAN_BASELINE (
   sql_handle        =>'SQL_8a11ed0e44302a1b',
   attribute_name    =>'enabled' ,
   attribute_value   =>'YES' );
end;
/