DBMS_STATS JOB
595077Jan 9 2008 — edited Jan 22 2008Oracle Database version is 10.
DBMS_STAT is running fine on the database. I had ran manually stats for these 3 table on 21st Dec. I have checked and found that the last analyze for these 3 table is 21st Dec. This is how DBMS_STAT works. The GATHER_STATS_JOB collects statistics for all tables that either don't have Optimizer statistics, or have stale (outdated) statistics. Oracle considers an object's statistics stale if more than 10 percent of its data has changed since the last time it collected statistics for that object.
one thing we can do we can create another job which include those 3 tables for option all rather than auto, then it will analyze all three table in all condition.
Is there any other way if can solve this issue.
One more thing if someone can help me out to crate another DBMS_STATE job which will run every 15 days that will be helpfull.