View Other Posts

Disclaimer

All data and information provided on this blog is for informational purposes only. Oracleapps11idba.blogspot.com makes no representations as to accuracy, completeness, currentness, suitability, or validity of any information on this site and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its display or use. All information is provided on an as-is basis.Please use your discretion before taking any decisions based on the information in this blog.

Tuesday, September 1, 2009

How to Find out Undocumented Paramaters in Oracle Database

Use following SQL Query to find out Undocumented paramater and their value.

SELECT xpi.ksppinm "Parameter Name",
xpi.ksppdesc "Description",
xcv.ksppstvl "Session Value",
xsv.ksppstvl "Instance Value"
FROM x$ksppi xpi,
x$ksppcv xcv,
x$ksppsv xsv
WHERE xpi.indx = xcv.indx
AND xpi.indx = xsv.indx
AND SUBSTR (xpi.ksppinm, 1, 1) ='_'
ORDER BY xpi.ksppinm;

No comments:

Post a Comment