This procedure describes how to view the current scheduled gather_and_lock_stats_job schedule.
To view the gather_and_lock_stats_job schedule
Login as user oracle on AS3000 or AgfaService on AS300 Oracle on Windows.
To login to sqlplus, type
sqlplus / as sysdba
Run the following query:
select job_name, enabled, state, job_action, repeat_interval from dba_scheduler_jobs where job_name like 'GATHER_AND_LOCK_STATS_JOB';
The query result is similar to:
To logout of sqlplus, type
exit