Stat Collection Options

select DBMS_STATS.GET_STATS_HISTORY_RETENTION from dual;


select dbms_stats.get_stats_history_availability from dual;


col value for a30
select 'CASCADE' setting,dbms_stats.get_param('CASCADE') value from dual
union
select 'DEGREE',dbms_stats.get_param('DEGREE') from dual
union
select 'ESTIMATE_PERCENT',dbms_stats.get_param('ESTIMATE_PERCENT') from dual
union
select 'METHOD_OPT',dbms_stats.get_param('METHOD_OPT') from dual
union
select 'NO_INVALIDATE',dbms_stats.get_param('NO_INVALIDATE') from dual
union
select 'GRANULARITY',dbms_stats.get_param('GRANULARITY') from dual
union
select 'AUTOSTATS_TARGET',dbms_stats.get_param('AUTOSTATS_TARGET') from dual;