Скрытые параметры Oracle : Oracle

select ksppinm from x$ksppi where substr(ksppinm,1,1) = '_';

select x.indx+1 instance_num,
ksppinm Parameter_name,ksppdesc description,
ksppity parameter_type,
ksppstvl parameter_value,
ksppstdf parameter_default_value,
decode (bitand(ksppiflg/256,1),1,'TRUE','FALSE') is_sess_modi,
decode (bitand(ksppiflg/65536,3),
1,'IMMEDIATE', 2,'DEFERRED','FALSE') is_sys_modi,
decode (bitand(ksppstvf,7),1,'MODIFIED',2,'TRUE','FALSE') is_modifd,
decode (bitand(ksppstvf,2),1,'MODIFIED',2,'TRUE','FALSE') is_adjd,
ksppstcmnt comm
from sys.x$ksppi x, sys.x$ksppsv y
where x.indx=y.indx
order by Parameter_name;

SELECT A.KSPPINM "Parameter",
B.KSPPSTVL "Session Value",
C.KSPPSTVL "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 '/' order by 1