Disable gather stats ( default autotask jobs) job in 11g

Disable the auto stats job in 11g.

SQL> select client_name,status from Dba_Autotask_Client;

CLIENT_NAME                                                      STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection                                 ENABLED
auto space advisor                                                    ENABLED
sql tuning advisor                                                      ENABLED

SQL> exec dbms_auto_task_admin.disable('auto optimizer stats collection',NULL,NULL);
PL/SQL procedure successfully completed.

SQL> exec dbms_auto_task_admin.disable(client_name =>'auto space advisor',operation => NULL,window_name => NULL);
PL/SQL procedure successfully completed.


SQL>  exec dbms_auto_task_admin.disable(client_name =>'sql tuning advisor',operation => NULL,window_name => NULL);
PL/SQL procedure successfully completed.

Related views related to automated database maintenance tasks:
DBA_AUTOTASK_CLIENT
DBA_AUTOTASK_CLIENT_HISTORY
DBA_AUTOTASK_CLIENT_JOB
DBA_AUTOTASK_JOB_HISTORY
DBA_AUTOTASK_OPERATION
DBA_AUTOTASK_SCHEDULE
DBA_AUTOTASK_TASK
DBA_AUTOTASK_WINDOW_CLIENTS
DBA_AUTOTASK_WINDOW_HISTORY

posted @ 2014-03-20 17:49  princessd8251  阅读(316)  评论(0编辑  收藏  举报