oracle hidden parameter default 확인

SELECT a.ksppinm "Parameter", b.KSPPSTDF "Default Value",

       b.ksppstvl "Session Value", 

       c.ksppstvl "Instance Value",

       decode(bitand(a.ksppiflg/256,1),1,'TRUE','FALSE') IS_SESSION_MODIFIABLE, 

       decode(bitand(a.ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED',3,'IMMEDIATE','FALSE') IS_SYSTEM_MODIFIABLE

FROM   x$ksppi a,

       x$ksppcv b,

       x$ksppsv c

WHERE  a.indx = b.indx

AND    a.indx = c.indx

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

order by ksppinm;

/