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 '/'
;
Wednesday, September 5, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment