顯示資料庫所有引數

包括隱含引數[@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