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
fromnum
param;