Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_STATS JOB

595077Jan 9 2008 — edited Jan 22 2008
Oracle 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2008
Added on Jan 9 2008
2 comments
554 views