IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home > Collecting database statistics > Gathering statistics with gather_stats_job
You can change the Oracle maintenance window default settings using the dmms_scheduler.set_attribute command.
To change the starting time and duration of the Oracle maintenance window
Log in as user oracle on AS3000 or AgfaService on AS300 Oracle on Windows.
To start a sqlplus session, type
sqlplus / as sysdba
To change the start time and duration of the maintenance window, run the dmms_scheduler.set_attribute command .
To log out of sqlplus, type
exit
Example 1
To set the weeknight window to start at 2:00 a.m. type
exec dbms_scheduler.set_attribute(name=>'WEEKNIGHT_WINDOW', attribute=>'REPEAT_INTERVAL', value=>'freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=2;byminute=0; bysecond=0');
Example 2
To set the maximum duration of the weeknight window to 4 hours, type
exec dbms_scheduler.set_attribute(name=>'WEEKNIGHT_WINDOW', attribute=>'duration', value=> '+000 04:00:00');
Topic number: 113621 Applies to: IMPAX 6.5.1 Server Knowledge Base |