List Supported Init.Ora Parameters

Description: Lists all of the supported INIT.ORA parameters.

SELECT a.ksppinm name, b.ksppstvl VALUE, b.ksppstdf isdefault,
       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 NOT LIKE '\_%' escape '\'
order  by name
/

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.