Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to enable auto optimizer stats collection job in 11.2.0.2

961833Jan 22 2013 — edited Jan 23 2013
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 ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2013
Added on Jan 22 2013
7 comments
2,616 views