Script to list hidden parameters in Oracle
The script will list all of the hidden parameters.
It's possible to set the Oracle undocumented ("hidden" parameters). You should carefully test all undocumented parameters and get permission from Oracle technical support before using undocumented parameters in production.
select a.ksppinm name,
b.ksppstvl value,
b.ksppstdf deflt,
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 like '_%' escape ''
order by name;
