-- ========================================================== -- 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,statusFROM dba_autotask_client;
CLIENT_NAME STATUS-------------------------------------- --------
auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor ENABLED