Re: dbms_stats.gather_table_stats

Posted by ErmanArslansOracleBlog on Mar 24, 2025; 6:39pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/dbms-stats-gather-table-stats-tp12958p12964.html

Check -> AUTOSTATS_TARGET : Setting and Effects (Doc ID 276358.1) -- for setting it. (for future)

but you already disabled auto stats as you mentioned.

You know say that you see "dbms_stats.gather_table_stats" running.

1)May there be a custom program , or external tool (like an ETL tool) that is executing this. Did you check the session/process info of those gather_table_stats sessions?

2)Statistics gathering, when you have lots of stale(s) may be a heavy process. It depends on its parameters/arguments.. Which table, what size does it have? What is the mode of the gather_table_stats / the arguments of it, and so on..

3)If you have EM, check that as well.. There may be something-related scheduled there.

4)Check -> Auto Optimizer Stats Collection Is Disabled and Yet Still Runs During Maintenance Window (Doc ID 2652183.1).. This may give you some other help, about detecting manual executions of these stats collection tasks.

5)Check the real time statistics as well.. I don't think it is, but still it is good to check ->Disabling Real-time Statistics In 19c (Doc ID 2577100.1)