How to see Oracle Hidden Parameters

================

General

================

Ho to see Oracle Hidden parameters

COL PARAMETER FOR A30

COL "Session Value" FOR A30

COL "Instance Value" FOR A30

SET LINESIZE 140

SET PAGESIZE 100

SELECT PARAM.ksppinm "Parameter",

       SESS.ksppstvl "Session Value",

       INST.ksppstvl "Instance Value"

  FROM x$ksppi PARAM,

       x$ksppcv SESS,

       x$ksppsv INST

WHERE  PARAM.indx = SESS.indx

  AND  PARAM.indx = INST.indx

  AND  PARAM.ksppinm LIKE '/_%' escape '/'

  AND  PARAM.ksppinm LIKE '_optimizer_invalidation_period'

ORDER BY PARAM.ksppinm;

Parameter                      Session Value Instance Value

------------------------------ ------------- --------------

_optimizer_invalidation_period         18000          18000