Turn off most of Oracle auto tasks

To disable the AUTO TASK space advisor, and sql tuning advisor, and disable weekday maintenance window for auto optimizer stats collection, you could execute this.
This code works on 12c and likely a couple of versions previous to 12c – but have not tested recently.
BEGIN
dbms_auto_task_admin.disable(client_name => ‘auto space advisor’, operation => NULL, window_name => NULL);
dbms_auto_task_admin.disable(client_name => ‘sql tuning advisor’, operation => NULL, window_name => NULL);
dbms_auto_task_admin.disable(client_name => ‘auto optimizer stats collection’, operation => NULL, window_name => ‘WEEKNIGHT_WINDOW’);
END;