The Oracle job scheduler runs gather_stats_job during defined maintenance windows. By default, there are two maintenance windows associated with the Maintenance Window Group.
To view the gather_stats_job schedule
On an AS3000 machine, log in as the oracle user. On an AS300 machine, log in as the AgfaService user.
Start a sqlplus session by typing:
sqlplus / as sysdba
Run the following query:
select job_name, enabled, state, program_name, schedule_name from dba_scheduler_jobs where job_name like 'GATHER_STATS_JOB';
This query produces a result similar to the following:
Log out of sqlplus by typing:
exit