Oracle Hidden (_) Parameter Values

To query the hidden (_) parameters for an oracle instance use the following, can limit the list using the name or partial of the name of the parameter you are looking for:

set pagesize 60
set linesize 100
select a.ksppinm NAME,
a.ksppdesc DESCRIPTION,
b.ksppstvl SESSION_VALUE,
c.ksppstvl SYSTEM_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 '__%') ;