Re: DBMS_STATS.GATHER_DICTIONARY_STATS not gathering stale statistics

Hi

I think so

SQL> SELECT DBMS_STATS.get_prefs('PUBLISH') DBMS_STATS_PREFS from dual;

DBMS_STATS_PREFS

> Are your statistics set to publish?
>
> Mark Powell
> Database Administration
> (313) 592-5148
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Ls Cheng <exriscer_at_gmail.com>
> *Sent:* Tuesday, July 13, 2021 8:37 AM
> *To:* Oracle Mailinglist <oracle-l_at_freelists.org>
> *Subject:* DBMS_STATS.GATHER_DICTIONARY_STATS not gathering stale
> statistics
>
> Hi all
>
> I am running 19.10 8 nodes RAC database with Multitenant. I noticed that
> after running DBMS_STATS.GATHER_DICTIONARY_STATS in the PDB I still see
> tables with stale statistics under SYS. For example:
>
> exec DBMS_STATS.GATHER_DICTIONARY_STATS
>
> SQL> select count(*)
> 2 from dba_tab_statistics
> 3 where STALE_STATS = 'YES'
> 4 and owner = 'SYS';
>
> COUNT(*)
> ----------
> 305
>
> Anyone seen this behaviour?
>
> TIA
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l