select client_name,JOB_NAME,JOB_STATUS,JOB_START_TIME,JOB_DURATION from DBA_AUTOTASK_JOB_HISTORY where JOB_START_TIME >systimestamp -7 and client_name=’sql tuning advisor’;

select window_name, autotask_status, optimizer_stats from dba_autotask_window_clients;

select * from DBA_SCHEDULER_WINDOWS;

select window_name, resource_plan, REPEAT_INTERVAL, duration from dba_scheduler_windows;

select client_name,JOB_NAME,JOB_STATUS,JOB_START_TIME,JOB_DURATION from DBA_AUTOTASK_JOB_HISTORY where JOB_START_TIME >systimestamp -7;

auto optimizer stats collection
sql tuning advisor
auto space advisor

select client_name,JOB_NAME,JOB_STATUS,JOB_START_TIME,JOB_DURATION from DBA_AUTOTASK_JOB_HISTORY where JOB_START_TIME >systimestamp -7 and client_name=’auto optimizer stats collection’;

select JOB_START_TIME,JOB_DURATION from DBA_AUTOTASK_JOB_HISTORY where JOB_START_TIME >systimestamp -7 and client_name=’auto optimizer stats collection’;