Gather statistic in 11g
I have a database running on 11.1.0.7, I have a job call GATHER_STATS_JOB is disabled, but BSLN_MAINTAIN_STATS_JOB is enabled. Check on dba_scheduler_job_run_details, the BSLN_MAINTAIN_STATS_JOB successfully run every week.
When i query below statement:
select owner,table_name, last_analyzed,STALE_STATS from DBA_TAB_STATISTICS
Many of the tables are still reported as STALE, last_analyzed column appears to be somewhere around last year.
I know that BSLN_MAINTAIN_STATS_JOB will gather table statistics as well, but why those tables with stale statistic are not collected, and when i check the last_analyzed column none of the table has latest statistics collected despite of its stale status.