Query to check underscore parameter in Oracle Database

You cannot see the value of hidden or underscore parameters in "show parameter" command. You have to use below query to check the same, but if you set any hidden parameter manually then you can use "show parameter" command to check.

Oracle strongly suggests to not set any of these parameters in the database without taking any support from Oracle Metalink/GCS Team. Oracle recommends to set specific hidden or underscore parameter to resolve critical fixes or bugs.

set lines 300 pages 3000

col "Parameter_Name" for a30

col "P_Value_Session" for a26

col "P_Value_Instance" for a34

SELECT a.ksppinm "Parameter_Name",

b.ksppstvl "P_Value_Session",

c.ksppstvl "P_Value_Instance" 

FROM x$ksppi a, x$ksppcv b, x$ksppsv c

WHERE a.indx = b.indx AND

a.indx = c.indx AND

a.ksppinm LIKE '%&parameter_name%';

Thanks,

Please comment if you like this post !