Oracle-L: dbms_stats.gather_schema_stats make not be computing stats

From: Gillian <zmkj04_at_yahoo.com>
Date: Wed, 20 Nov 2002 23:03:27 -0800
Message-ID: <F001.00508969.20021120230327@fatcity.com>

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 following script nightly, the number of tables (all owned by DBADMIN), in the sys.dba_tab_modifications is not decreasing: execute dbms_stats.gather_schema_stats ('DBADMIN', NULL, FALSE, 'FOR ALL COLUMNS SIZE 1', NULL, 'DEFAULT', TRUE, NULL, NULL, 'GATHER STALE', 'LIST'); Here is a sample output from the sys.dba_tab_modifications table:

TABLE_NAME                     TIMESTAMP
------------------------------ ---------
PS_VENDOR_WTHD_JUR             20-NOV-02
PS_VNDR_ADDR_SCROL             20-NOV-02
PS_VNDR_BANK_ACCT              20-NOV-02
PS_VNDR_CNTCT_SCR              20-NOV-02
PS_VNDR_LOC_SCROL              20-NOV-02
PS_VNDR_URL                    18-NOV-02
PS_VOUCHER                     20-NOV-02
PS_VOUCHER_LINE                20-NOV-02
PS_XE_XREF_TMW                 19-NOV-02

207 rows selected.
SQL> select last_analyzed from dba_tables where table_name='PS_XE_XREF_TMW'; LAST_ANAL

20-OCT-02
Question:
I do not understand why last_analyzed is Oct 20th, when I have the dbms_stats.gather_schema_stats (see above) script running nightly. Montoring is YES is dba_tables. AAArrgghhh . . . am I missing something?

Thanks

Gillian

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gillian
INET: zmkj04_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 21 2002 - 01:03:27 CST