有时优化或trouble shooting时需要修改隐藏参数,可以用下面这个脚本查看
select ksppinm name, ksppstvl value, ksppdesc description
from x$ksppi x, x$ksppcv y
where (x.indx = y.indx)
and lower(x.KSPPINM) like lower('%optimizer%')
order by name
select ksppinm name, ksppstvl value, ksppdesc description
from x$ksppi x, x$ksppcv y
where (x.indx = y.indx)
and lower(x.KSPPINM) like lower('%optimizer%')
order by name