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@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