关闭sql tunning

1.查看维护任务状态：select CLIENT_NAME,STATUS from dba_autotask_client;2.关闭sql tuning advisorEXEC DBMS_AUTO_TASK_ADMIN.DISABLE('SQL TUNING ADVISOR',NULL,NULL);3.查看维护任务状态：select CLIENT_NAME,STATUS from dba_autotask_client; 周一至周五：22点开始，运行4H，周六周日：凌晨6点开始，运行20Hcol REPEAT_INTERVAL for a60col DURATION for a30SELECT w.window_name, w.repeat_interval, w.duration, w.enabledFROM dba_autotask_window_clients c, dba_scheduler_windows wWHERE c.window_name = w.window_nameAND c.optimizer_stats = ‘ENABLED’;