Script to list hidden parameters in Oracle

The script will list all of the hidden parameters. It's possible to set the Oracle undocumented ("hidden" parameters). You should carefully test all undocumented parameters and get permission from Oracle technical support before using undocumented parameters in production.

select a.ksppinm name,
       b.ksppstvl value,
       b.ksppstdf deflt,
       decode(a.ksppity,
              1,
              'boolean',
              2,
              'string',
              3,
              'number',
              4,
              'file',
              a.ksppity) type,
       a.ksppdesc description
  from sys.x$ksppi a, sys.x$ksppcv b
 where a.indx = b.indx
   and a.ksppinm like '_%' escape ''
 order by name;


Leave a comment or a question in the comment area bellow if you fell like


Be a sport and

Search

Loading... Please wait

Subscribe to our Newsletter

Be a sport and

x