all_parameters

CREATE VIEW all_parameters
AS
     SELECT i.ksppinm name,
            i.ksppdesc description,
            CV.ksppstvl VALUE,
            CV.ksppstdf isdefault,
            DECODE (BITAND (CV.ksppstvf, 7),
                    1, 'MODIFIED',
                    4, 'SYSTEM_MOD',
                    'FALSE')
               ismodified,
            DECODE (BITAND (CV.ksppstvf, 2), 2, 'TRUE', 'FALSE') isadjusted
       FROM sys.x$ksppi i, sys.x$ksppcv CV
      WHERE     i.inst_id = USERENV ('Instance')
            AND CV.inst_id = USERENV ('Instance')
            AND i.indx = CV.indx
            AND i.ksppinm LIKE '/_%' ESCAPE '/'

   ORDER BY REPLACE (i.ksppinm, '_', '');

查看隐藏参数的视图