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;

Leave a Reply