Query to get hidden parameter values

 col "Parameter" FOR a50

col "Session Value" FOR a15

col "Instance Value" FOR a15

SELECT a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value"

FROM x$ksppi a, x$ksppcv b, x$ksppsv c

WHERE a.indx = b.indx AND a.indx = c.indx

AND substr(ksppinm,1,1)='_'

AND a.ksppinm LIKE '%&param%'

ORDER BY a.ksppinm;