I believe i have 'auto optimizer stats collection job' not yet enable in my database, which i would like to enable and run every Sunday night during default maintenance window.
select * from DBA_AUTOTASK_WINDOW_CLIENTS;
WINDOW_NAME WINDOW_NEXT_TIME WINDO AUTOTASK OPTIMIZE SEGMENT_ SQL_TUNE HEALTH_M
------------------------------ ---------------------------------- ----- -------- -------- -------- -------- --------
DAILY_MAINTENANCE_WINDOW 23-JAN-13 05.00.00.000000 AM UTC FALSE ENABLED DISABLED ENABLED DISABLED DISABLED
select WINDOW_NAME,OPTIMIZER_STATS,SQL_TUNE_ADVISOR,AUTOTASK_STATUS from DBA_AUTOTASK_WINDOW_CLIENTS;
WINDOW_NAME OPTIMIZE SQL_TUNE AUTOTASK
------------------------------ -------- -------- --------
DAILY_MAINTENANCE_WINDOW DISABLED DISABLED ENABLED
select CLIENT_NAME,WINDOW_NAME,JOB_STATUS,JOB_START_TIME,JOB_DURATION
from DBA_AUTOTASK_JOB_HISTORY where CLIENT_NAME ='auto optimizer stats collection' order by JOB_START_TIME;
no rows selected
select CLIENT_NAME,WINDOW_NAME,WINDOW_START_TIME,WINDOW_DURATION
from DBA_AUTOTASK_CLIENT_HISTORY where CLIENT_NAME like 'auto optimizer stats%' order by WINDOW_START_TIME;
no rows selected
Can anyone assist me in doing this ?