How to Find underscore_parameters in a database during Audit process

Impact:

Unknown underscore parameters without proper advice from metalink, would impact the database.

Solution:

We need to ensure that we have proper advises from Oracle Support on those underscore parameters and
if it suggests to remove after any debugging/specific issue, then kindly consider removing those parameters.

Query to find underscore_parameters in Oracle database

SELECT x.ksppinm “Parameter”,
Y.ksppstvl “Session Value”,
Z.ksppstvl “Instance Value”
FROM x$ksppi X,
x$ksppcv Y,
x$ksppsv Z
WHERE x.indx = Y.indx
AND x.indx = z.indx
AND x.ksppinm LIKE ‘/_%’ escape ‘/’
order by x.ksppinm;