Statistics gathering and other supplemental jobs run in the maintenance schedule window.
Such jobs are called autotasks.
List of tasks available for scheduling:
select * from dba_autotask_task
sql tuning advisor AUTO_SQL_TUNING_PROG
auto space advisor auto_space_advisor_prog
auto optimizer stats collection gather_stats_prog
The list of maintenance windows:
select * from dba_scheduler_windows
MONDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
TUESDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
WEDNESDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
THURSDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
FRIDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
SATURDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
SUNDAY_WINDOW DEFAULT_MAINTENANCE_PLAN
WEEKNIGHT_WINDOW
WEEKEND_WINDOW
An automatic task may be switced on or off:
BEGIN
dbms_auto_task_admin.disable(
client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
/
BEGIN
dbms_auto_task_admin.enable(
client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
To change maintenace window parameters call (for example):
BEGIN
dbms_scheduler.disable(
name => 'SYS.MONDAY_WINDOW');
dbms_scheduler.set_attribute(
name => 'SYS.MONDAY_WINDOW',
attribute => 'REPEAT_INTERVAL',
value => 'freq=daily;byday=MON;byhour=21;byminute=0; bysecond=0');
dbms_scheduler.enable(
name => 'SYS.MONDAY_WINDOW');
END;
| 
Меню сайта