Database Tuning (MOSC)

MOSC Banner

Gather statistic in 11g

edited Aug 23, 2010 12:36PM in Database Tuning (MOSC) 2 commentsAnswered
Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center