Exadata dba_autotask_window_clients.autotask_status='DISABLED'

Yong Huang

The job didn't run at all or aborted? Can you show us this?

col log_date for a35
col additional_info for a80
set long 10000
select log_id, log_date, additional_info from dba_scheduler_job_log where job_class in (select job_class_name from dba_scheduler_job_classes where comments = 'auto optimizer stats collection') and log_date > sysdate - 1 order by 1;

Also

select max(last_analyzed) from dba_indexes;
select max(last_analyzed) from dba_tables;

zhangweizhao

Yong Huang 发表于 2014-11-19 23:35
The job didn't run at all or aborted? Can you show us this?

col log_date for a35

1.     LOG_ID LOG_DATE                            ADDITIONAL_INFO
   
2. ---------- ----------------------------------- --------------------------------------------------------------------------------
   
3.      26058 19-NOV-14 10.00.11.883646 PM +08:00 STOP_ON_WINDOW_CLOSE="TRUE", PREVIOUS_VALUE="TRUE"
   
4.      26059 19-NOV-14 10.00.11.887573 PM +08:00 USER_OPERATIONS_CALLBACK="DBMS_STATS.CLEANUP_STATS_JOB_PROC", PREVIOUS_VALUE="NU
   
5.                                                LL"
   
6. 
   
7.      26060 19-NOV-14 10.00.11.889960 PM +08:00 USER_CALLBACK_CONTEXT="1", PREVIOUS_VALUE="NULL"
   
8.      26061 19-NOV-14 10.00.11.952249 PM +08:00 REASON="manually enabled"
   
9.      26062 20-NOV-14 02.00.01.790968 AM +08:00 REASON="Stop job called because associated window was closed"
   
10.      26159 20-NOV-14 02.00.01.874114 AM +08:00 REASON="Max runs reached"
    
11.      26160 20-NOV-14 02.00.01.875417 AM +08:00 REASON="Auto drop job dropped", PROGRAM_NAME=""SYS"."GATHER_STATS_PROG"", JOB_TY
    
12.                                                PE="NULL", JOB_ACTION="NULL", NUMBER_OF_ARGUMENTS="0", SCHEDULE_NAME="NULL", STA
    
13.                                                RT_DATE="NULL", REPEAT_INTERVAL="SYS"ORA$AT_WGRP_OS", QUEUE_SPEC="NULL", END_DAT
    
14.                                                E="NULL", JOB_CLASS="ORA$AT_JCNRM_OS", ENABLED="FALSE", AUTO_DROP="TRUE", RESTAR
    
15.                                                TABLE="FALSE", JOB_PRIORITY="2", MAX_RUNS="1", MAX_FAILURES="0", SCHEDULE_LIMIT=
    
16.                                                "NULL", MAX_RUN_DURATION="NULL", LOGGING_LEVEL="0", STOP_ON_WINDOW_EXIT="TRUE",
    
17.                                                INSTANCE_STICKINESS="TRUE",JOB_WEIGHT="1", NLS_ENV="", COMMENTS="automatic optim
    
18.                                                izer statistics collection job"
    
19. 
    
20. SQL> @printtab 'select client_name,window_start_time,window_duration,jobs_completed,window_end_time from dba_autotask_client_history'
    
21. CLIENT_NAME                   : auto optimizer stats collection
    
22. WINDOW_START_TIME             : 19-NOV-14 10.00.01.380677 PM +08:00
    
23. WINDOW_DURATION               : +000000000 03:59:59.310443
    
24. JOBS_COMPLETED                : 0
    
25. WINDOW_END_TIME               : 20-NOV-14 02.00.00.691120 AM +08:00
    
26. -----------------
    
27. 
    
28. PL/SQL procedure successfully completed.
    

复制代码

好像昨晚有记录了，窗口不足关闭了， 那结论就是这种enable without args 的方法是可行的。

Yong Huang

To confirm "窗口不足关闭了", also check last_analyzed of dba_tables and dba_indexes. Find the command to increase the window size. The default 4 hours may be too small for a large database.