查看oracle 隐藏参数

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, '_', '');