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

Oooooh.... That's handy!

Thanks [yet again] Jonathan!

Chris

On Wed, Mar 21, 2018 at 10:25 AM, Jonathan Lewis < jonathan_at_jlcomp.demon.co.uk> wrote:

>
> 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