select sname, spare4 from sys.optstat_hist_control$;

•gather system stats:

– EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
– exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
– exec DBMS_STATS.GATHER_SYSTEM_STATS(‘interval’, interval=>60)
;

• Switch on incremental statistics for partitioned tables
– DBMS_STATS.SET_GLOBAL_PREFS(‘INCREMENTAL’,’TRUE’);