查询隐藏参数

SQL> set linesize 999

SQL> col NAME for a20

SQL> col DESCRIPTION for a50

SQL> col VALUE for a10

SQL> col ISDEFAULT for a10

sql>

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 x$ksppi i, 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 '/';

----------------------------------

i.ksppinm name这个值显示的就是隐藏参数