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

exec DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'auto optimizer stats collection',operation => NULL,window_name => NULL);