SQL QUERY TO DISABLE HIDDEN PARAMETERS IN ORACLE
set lines 200 pages 1000
col "Hidden_parameter" for a80
select 'alter system set "' ||x.ksppinm||'"=FALSE;' as Hidden_parameter
from
x$ksppi x
inner join x$ksppcv y on (x.indx = y.indx)
and
x.ksppinm like '%_adaptive%'
order by x.ksppinm;