sql for Optimizer and sql tuning jobs
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’;
Discussion ¬