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


« 
» 
快速导航

Copyright © 2016 phpStudy | 豫ICP备2021030365号-3