IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home > Collecting database statistics > Gathering statistics with gather_and_lock_stats_job
You can change the gather_and_lock_stats job schedule using the dmms_scheduler.set_attribute command.
To change the time and duration of the gather_and_lock_stats job
Login as user oracle on AS3000 or AgfaService on AS300 Oracle on Windows.
To login to sqlplus, type
sqlplus / as sysdba
Run the dbms_scheduler.set_attribute command as shown in the following example:
To logout of sqlplus, type
exit
Example 1
To set the schedule to run gather_and_lock_stats_job at 2:15 on Saturdays, type
exec dbms_scheduler.set_attribute(name=>'DBADMIN.GATHER_AND_LOCK_STATS_JOB', attribute=>'repeat_interval', value=>'FREQ=WEEKLY; BYDAY=SAT; BYHOUR=2; BYMINUTE=15');
Topic number: 113631 Applies to: IMPAX 6.5.1 Server Knowledge Base |