Performance: database slowness/blocking when Oracle Auto Task scheduled window jobs are running.

Disable below Oracle scheduled Auto jobs when you see slowness in the Application in one of the environments. 

If you have your own Gather Statistics Job  running in your environment and you do not want these advisor jobs..

These jobs usually runs in the night in weekdays and has a bigger window in the weekend.

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

exec DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'auto space advisor',operation => NULL,window_name => NULL);

exec DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'sql tuning advisor',operation => NULL,window_name => NULL);



Hope this Helps...