CBO参数学习之查询隐藏参数

[sql]
set lines 200  
set pages 100  
col KSPPINM   for a45                       
col KSPPSTVL  for a10                       
col KSPPDESC  for a80  
select x.ksppinm, y.ksppstvl, x.ksppdesc  
from x$ksppi x , x$ksppcv y  
     where x.indx = y.indx  
     and y.inst_id = userenv('Instance')  
     and x.inst_id = userenv('Instance')  
     and x.ksppinm like '\_%' escape '\'  
/