Table x$ksppi contains all documented and undocumented (also know as hidden parameters, which status with an underscore) parameters; joining with x$ksppcv table on column indx with filter predicate substr(x$ksppi.ksppinm,1,1) = ‘_’ get you parameter name, value and description.
A complete list of undocumented parameters below:
- Oracle 11g (11.1.0.6) Undocumented Parameters
- Oracle 10g (10.2.0.4) Undocumented Parameters
- Oracle 9i (9.2.0.4) Undocumented Parameters
