本篇内容介绍了“怎么禁用Oracle中的自动SPM EVOLVE TASK”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

为了禁用自动SPM EVOLVE TASK需要执行以下操作
1. 查看自动SPM Evolve Task是否启用

SQL>COLCLIENT_NAMEFORMATa20SQL>SQL>SELECTCLIENT_NAME,STATUS2FROMDBA_AUTOTASK_CLIENT3WHERECLIENT_NAME='sqltuningadvisor';CLIENT_NAMESTATUS----------------------------sqltuningadvisorENABLED

2.禁用自动SPM Evolve Task

SQL>BEGIN2DBMS_AUTO_TASK_ADMIN.DISABLE(3client_name=>'sqltuningadvisor'4,operation=>NULL5,window_name=>NULL6);7END;8/PL/SQLproceduresuccessfullycompleted.SQL>SELECTCLIENT_NAME,STATUS2FROMDBA_AUTOTASK_CLIENT3WHERECLIENT_NAME='sqltuningadvisor';CLIENT_NAMESTATUS----------------------------sqltuningadvisorDISABLED

3. 查看SPM Evolve Task的参数设置

SQL>SELECTparameter_name,parameter_value2FROMdba_advisor_parameters3WHEREtask_name='SYS_AUTO_SPM_EVOLVE_TASK'4ANDparameter_value!='UNUSED'5ORDERBYparameter_name;PARAMETER_NAMEPARAMETER_VALUE----------------------------------------------------------------------------------------------------------------------------------------------------------------ACCEPT_PLANStrueALTERNATE_PLAN_BASELINEEXISTINGALTERNATE_PLAN_LIMIT0ALTERNATE_PLAN_SOURCECURSOR_CACHE+AUTOMATIC_WORKLOAD_REPOSITORYDAYS_TO_EXPIREUNLIMITEDDEFAULT_EXECUTION_TYPESPMEVOLVEEXECUTION_DAYS_TO_EXPIRE30JOURNALINGINFORMATIONMODECOMPREHENSIVETARGET_OBJECTS1TIME_LIMIT3600_SPM_VERIFYTRUE12rowsselected

4. 关闭Automatic Evolving of Baselines

SQL>BEGIN2DBMS_SPM.set_evolve_task_parameter(3task_name=>'SYS_AUTO_SPM_EVOLVE_TASK',4parameter=>'ACCEPT_PLANS',5value=>'FALSE');6END;7/PL/SQLproceduresuccessfullycompleted.SQL>SELECTparameter_name,parameter_value2FROMdba_advisor_parameters3WHEREtask_name='SYS_AUTO_SPM_EVOLVE_TASK'4ANDparameter_value!='UNUSED'5ORDERBYparameter_name;PARAMETER_NAMEPARAMETER_VALUE----------------------------------------------------------------------------------------------------------------------------------------------------------------ACCEPT_PLANSFALSEALTERNATE_PLAN_BASELINEEXISTINGALTERNATE_PLAN_LIMIT0ALTERNATE_PLAN_SOURCECURSOR_CACHE+AUTOMATIC_WORKLOAD_REPOSITORYDAYS_TO_EXPIREUNLIMITEDDEFAULT_EXECUTION_TYPESPMEVOLVEEXECUTION_DAYS_TO_EXPIRE30JOURNALINGINFORMATIONMODECOMPREHENSIVETARGET_OBJECTS1TIME_LIMIT3600_SPM_VERIFYTRUE12rowsselected

5. 启用Automatic Evolving of Baselines

SQL>BEGIN2DBMS_SPM.set_evolve_task_parameter(3task_name=>'SYS_AUTO_SPM_EVOLVE_TASK',4parameter=>'ACCEPT_PLANS',5value=>'TRUE');6END;7/PL/SQLproceduresuccessfullycompleted.SQL>SELECTparameter_name,parameter_value2FROMdba_advisor_parameters3WHEREtask_name='SYS_AUTO_SPM_EVOLVE_TASK'4ANDparameter_value!='UNUSED'5ORDERBYparameter_name;PARAMETER_NAMEPARAMETER_VALUE----------------------------------------------------------------------------------------------------------------------------------------------------------------ACCEPT_PLANStrueALTERNATE_PLAN_BASELINEEXISTINGALTERNATE_PLAN_LIMIT0ALTERNATE_PLAN_SOURCECURSOR_CACHE+AUTOMATIC_WORKLOAD_REPOSITORYDAYS_TO_EXPIREUNLIMITEDDEFAULT_EXECUTION_TYPESPMEVOLVEEXECUTION_DAYS_TO_EXPIRE30JOURNALINGINFORMATIONMODECOMPREHENSIVETARGET_OBJECTS1TIME_LIMIT3600_SPM_VERIFYTRUE12rowsselected

“怎么禁用Oracle中的自动SPM EVOLVE TASK”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注亿速云网站，小编将为大家输出更多高质量的实用文章！