{"id":4666,"date":"2025-07-16T20:52:40","date_gmt":"2025-07-16T20:52:40","guid":{"rendered":"https:\/\/w3buddy.com\/?p=4666"},"modified":"2026-01-15T12:42:57","modified_gmt":"2026-01-15T07:12:57","slug":"how-to-disable-autotask-in-oracle","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/how-to-disable-autotask-in-oracle\/","title":{"rendered":"How to Disable AutoTask in Oracle"},"content":{"rendered":"\n

Sometimes you may want to stop Oracle\u2019s AutoTask jobs<\/strong> temporarily \u2014 for example, to troubleshoot performance issues or avoid conflicts with important batch jobs. Instead of only changing maintenance window timings, you can completely disable AutoTask<\/strong> using DBMS_AUTO_TASK_ADMIN.DISABLE<\/code>.<\/p>\n\n\n\n

Here\u2019s a clear, practical step-by-step guide<\/strong> to do it safely.<\/p>\n\n\n\n

Check Current AutoTask Status<\/h3>\n\n\n\n

First, check which AutoTask clients are currently enabled:<\/p>\n\n\n\n

column client_name format a35;\ncolumn status format a10;\nselect client_name, status from dba_autotask_client;<\/code><\/code><\/pre>\n\n\n\n
A typical result looks like this:<\/p>\n\n\n\n
CLIENT_NAME                         STATUS\n----------------------------------- ----------\nsql tuning advisor                  ENABLED\nauto optimizer stats collection     ENABLED\nauto space advisor                  ENABLED<\/code><\/code><\/pre>\n\n\n\n
Generate Disable Statements<\/h3>\n\n\n\n
To disable all enabled AutoTask jobs, generate the required PL\/SQL commands automatically:<\/p>\n\n\n\n
set linesize 100;\ncolumn stmt format a90;\nselect 'exec dbms_auto_task_admin.disable(''' || CLIENT_NAME || ''', null, null);' stmt \nfrom dba_autotask_client \nwhere status = 'ENABLED';<\/code><\/code><\/pre>\n\n\n\n
This will output statements like:<\/p>\n\n\n\n
exec dbms_auto_task_admin.disable('auto space advisor', null, null);\nexec dbms_auto_task_admin.disable('auto optimizer stats collection', null, null);\nexec dbms_auto_task_admin.disable('sql tuning advisor', null, null);<\/code><\/code><\/pre>\n\n\n\n
Execute the Disable Commands<\/h3>\n\n\n\n
Run each statement individually to disable the jobs:<\/p>\n\n\n\n
exec dbms_auto_task_admin.disable('auto space advisor', null, null);\nexec dbms_auto_task_admin.disable('auto optimizer stats collection', null, null);\nexec dbms_auto_task_admin.disable('sql tuning advisor', null, null);<\/code><\/code><\/pre>\n\n\n\n
You should see:
PL\/SQL procedure successfully completed.<\/code><\/p>\n\n\n\n
Verify That AutoTask Is Disabled<\/h3>\n\n\n\n
Finally, check again to confirm:<\/p>\n\n\n\n
select client_name, status from dba_autotask_client;\n<\/code><\/code><\/pre>\n\n\n\n
You should see:<\/p>\n\n\n\n
CLIENT_NAME                         STATUS\n----------------------------------- ----------\nsql tuning advisor                  DISABLED\nauto optimizer stats collection     DISABLED\nauto space advisor                  DISABLED<\/code><\/code><\/pre>\n\n\n\n
Tip:<\/strong> To enable them again, just replace DISABLE<\/code> with ENABLE<\/code>:<\/p>\n\n\n\n
exec dbms_auto_task_admin.enable('auto space advisor', null, null);\nexec dbms_auto_task_admin.enable('auto optimizer stats collection', null, null);\nexec dbms_auto_task_admin.enable('sql tuning advisor', null, null);<\/code><\/code><\/pre>\n\n\n\n
That\u2019s it!<\/strong>
You now know how to disable AutoTask in Oracle<\/strong> quickly and safely.<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes you may want to stop Oracle\u2019s AutoTask jobs temporarily \u2014 for example, to troubleshoot performance issues or avoid conflicts with important batch jobs. Instead of only changing maintenance window timings, you can completely disable AutoTask using DBMS_AUTO_TASK_ADMIN.DISABLE. Here\u2019s a clear, practical step-by-step guide to do it safely. Check Current AutoTask Status First, check which […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225],"tags":[],"class_list":["post-4666","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/4666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=4666"}],"version-history":[{"count":1,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/4666\/revisions"}],"predecessor-version":[{"id":4668,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/4666\/revisions\/4668"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=4666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}