From StephenAndert@firsthealth.com Wed, 02 Jan 2002 13:05:13 -0800 From: "Stephen Andert" Date: Wed, 02 Jan 2002 13:05:13 -0800 Subject: RE: Table MONITORING Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 >>> Bruce.Reardon@comalco.riotinto.com.au 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 supplied2. The GATHER STALE or GATHER EMPTY options are used3. The procedure call does not seem to work.Workaround:Correct the granularity parameter"So, provided you spell the granularity parameter correctly, this bug doesnot apply.We are using monitoring and gather_xxx_stats on NT under 81714 and it seemsto 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 Reardonmailto:bruce.reardon@comalco.riotinto.com.au-----Original Message-----Sent: Saturday, 29 December 2001 10:00The DBMS_STATS.GATHER_SCHEMA_STATS procedure (with the GATHER STALEoption), which uses the information produced when a table is inMONITORING mode, does not work properly in any current release ofOracle (see bug 1890016 on MetaLink).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Reardon, Bruce (CALBBAY)  INET: Bruce.Reardon@comalco.riotinto.com.auFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).