RE: Table MONITORING

[Stephen Andert]

In one version (I think is was 8.1.6.x.x) analyze stale didn't work right.  In 8.1.7 (releases the we've tried, .0 and .2), it didn't work for partitioned tables.  The monitor piece appears to work, so one of the other dba's here wrote a script using all_tab_modifications and dynamic sql to handle this.  It get's tricky with global indexes and big partitioned tables because some days the whole thing finishes in a couple minutes while when a table is stale enough that it analyzes the whole index.  But it's working better than before.    Stephen >>> [EMAIL PROTECTED] 01/01/02 04:35PM >>> Paul, The bug actually says: "Rediscovery Information: You will see this bug when using dbms_stats.gather_xxx_stats and : 1. An invalid granularity is supplied 2. The GATHER STALE or GATHER EMPTY options are used 3. The procedure call does not seem to work . Workaround: Correct the granularity parameter" So, provided you spell the granularity parameter correctly, this bug does not apply. We are using monitoring and gather_xxx_stats on NT under 81714 and it seems to be working ok     (ie num_rows is being updated correctly). Are you aware of any other bugs relating to monitoring / gather stats? (I know of bug 1407738 relating to table names > 28 characters). Regards, Bruce Reardon mailto:[EMAIL PROTECTED] -----Original Message----- Sent: Saturday, 29 December 2001 10:00 The DBMS_STATS.GATHER_SCHEMA_STATS procedure (with the GATHER STALE option), which uses the information produced when a table is in MONITORING mode, does not work properly in any current release of Oracle (see bug 1890016 on MetaLink). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY)   INET: [EMAIL PROTECTED] Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).