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

From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Wed, 21 Mar 2018 16:03:20 +0000
Message-ID: <DB6P190MB0501D3CCB66F89E994158D7BA1AA0_at_DB6P190MB0501.EURP190.PROD.OUTLOOK.COM>



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_at_gmail.com<mailto: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
Received on Wed Mar 21 2018 - 17:03:20 CET

Original text of this message