Oracle: DBMS_STATS

Query hidden parameter value

Query the session value of a hidden parameter:

select
   sys.dbms_stats_internal.get_parameter_val('_adaptive_fetch_enabled')
from
   dual;

Compare with sys.kupu$utilities_int.get_parameter_value.