I think flags = 8 indicates missing or inconsistent histograms.
Regards
Jonathan Lewis
On Mon, 8 Mar 2021 at 19:26, Noveljic Nenad <nenad.noveljic@xxxxxxxxxxxx>
wrote:
Hi Mikhail,
Yes, non-zero flags definitely trigger gathering of stale statistics
regardless of the number of modifications. For flags = 1 that’s a correct
behavior, since it’s a truncate. For flags=8 we still don’t know. I’m going
to chase the application people tomorrow to rerun the load jobs on the
restored database. I hope I’ll catch the culprit in the trace.
Best regards,
Nenad