图灵小队—各厂统计信息优化时间段

1、查看时间

select window_name,resource_plan,repeat_interval,duration,next_start_date,enabled,active from dba_scheduler_windows;

2、优化

begin
dbms_scheduler.set_attribute
(
name => 'MONDAY_WINDOW',
attribute => 'REPEAT_INTERVAL',
value => 'freq=daily;byday=MON;byhour=7;byminute=50; bysecond=0'
);
end;
/

begin
dbms_scheduler.set_attribute
(
name => 'TUESDAY_WINDOW',
attribute => 'REPEAT_INTERVAL',
value => 'freq=daily;byday=TUE;byhour=7;byminute=50; bysecond=0'
);
end;
/
begin
dbms_scheduler.set_attribute
(
name => 'WEDNESDAY_WINDOW',
attribute => 'REPEAT_INTERVAL',
value => 'freq=daily;byday=WED;byhour=7;byminute=50; bysecond=0'
);
end;
/
begin
dbms_scheduler.set_attribute
(
name => 'THURSDAY_WINDOW',
attribute => 'REPEAT_INTERVAL',
value => 'freq=daily;byday=THU;byhour=7;byminute=50; bysecond=0'
);
end;
/
begin
dbms_scheduler.set_attribute
(
name => 'FRIDAY_WINDOW',
attribute => 'REPEAT_INTERVAL',
value => 'freq=daily;byday=FRI;byhour=7;byminute=50; bysecond=0'
);
end;
/
begin
dbms_scheduler.set_attribute
(
name => 'SATURDAY_WINDOW',
attribute => 'REPEAT_INTERVAL',
value => 'freq=daily;byday=SAT;byhour=7;byminute=50; bysecond=0'
);
end;
/
begin
dbms_scheduler.set_attribute
(
name => 'SUNDAY_WINDOW',
attribute => 'REPEAT_INTERVAL',
value => 'freq=daily;byday=SUN;byhour=7;byminute=50; bysecond=0'
);
end;
/