Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to disable automatic SPM EVOLVE TASK in Oracle". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

To disable automatic SPM EVOLVE TASK, you need to do the following

1. Check to see if automatic SPM Evolve Task is enabled

SQL > COL CLIENT_NAME FORMAT a20SQL > SQL > SELECT CLIENT_NAME, STATUS 2 FROM DBA_AUTOTASK_CLIENT 3 WHERE CLIENT_NAME = 'sql tuning advisor';CLIENT_NAME STATUS--sql tuning advisor ENABLED

two。 Disable automatic SPM Evolve Task

SQL > BEGIN 2 DBMS_AUTO_TASK_ADMIN.DISABLE (3 client_name = > 'sql tuning advisor' 4, operation = > NULL 5, window_name = > NULL 6); 7 END; 8 / PL/SQL procedure successfully completed.SQL > SELECT CLIENT_NAME, STATUS 2 FROM DBA_AUTOTASK_CLIENT 3 WHERE CLIENT_NAME =' sql tuning advisor' CLIENT_NAME STATUS--sql tuning advisor DISABLED

3. View the parameter settings of SPM Evolve Task

SQL > SELECT parameter_name, parameter_value 2 FROM dba_advisor_parameters 3 WHERE task_name = 'SYS_AUTO_SPM_EVOLVE_TASK' 4 AND parameter_value! =' UNUSED' 5 ORDER BY parameter_name PARAMETER_NAME PARAMETER_VALUE -ACCEPT_PLANS trueALTERNATE_PLAN _ BASELINE EXISTINGALTERNATE_PLAN_LIMIT 0ALTERNATE_PLAN_SOURCE CURSOR_CACHE+AUTOMATIC_WORKLOAD_REPOSITORYDAYS_TO_EXPIRE UNLIMITEDDEFAULT_EXECUTION_TYPE SPM EVOLVEEXECUTION_DAYS_TO_EXPIRE 30JOURNALING INFORMATIONMODE COMPREHENSIVETARGET_OBJECTS 1TIME_LIMIT 3600_SPM_VERIFY TRUE12 rows selected

4. Close Automatic Evolving of Baselines

SQL > BEGIN 2 DBMS_SPM.set_evolve_task_parameter (3 task_name = > 'SYS_AUTO_SPM_EVOLVE_TASK', 4 parameter = >' ACCEPT_PLANS', 5 value = > 'FALSE'); 6 END; 7 / PL/SQL procedure successfully completed.SQL > SELECT parameter_name, parameter_value 2 FROM dba_advisor_parameters 3 WHERE task_name =' SYS_AUTO_SPM_EVOLVE_TASK' 4 AND parameter_value! = 'UNUSED' 5 ORDER BY parameter_name PARAMETER_NAME PARAMETER_VALUE -ACCEPT_PLANS FALSEALTERNATE_PLAN _ BASELINE EXISTINGALTERNATE_PLAN_LIMIT 0ALTERNATE_PLAN_SOURCE CURSOR_CACHE+AUTOMATIC_WORKLOAD_REPOSITORYDAYS_TO_EXPIRE UNLIMITEDDEFAULT_EXECUTION_TYPE SPM EVOLVEEXECUTION_DAYS_TO_EXPIRE 30JOURNALING INFORMATIONMODE COMPREHENSIVETARGET_OBJECTS 1TIME_LIMIT 3600_SPM_VERIFY TRUE12 rows selected

5. Enable Automatic Evolving of Baselines

SQL > BEGIN 2 DBMS_SPM.set_evolve_task_parameter (3 task_name = > 'SYS_AUTO_SPM_EVOLVE_TASK', 4 parameter = >' ACCEPT_PLANS', 5 value = > 'TRUE'); 6 END; 7 / PL/SQL procedure successfully completed.SQL > SELECT parameter_name, parameter_value 2 FROM dba_advisor_parameters 3 WHERE task_name =' SYS_AUTO_SPM_EVOLVE_TASK' 4 AND parameter_value! = 'UNUSED' 5 ORDER BY parameter_name PARAMETER_NAME PARAMETER_VALUE -ACCEPT_PLANS trueALTERNATE_PLAN _ BASELINE EXISTINGALTERNATE_PLAN_LIMIT 0ALTERNATE_PLAN_SOURCE CURSOR_CACHE+AUTOMATIC_WORKLOAD_REPOSITORYDAYS_TO_EXPIRE UNLIMITEDDEFAULT_EXECUTION_TYPE SPM EVOLVEEXECUTION_DAYS_TO_EXPIRE 30JOURNALING INFORMATIONMODE COMPREHENSIVETARGET_OBJECTS 1TIME_LIMIT This is the end of 3600_SPM_VERIFY TRUE12 rows selected's "how to disable automatic SPM EVOLVE TASK in Oracle". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.