Modifying the 10% Staleness Threshold for DBMS_STATS Automatic Statistics Gathering
Last updated on NOVEMBER 17, 2016
Applies to:Oracle Database - Standard Edition - Version 184.108.40.206 and later
Oracle Database - Personal Edition - Version 220.127.116.11 and later
Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Starting with Oracle8i it is possible to arrange for DBMS_STATS to automatically gather Optimizer statistics for only those objects currently considered STALE since the last time statistics were gathered for them.
This article will explain how staleness is determined and whether it is possible to influence the staleness threshold.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms