INIT.ORA parameters

SELECT a.ksppinm name, b.ksppstvl VALUE, b.ksppstdf isdefault,
DECODE(a.ksppity, 1, 'boolean', 2, 'string', 3, 'number', 4, 'file',
a.ksppity) TYPE,
a.ksppdesc description
FROM sys.x$ksppi a, sys.x$ksppcv b
WHERE a.indx = b.indx
AND a.ksppinm NOT LIKE '\_%' escape '\'
order by name