Search notes:

Oracle: DBMS_AUTO_TASK_ADMIN - ENABLE / DISABLE

Enable or disable automated statistic collection

dbms_auto_task_admin allows to enable or disable automatic optimizer statistics collection. 
begin
  dbms_auto_task_admin.enable (  
    client_name  => 'auto optimizer stats collection',
    operation    =>  null,
    window_name  =>  null
);
end;
/

begin
  dbms_auto_task_admin.disable (  
    client_name  => 'auto optimizer stats collection',
    operation    =>  null,
    window_name  =>  null
);
end;
/

See also

Clients that can be enabled or disabled are found in the dba_autotask_client view.

Index