OLAP system in doing statistical analysis task is very consuming resources, if just and your job task time coincide, will cause the system resources nervous, their task runs very slowly.
Here is a statement that adjusts the start and length of the Oracle statistics task, bypassing the peak of the business and making the statistics task run when the system is idle
1. Query automatic statistic Information task execution time 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 ';
2. Modify task Execution time
Begin
Sys.dbms_scheduler.set_attribute (name=> ' SYS. Saturday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily; Byday=sat; byhour=22; byminute=0; Bysecond=0 ');
Sys.dbms_scheduler.set_attribute (name=> ' SYS. Saturday_window ',attribute=> ' duration ',value=> ' 0 04:00:00 ');
End
/