New Latest Param.sql for finding all hidden parameters also

set pages 3000

set lines 151

accept param_name prompt ‘Enter Parameter Name : ‘

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 ( upper(ksppinm) like ‘%&param_name%’ or lower(ksppinm) like ‘%&param_name%’ )

order by a.ksppinm;