select dbms_stats.get_param('ESTIMATE_PERCENT') from dual;   
select dbms_stats.get_param('METHOD_OPT') from dual;   
select dbms_stats.get_param('DEGREE') from dual;   
select dbms_stats.get_param('GRANULARITY') from dual;   
select dbms_stats.get_param('CASCADE') from dual;   
select dbms_stats.get_param('NO_INVALIDATE') from dual;  



exec dbms_stats.set_param('DEGREE', 4);