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 ‘%¶m_name%’ or lower(ksppinm) like ‘%¶m_name%’ )
order by a.ksppinm;