How Can I See Hidden Parameters In Oracle Database

Q : How Can I See Hidden Parameters In Oracle Database

SELECT a.ksppinm AS parameter
	,a.ksppdesc AS description
	,b.ksppstvl AS session_value
	,c.ksppstvl AS instance_value
FROM x$ksppi a
	,x$ksppcv b
	,x$ksppsv c
WHERE a.indx = b.indx
	AND a.indx = c.indx
	AND a.ksppinm LIKE '/_%' ESCAPE '/'
	AND a.ksppinm = DECODE(LOWER('&1'), 'all', a.ksppinm, LOWER('&1'))
ORDER BY a.ksppinm;