HOW TO CHECK HIDDEN PARAMETERS IN ORACLE 11G

Using below SQL we can check hidden parameters from Oracle 11g

We should not change these parameters without the consent of Oracle Support.

set linesize 200
col “Parameter” for a30
col “Session Value” for a10
col “Instance Value” for a10
col “Default value” for a5
col SESSMOD for a7
col SYSMOD for a9
col “Description” for a45

select a.ksppinm “Parameter”, b.ksppstvl “Session Value”, c.ksppstvl “Instance Value” ,b.ksppstdf “Default value”, decode(bitand(a.ksppiflg/256,3),1, ‘True’, ‘False’) SESSMOD,decode(bitand(a.ksppiflg/65536,3),1,’IMMEDIATE’,2,’DEFERRED’,3,’IMMEDIATE’,’FALSE’) SYSMOD,a.ksppdesc “Description” from sys.x$ksppi a, sys.x$ksppcv b , sys.x$ksppsv c where a.indx = b.indx and a.indx = c.indx and substr(ksppinm,1,2)=’_h’ order by a.ksppinm;

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."