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:
Post a Comment
Note: Only a member of this blog may post a comment.