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_at_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 Reardon<A
href="mailto:bruce.reardon_at_comalco.riotinto.com.au">mailto:bruce.reardon_at_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: <A
href="http://www.orafaq.com/">http://www.orafaq.com-- Author:
Reardon, Bruce (CALBBAY) INET:
Bruce.Reardon_at_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_at_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).
Received on Wed Jan 02 2002 - 15:05:13 CST
