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

  • From: "Powell, Mark" <mark.powell2@xxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Mar 2018 18:25:27 +0000


Try  dba_tab_stat_prefs



Mark Powell
Database Administration
(313) 592-5148




________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf 
of Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
Sent: Wednesday, March 21, 2018 10:58 AM
To: ORACLE-L
Subject: Drawing a blank and can't find a quick answer - view for incremental 
stats enabled tables?

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