Oracle Script-GetHparDes.sql

set pagesize 9999
set line 130 
col NAME for a20 
col VALUE for a20 
col DESCRIB for a80 
SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc DESCRIB
     FROM SYS.x$ksppi x, SYS.x$ksppcv y
    WHERE x.inst_id = USERENV ('Instance')
         AND y.inst_id = USERENV ('Instance')
             AND x.indx = y.indx
                 AND x.ksppinm LIKE '%&par%'
                /