11g12C如何禁用自动统计信息收集作业

--关闭统计信息

col client_name for a60

select client_name,status from DBA_AUTOTASK_CLIENT;

CLIENT_NAME STATUS

------------------------------------------------------------ ----------------

auto optimizer stats collection ENABLED

auto space advisor ENABLED

sql tuning advisor ENABLED

begin

DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'auto optimizer stats collection',

operation => NULL,

window_name => NULL);

end;

/

PL/SQL procedure successfully completed.

--启用统计信息收集

select client_name,status from DBA_AUTOTASK_CLIENT;

CLIENT_NAME STATUS

------------------------------------------------------------ ----------------

auto optimizer stats collection DISABLED

auto space advisor ENABLED

sql tuning advisor ENABLED

SQL>

begin

DBMS_AUTO_TASK_ADMIN.ENABLE(client_name => 'auto optimizer stats collection',

operation => NULL,

window_name => NULL);

end;

/

PL/SQL procedure successfully completed.

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>