Review Oracle’s hidden parameters

set line 180

col name format a40

col value format a20

col deflt format a20

col description format a60

col type format a15

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 ‘_%’

order by name

/