显示数据库所有参数

包括隐含参数[@more@]

SQL> col KSPPINM for a40
SQL> col KSPPSTVL for a40
SQL> set lines 100
SQL> set pages 200
SQL> list
1 Select a.ksppinm, b.ksppstvl
2 from x$ksppi a, x$ksppsv b
3 where a.indx = b.indx
4 order by 1

比如 _kghdsidx_count

SQL> Select a.ksppinm, b.ksppstvl
from x$ksppi a, x$ksppsv b
where a.indx = b.indx
and a.ksppinm = '_kghdsidx_count'; 2 3 4

KSPPINM
-------------------------------------------------------------------------
KSPPSTVL
-------------------------------------------------------------------------
_kghdsidx_count
5

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/207/viewspace-1005571/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/207/viewspace-1005571/