修改oracle10g系统自动统计JOB的运行时间
——查看SCHEDULER_JOBS
select*from dba_scheduler_wingroup_members where
window_group_name='MAINTENANCE_WINDOW_GROUP';
——结果
1 MAINTENANCE_WINDOW_GROUP WEEKNIGHT_WINDOW
2 MAINTENANCE_WINDOW_GROUP WEEKEND_WINDOW
select t1.window_name,t1.repeat_interval,t1.duration from dba_scheduler_windows
t1,dba_scheduler_wingroup_members t2
where t1.window_name=t2.window_name and t2.window_group_name='MAINTENANCE_WINDOW_GROUP';
——查询结果
1 WEEKNIGHT_WINDOW
freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=22;byminute=0;bysecond=0 +000
08:00:00
2 WEEKEND_WINDOW freq=daily;byday=SAT;byhour=0;byminute=0;bysecond=0 +002 00:00:00
修改配置：
修改周一至周五的运行时间：
begin
dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','REPEAT_INTERVAL','freq=daily;byday=MON,TUE, WED,THU,FRI;byhour=0;byminute=0;bysecond=0');
dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','DURATION','+000 08:00:00');
end;
/
说明：
'WEEKNIGHT_WINDOW','REPEAT_INTERVAL','freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=0;byminute =0;bysecond=0'
括号中的参数指定执行的频率及时间：周一至周五的每天晚上的0点0分0秒开始执行
'WEEKNIGHT_WINDOW','DURATION','+000 08:00:00'
指定执行的时长：+000 08:00:00 即为执行8个小时。如果+002 00:00:00则代表一直执行两天。