You can use the following sql to query the hidden parameters in an Oracle database.
These parameters are also called the underscore parameters since their names start with an underscore character.
SELECT
a.ksppinm Param ,
b.ksppstvl SessionVal ,
c.ksppstvl InstanceVal,
a.ksppdesc Descr
FROM
x$ksppi a ,
x$ksppcv b ,
x$ksppsv c
WHERE
a.indx = b.indx AND
a.indx = c.indx AND
--a.ksppinm LIKE '/_disable/_logging%' escape '/'
a.ksppinm LIKE '/_%' escape '/'
ORDER BY
1;– Let’s query the value of a specific hidden parameter.SYS@INSISTST1 > select a.ksppinm parameter,b.ksppstvl value from x$ksppi a,x$ksppcv b where a.indx=b.indx and ksppinm='_exafusion_enabled';PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
_exafusion_enabled
auto
Originally published at https://oracle-ural.blogspot.com/2021/04/how-to-see-list-of-hidden-parameters-in.html
