查找隐含参数

select a.ksppinm name,b.ksppstvl value,a.ksppdesc description
  from x$ksppi a,x$ksppcv b
 where a.inst_id = USERENV ('Instance')
   and b.inst_id = USERENV ('Instance')
   and a.indx = b.indx
   and upper(a.ksppinm) LIKE upper('%_optimizer_compute_index_stats%')
order by name

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15412087/viewspace-1782104/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15412087/viewspace-1782104/