Database Tuning (MOSC)

MOSC Banner

Non Stale Statisics

edited Oct 15, 2009 4:09AM in Database Tuning (MOSC) 7 commentsAnswered
 Hallo,

i have a table with the following statistics :

num_rows :352000

last analyzed :12.12.08.

However if i issued : select count(*) from mytable ;

i have  850000 rows.

I have checked the  DBA_TAB_MODIFICATIONS  view i found :

inserts :10790 ,update :zero,delets :zero, timestamp:12.12.08

I did execute DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; 

then i have :

inserts :10810 ,update :zero,delets :zero, timestamp:12.12.08 .

My question is : How can the inserts in the table -500000-record are not reflected in the view and hence the automated gathering job is not capturing this table ?

Oracle 10g,SE,10.2.3.0.

this database was upgraded from 9i.

Best wishes


 

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