当前位置:操作系统 > Unix/Linux >>

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


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 '\'  
/  

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,