Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why doesn't GATHER STALE (DBMS_STATS) reANALYZE this table?
On Wed, 30 Jan 2002 16:24:50 GMT,
SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch)
wrote:
>(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
Sorry, don't bother. It is not my problem anymore.
Brian Received on Wed Jan 30 2002 - 13:28:09 CST