Wednesday, September 5, 2007

How to see Oracle hidden parameters

we can see the Oracle Hiden parameters with the following sql .
Don't change them without the advice of Oracle Support

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
  and a.indx = c.indx
  and a.ksppinm LIKE '/_%' escape '/'
;

No comments: