{14 パフォーマンス}自動展開タスクのパラメータを設定

 

https://docs.oracle.com/cd/F19136_01/tgsql/managing-sql-plan-baselines.html#GUID-A94CFA49-910A-4237-A7BB-39BFA94E227E

sql

COL PARAMETER_NAME FORMAT a30
COL VALUE FORMAT a10
SELECT PARAMETER_NAME, PARAMETER_VALUE AS "VALUE"
FROM   DBA_ADVISOR_PARAMETERS
WHERE   (TASK_NAME = 'SYS_AUTO_SPM_EVOLVE_TASK')
order by PARAMETER_NAME;

BEGIN
  DBMS_SPM.SET_EVOLVE_TASK_PARAMETER(
    task_name => 'SYS_AUTO_SPM_EVOLVE_TASK'
,   parameter => 'LOCAL_TIME_LIMIT'
,   value     => 1201
);
  DBMS_SPM.SET_EVOLVE_TASK_PARAMETER(
    task_name => 'SYS_AUTO_SPM_EVOLVE_TASK'
,   parameter => 'ACCEPT_PLANS'
,   value     => 'false'
);
END;
/