GATHER_STATS_JOB: updating statistics on a daily basis
Posted on 2011-10-06
This job is said to be scheduled on my oracle instance, but it never starts. I can compute statistics for all my database by hand, no pb. But I'd like to run it automatically, choosing the time.
I'm not very familiar with this stored proc. The last time I had to deal with oracle statistics, many years ago, it was through a SAP instance, running Oracle 8 then 9. I had to schedule it from SAP and that was enough.
I'm running Oracle x64 10.2.0.2.0 and what I can say is that it seems to be scheduled, but no "next run date" :
select owner,program_name,schedule_name,schedule_type,start_date,repeat_interval,job_class,enabled,state,next_run_date from dba_scheduler_jobs where job_name = 'GATHER_STATS_JOB';
How would I schedule the update of some tables only, on a daily basis?