DBA命令速查2：查看隐含参数值

select a.ksppinm "Parameter",a.KSPPDESC "Description",b.ksppstvl "Value"
from x$ksppi a, x$ksppcv b
where a.indx = b.indx and
a.ksppinm like '%《参数的一部分》%';

SQL> set linesize 200
SQL> col Parameter format a50
SQL> col Description format a50
SQL> col Value format a50
SQL> select a.ksppinm "Parameter",a.KSPPDESC "Description",b.ksppstvl "Value"
  2  from x$ksppi a, x$ksppcv b
  3  where a.indx = b.indx and
  4  a.ksppinm like '%_mutex%';


Parameter                                          Description                                        Value
-------------------------------------------------- -------------------------------------------------- --------------------------------------------------
_mutex_wait_time                                   Mutex wait time                                    1
_mutex_spin_count                                  Mutex spin count                                   255
_mutex_wait_scheme                                 Mutex wait scheme                                  2