Home -> Mailing Lists -> Oracle-L -> Re: DBMS_STATS.GATHER_DICTIONARY_STATS not gathering stale statistics

Re: DBMS_STATS.GATHER_DICTIONARY_STATS not gathering stale statistics

From: Powell, Mark <mark.powell2_at_dxc.com>
Date: Tue, 13 Jul 2021 15:49:06 +0000
Message-ID: <BN6PR01MB25474731253642C45EF5ACA7CE149_at_BN6PR01MB2547.prod.exchangelabs.com> 








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


Received on Tue Jul 13 2021 - 17:49:06 CEST












Original text of this message