-- ========================================================== 
--	To disable automatic statistics gathering, use the DISABLE  
-- ========================================================== 
BEGIN
	DBMS_AUTO_TASK_ADMIN.DISABLE (
	client_name=>'auto optimizer stats collection',
	operation=>NULL, window_name=>NULL);
END;

-- ========================================================== 
--	To enable automatic statistics gathering, use the ENABLE  
-- ========================================================== 
BEGIN
	DBMS_AUTO_TASK_ADMIN.ENABLE (
	client_name=>'auto optimizer stats collection',
	operation=>NULL, window_name=>NULL);
END;

-- ========================================================== 
-- 		To view the status of AutoTask jobs
-- ========================================================== 

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