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

  • From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
  • To: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
  • Date: Wed, 21 Mar 2018 16:26:22 -0500

Oooooh.... That's handy!

Thanks [yet again] Jonathan!

Chris

On Wed, Mar 21, 2018 at 10:25 AM, Jonathan Lewis <
jonathan@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx>
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​


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2018