Re: Drawing a blank and can't find a quick answer - view for incremental stats enabled tables?

Check view dba_tab_stat_prefs.
There’s no equivalent user view

Regards
Jonathan Lewis
(From my iPad mini; please excuse typos and auto-correct)

> On 21 Mar 2018, at 14:58, Chris Taylor <christopherdtaylor1994_at_gmail.com> wrote:
>
> ​Is there a system view that shows which tables INCREMENTAL stats have been setup on?
>
> I know I can do:
> DBMS_STATS.get_prefs and pass in the table table and owner but surely there's a view that I can query?
>
> But I can't find it - we're on 12.1.0.2.
>
> Thanks,
> Chris​

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