Oracle Database Discussions

Hi All,

I checked for hidden parameter which has kspftctxdf='FALSE' using the below query

SELECT x.ksppinm "Parameter",

       y.ksppstvl "Session Value",

       z.ksppstvl "Instance Value",

       h.kspftctxdf "isdefault",

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

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

FROM   x$ksppi a,

       x$ksppcv b,

       x$ksppcv2 d,

       x$ksppsv c

WHERE  x.indx = y.indx

and    x.indx = h.indx

AND    x.indx = z.indx

AND    h.indx = y.indx

AND    h.kspftctxdf='FALSE'

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

/

I found a lot although i am sure that i did not change the values of most of the parameters reported

The number is huge

The question is Is there a way to  revert all hidden parameters (not one by one) to their default values ?

Appreciate your help