oracle更改自动收集统计信息时间

来源：互联网发布：手机gif修改软件编辑：程序博客网时间：2024/05/18 09:12

如下脚本可把Oracle自动统计信息收集周一到周五的时间窗口从22点调整为2点。

begin  dbms_scheduler.disable(name => 'MONDAY_WINDOW');  dbms_scheduler.set_attribute(name      => 'MONDAY_WINDOW',                               attribute => 'REPEAT_INTERVAL',                               value     => 'freq=daily;byday=MON;byhour=2;byminute=0; bysecond=0');  dbms_scheduler.enable(name => 'MONDAY_WINDOW');end;/begin  dbms_scheduler.disable(name => 'TUESDAY_WINDOW');  dbms_scheduler.set_attribute(name      => 'TUESDAY_WINDOW',                               attribute => 'REPEAT_INTERVAL',                               value     => 'freq=daily;byday=TUE;byhour=2;byminute=0; bysecond=0');  dbms_scheduler.enable(name => 'TUESDAY_WINDOW');end;/begin  dbms_scheduler.disable(name => 'WEDNESDAY_WINDOW');  dbms_scheduler.set_attribute(name      => 'WEDNESDAY_WINDOW',                               attribute => 'REPEAT_INTERVAL',                               value     => 'freq=daily;byday=WED;byhour=2;byminute=0; bysecond=0');  dbms_scheduler.enable(name => 'WEDNESDAY_WINDOW');end;/begin  dbms_scheduler.disable(name => 'THURSDAY_WINDOW');  dbms_scheduler.set_attribute(name      => 'THURSDAY_WINDOW',                               attribute => 'REPEAT_INTERVAL',                               value     => 'freq=daily;byday=THU;byhour=2;byminute=0; bysecond=0');  dbms_scheduler.enable(name => 'THURSDAY_WINDOW');end;/begin  dbms_scheduler.disable(name => 'FRIDAY_WINDOW');  dbms_scheduler.set_attribute(name      => 'FRIDAY_WINDOW',                               attribute => 'REPEAT_INTERVAL',                               value     => 'freq=daily;byday=FRI;byhour=2;byminute=0; bysecond=0');  dbms_scheduler.enable(name => 'FRIDAY_WINDOW');end;/

阅读全文

0 0