My Oracle Support Banner

DBA_TAB_STATISTICS Reports Stale Statistics Despite The Statistics Are Gathered (Doc ID 2530605.1)

Last updated on JULY 15, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Example: The last_analyzed of the below table shows Mar 27th.


It is clearly shown that the DMLs (inserts) happened on table XYZ on Mar 25th and the recent statistics are gathered on Mar 27th. However, the STALE_STATS flag is marked YES.

 

Changes

NA

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.