Re: dbms_stats.gather_table_stats

Posted by Laurel on Mar 23, 2025; 9:07pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/dbms-stats-gather-table-stats-tp12958p12960.html

Hi Erman!
That sys gather_stats_job was disabled, that was using GATHER_STATS_PROG.   So its not the cause of frequent dbms_stats.gather_table_stats

I checked  in EBS that dont have any debug profiles enabled.
Still comparing to 12.2.4 12 c and 12.2.14 19c alot of increase of dbms_stats.gather_table_stats and those takes alot of IO as well.

So have you seeing such behavior  in 19c ? Its not exadata and i have disabled all autostats. So is there any  19c feature that kicks in ?

Any idea :)?
Thx!
Br,Laurel