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

From: Vishnu <>
Date: Wed, 21 Mar 2018 11:43:31 -0400
Message-ID: <>

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,

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

Received on Wed Mar 21 2018 - 16:43:31 CET

Original text of this message