1.查看维护任务状态：

select CLIENT_NAME,STATUS from dba_autotask_client;

2.关闭sql tuning advisor

EXEC DBMS_AUTO_TASK_ADMIN.DISABLE('SQL TUNING ADVISOR',NULL,NULL);

3.查看维护任务状态：

select CLIENT_NAME,STATUS from dba_autotask_client;

周一至周五：22点开始，运行4H，周六周日：凌晨6点开始，运行20H

col REPEAT_INTERVAL for a60

col DURATION for a30

SELECT w.window_name, w.repeat_interval, w.duration, w.enabled

FROM dba_autotask_window_clients c, dba_scheduler_windows w

WHERE c.window_name = w.window_name

AND c.optimizer_stats = ‘ENABLED’;

ITPub博客

关闭sql tunning