【2个基本表】名字比较难记

x$ksppi--可以查询参数的定义说明

和x$ksppcv--可以查询参数的值

例如：

select ksppinm, ksppstvl
  from x$ksppi pi, x$ksppcv cv
 where cv.indx = pi.indx
   and pi.ksppinm like '%gby%';

SQL> desc x$ksppcv
 名称                                      是否为空? 类型
 ----------------------------------------- -------- -----------------
 ADDR                                               RAW(4)
 INDX                                               NUMBER
 INST_ID                                            NUMBER
 KSPPSTVL                                           VARCHAR2(512)
 KSPPSTDVL                                          VARCHAR2(512)
 KSPPSTDF                                           VARCHAR2(9)
 KSPPSTVF                                           NUMBER
 KSPPSTCMNT                                         VARCHAR2(255)

SQL> desc x$ksppi
 名称                                      是否为空? 类型
 ----------------------------------------- -------- -------------------
 ADDR                                               RAW(4)
 INDX                                               NUMBER
 INST_ID                                            NUMBER
 KSPPINM                                            VARCHAR2(80)
 KSPPITY                                            NUMBER
 KSPPDESC                                           VARCHAR2(255)
 KSPPIFLG                                           NUMBER
 KSPPILRMFLG                                        NUMBER
 KSPPIHASH                                          NUMBER