Oracle: DBMS_STATS.GET_PREFS

with param as(
   select 'APPROXIMATE_NDV_ALGORITHM'         as name from dual union all
   select 'AUTO_STAT_EXTENSIONS'              as name from dual union all
   select 'CASCADE'                           as name from dual union all
   select 'CONCURRENT'                        as name from dual union all
   select 'DEGREE'                            as name from dual union all
   select 'ENABLE_HYBRID_HISTOGRAMS'          as name from dual union all
   select 'ENABLE_TOP_FREQ_HISTOGRAMS'        as name from dual union all
   select 'ESTIMATE_PERCENT'                  as name from dual union all
   select 'GLOBAL_TEMP_TABLE_STATS'           as name from dual union all
   select 'GRANULARITY'                       as name from dual union all
   select 'INCREMENTAL'                       as name from dual union all
   select 'INCREMENTAL_LEVEL'                 as name from dual union all
   select 'INCREMENTAL_STALENESS'             as name from dual union all
   select 'METHOD_OPT'                        as name from dual union all
   select 'NO_INVALIDATE'                     as name from dual union all
   select 'OPTIONS'                           as name from dual union all
   select 'PREFERENCE_OVERRIDES_PARAMETER'    as name from dual union all
   select 'PUBLISH'                           as name from dual union all
   select 'STALE_PERCENT'                     as name from dual union all
   select 'STAT_CATEGORY'                     as name from dual union all
   select 'TABLE_CACHED_BLOCKS'               as name from dual union all
   select 'TRACE'                             as name from dual
)
select
   param.name                       param_name,
   dbms_stats.get_prefs(param.name) param_value
from
   param;