SQL QUERY TO FIND HIDDEN PARAMETERS AND THEIR VALUES ORACLE

set lines 200 pages 1000
col "Hidden_parameter" for a40
col "It's Value" for a20
select x.ksppinm as Hidden_parameter,
            y.ksppstvl "It's Value"
     from
  x$ksppi x
  inner join x$ksppcv y on (x.indx = y.indx)
and
  x.ksppinm like '%_optimizer_%batch%'
order by x.ksppinm;

set lines 200 pages 1000
col "Hidden_parameter" for a40
col "It's Value" for a20
col Desc for a40
select x.ksppinm as Hidden_parameter,
         y.ksppstvl "It's Value",
		   x.ksppdesc "Desc"	 
     from
  x$ksppi x
  inner join x$ksppcv y on (x.indx = y.indx)
and
  x.ksppinm like '%hash%'
order by x.ksppinm;