isitdevops.com/databases

— prm_lst.sql
— mdw 8/97 List all initialisation parameters like param 
— nb spools to 64 lines
set pause on
set pages 30
set pause ‘Any Key..>’
col p_name  format a32 word wrap head “Parameter Name”
col p_value format a35 word wrap head “Parameter Value”
col typ     format a3
col num     format a3
accept param char prompt ‘Search string for parameters (auto wildcarded)> ‘
spool prm_lst.lst
select
 name                           p_name
,value                          p_value
,substr(decode(isdefault
       ,’TRUE’,’Y’
       ,’N’)
       ,1,4)                    dlft
,decode(type
       ,1,’B’
       ,2,’C’
       ,3,’N’
       ,’?’)
                                typ
,substr(num,1,3)                num
from sys.v_$parameter
where name like ‘¶m’||’%’
order by p_name
/
undefine param
spool off
set pages 24
— EOF