Donghua's Blog - DBAGlobe: How to: get oracle hidden (underscore) parameters
Example: Below sql statements list all the parameters including "optim", including these hidden parameters. SELECT x.ksppinm name, y.ksppstvl VALUE, decode(ksppity, 1, 'BOOLEAN', 2, 'STRING', 3, 'INTEGER', 4, 'PARAMETER FILE', 5, 'RESERVED',...