Why doesn't GATHER STALE (DBMS_STATS) reANALYZE this table?

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Wed, 30 Jan 2002 16:24:50 GMT
Message-ID: <3c581a44.1931926344@news.alt.net>

(I posted (something similar to) this before, I wonder if it got lost during the flood of cancels and reposts.)

8.1.6.1.0 on Linux (Redhat)

SELECT NUM_ROWS, MONITORING FROM User_Tables WHERE Table_Name = 'TABLE';   NUM_ROWS MONITORING
---------- ----------

     10244 YES SELECT INSERTS, DELETES, UPDATES, (INSERTS + DELETES + UPDATES) Total FROM User_Tab_Modifications WHERE Table_Name = 'CAMPAIGN';

   INSERTS DELETES UPDATES TOTAL ---------- ---------- ---------- ----------

        33 0 6204 6237

SELECT ROUND((6237 / 10244) * 100, 2) || '%' Percent FROM Dual;

PERCENT

---

60.88%

I ran DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA', CASCADE => TRUE, OPTIONS => 'GATHER STALE'); and this table did not get reanalyzed. Why is that?

Brian Received on Wed Jan 30 2002 - 10:24:50 CST