DBMS_STATS.GATHER_DICTIONARY_STATS not gathering stale statistics
From: Ls Cheng <exriscer_at_gmail.com>
Date: Tue, 13 Jul 2021 14:37:00 +0200
Message-ID: <CAJ2-Qb8McO+osg8DBfD-StY+OyX2X5GEs_BuSYUEbGtMRjjYGw_at_mail.gmail.com>
Hi all
Date: Tue, 13 Jul 2021 14:37:00 +0200
Message-ID: <CAJ2-Qb8McO+osg8DBfD-StY+OyX2X5GEs_BuSYUEbGtMRjjYGw_at_mail.gmail.com>
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 - 14:37:00 CEST