Database Tuning (MOSC)

MOSC Banner

Stale Statistics...

edited Dec 8, 2010 7:21PM in Database Tuning (MOSC) 5 commentsAnswered ✓
 Hi all;

I am trying to compare execution plans for some queries both with fresh and with stale statistics.  (collecting fresh statistics dramatically affects the plan and time required.)  I have taken one of our QA databases, and using dbms.scheduler I have disabled nightly statistics collections.  My Question, is 'How do I dertermine when there has been enough activity against the table for teh optimizer to consider the stats as being stale..??  Is there a table or view that tracks this info..??  I need this info to determine how often during a day, the stats can go stale and require a refresh,

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