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 !