Gather Incremantal statistics for large or partitioned tables

BEGIN

  DBMS_STATS.SET_TABLE_PREFS (  

      ownname  =>  'HMA_TM_PROD_GEN2_MONITOR'

,     tabname  =>  'ZZT_SERVICE_LOG'

,     pname    =>  'INCREMENTAL'

,     pvalue   =>  'true'

);

END;

--This should return True. This mean incremental is enabled

select dbms_stats.get_prefs('INCREMENTAL','HMA_TM_PROD_GEN2_MONITOR','ZZT_SERVICE_LOG') from dual;

BEGIN

  DBMS_STATS.GATHER_TABLE_STATS (

      ownname  => 'HMA_TM_PROD_GEN2_MONITOR'

,     tabname  => 'ZZT_SERVICE_LOG'

);

END;

/