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