Oracle: OPTSTAT_HIST_CONTROL$

select
   sname,
   spare4,
   spare6
--
-- It seems that the value of spare4 can also be found by calling dbms_stats.get_param(sname), uncomment
-- following line...
--
--(select dbms_stats.get_param(sname) from dual)
from
   optstat_hist_control$
order by
   sname;

-- SNAME                          SPARE4                              SPARE6                              
-- ------------------------------ ----------------------------------- ------------------------------------
-- ANDV_ALGO_INTERNAL_OBSERVE     FALSE                                                                   
-- APPROXIMATE_NDV                TRUE                                                                    
-- APPROXIMATE_NDV_ALGORITHM      REPEAT OR HYPERLOGLOG                                                   
-- AUTOSTATS_TARGET               AUTO                                                                    
-- AUTO_STAT_EXTENSIONS           OFF                                                                     
-- AUTO_TASK_INTERVAL             900                                                                     
-- AUTO_TASK_MAX_RUN_TIME         3600                                                                    
-- AUTO_TASK_STATUS               OFF                                                                     
-- CASCADE                        DBMS_STATS.AUTO_CASCADE                                                 
-- CONCURRENT                     OFF                                                                     
-- COORDINATOR_TRIGGER_SHARD      FALSE                                                                   
-- DEBUG                          0                                                                       
-- DEGREE                         NULL                                                                    
-- ENABLE_HYBRID_HISTOGRAMS       3                                                                       
-- ENABLE_TOP_FREQ_HISTOGRAMS     3                                                                       
-- ESTIMATE_PERCENT               DBMS_STATS.AUTO_SAMPLE_SIZE                                             
-- GATHER_AUTO                    AFTER_LOAD                                                              
-- GATHER_SCAN_RATE               HADOOP_ONLY                                                             
-- GLOBAL_TEMP_TABLE_STATS        SESSION                                                                 
-- GRANULARITY                    AUTO                                                                    
-- INCREMENTAL                    FALSE                                                                   
-- INCREMENTAL_INTERNAL_CONTROL   TRUE                                                                    
-- INCREMENTAL_LEVEL              PARTITION                                                               
-- INCREMENTAL_STALENESS          ALLOW_MIXED_FORMAT                                                      
-- JOB_OVERHEAD                   -1                                                                      
-- JOB_OVERHEAD_PERC              1                                                                       
-- MAINTAIN_STATISTICS_STATUS     FALSE                                                                   
-- METHOD_OPT                     FOR ALL COLUMNS SIZE AUTO                                               
-- MON_MODS_ALL_UPD_TIME                                                                                  
-- NO_INVALIDATE                  DBMS_STATS.AUTO_INVALIDATE                                              
-- OPTIONS                        GATHER                                                                  
-- PREFERENCE_OVERRIDES_PARAMETER FALSE                                                                   
-- PUBLISH                        TRUE                                                                    
-- ROOT_TRIGGER_PDB               FALSE                                                                   
-- SCAN_RATE                      0                                   2021-11-12 21:31:43.216000000 +01:00
-- SKIP_TIME                                                                                              
-- SNAPSHOT_UPD_TIME                                                                                      
-- SPD_RETENTION_WEEKS            53                                                                      
-- STALE_PERCENT                  10                                                                      
-- STATS_RETENTION                                                                                        
-- STAT_CATEGORY                  OBJECT_STATS, REALTIME_STATS                                            
-- SYS_FLAGS                      1                                                                       
-- TABLE_CACHED_BLOCKS            1                                                                       
-- TRACE                          0                                                                       
-- WAIT_TIME_TO_UPDATE_STATS      15