Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Table MONITORING

RE: Table MONITORING

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Tue, 01 Jan 2002 16:05:12 -0800
Message-ID: <F001.003E4B6D.20020101153517@fatcity.com>

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: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-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 Tue Jan 01 2002 - 18:05:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US