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

Hi Chris,

Please see if this helps.. this will list all the objects which is setup for incremental stats update.

select OBJ.OBJECT_NAME from sys.OPTSTAT_USER_PREFS$ STAT,dba_objects OBJ where STAT.pname='INCREMENTAL' and STAT.valchar='TRUE' and STAT.OBJ#=OBJ.OBJECT_ID Thanks,
Vishnu

On Wed, Mar 21, 2018 at 10:58 AM, 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