Re: stale partition statistics

I think flags = 8 indicates missing or inconsistent histograms.

Regards
Jonathan Lewis

On Mon, 8 Mar 2021 at 19:26, Noveljic Nenad <nenad.noveljic_at_vontobel.com> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l