Re: dbms_stats.gather_schema_stats make not be computing stats

2002-11-21 Thread Connor McDonald
No - it means you have monitoring set on (at least) 207 tables, and the 207 of them have had a modification (ins/upd/del) since the monitoring was enabled. This data is used to determine whether the stats are stale or not. Its documented somewhere, but I think its around the 10% mark before marke

dbms_stats.gather_schema_stats make not be computing stats

2002-11-20 Thread Gillian
This is an 8.1.7.0.0 data on Solaris 8.   I set monitoring to YES in all 14000+ tables.In the sys.dba_tab_modifications table there are 207 tables. Question: Does this mean that there are 207 tables with STALE staistics? From what I have read, that answer is suppose to be - yes. When I run the foll