I've been testing the gather_database_stats procedure
of the dbms_stats package and i'm back to plain old
analyze.
In theory, the stale option is supposed to analyze
only objects with the monitoring flag.
In the real life, there are those bugs :
For 8.1.5 and 8.1.6, bug 1192012 : a table could be
skip when using gather stale
For 8.1.5, bug 964359 which generates an ORA-600 when
using compute, the workaround is estimate 99%
- Andreas Jung <ajung_at_sz-sb.de> a écrit : > In my
understanding the GATHER_SCHEMA_STATS()
> function relates
> only to tables with enabled MONITORING flag. All of
> my tables
> have this flag disabled but running the function
> above on my
> schema it takes about 1 hour to complete (with
> GATHER option)
> although there should be nothing to analyze ?!
>
> Is there something wrong in my understanding ?
>
> Thanks
> Andreas
>
> --
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
> 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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Yahoo! Mail – Free email you can access from anywhere!
Received on Mon Aug 14 2000 - 07:21:01 CDT
