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

  • From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
  • To: "christopherdtaylor1994@xxxxxxxxx" <christopherdtaylor1994@xxxxxxxxx>
  • Date: Wed, 21 Mar 2018 16:03:20 +0000


https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_5048.htm#REFRN23640

Sent from my iPhone

On 21 Mar 2018, at 15:51, Chris Taylor 
<christopherdtaylor1994@xxxxxxxxx<mailto: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: