Oracle hidden parameters

Hi,

Sometimes it is interesting to work with oracle hidden parameters. You can find the list of all hidden + normal oracle prameters using this bellow query:

Login as SYS and run the query:

SELECT a.ksppinm "Parameter",b.ksppstvl "Session Value",c.ksppstvl "Instance Value"
FROM x$ksppi a, x$ksppcv b, x$ksppsv c
WHERE a.indx = b.indx ANDa.indx = c.indx
AND a.ksppinm LIKE '%library%'
/

Cheers !

Welcome

Hi All,

Welcome to my blog site. I am an working as an Oracle DBA. I will share my day to day experience and knowledge with you using this great blogging site.

Please consider this site as your home also. This home is for all DBA's round the globe.

Thanks
Razib Ahamed khan