Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Table MONITORING
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.
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:bruce.reardon_at_comalco.riotinto.com.au
-----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: Bruce.Reardon_at_comalco.riotinto.com.au 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Jan 01 2002 - 18:05:12 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).