Database Administration (MOSC)

MOSC Banner

Objects with Stale Statistics

edited Jul 13, 2009 7:05PM in Database Administration (MOSC) 3 commentsAnswered
I have about 120 objects with stale statistics. But my gather_statistics_job (weekday maintenance window) is not taking care of the same. What could be the possible resons. (the stats for none of the table are locked.)

SQL>
SQL> select count(1) from dba_tab_statistics where STALE_STATS = 'YES' and owner='&USER';

  COUNT(1)
----------
       118

SQL>
SQL>
SQL>
SQL> select count(1) from dba_tables where trunc(last_analyzed) >= sysdate-1;

  COUNT(1)
----------
         0

SQL>

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