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

ITPub博客

查看Oracle隐藏参数的SQL