查看oracle隐含参数

 

本文参考http://blog.chinaunix.net/uid-20682026-id-3215008.html

 

SQL> col name format a30;
 col value format a10;
 col pdesc format a30;
 
 select a.ksppinm name, b.ksppstvl value, a.ksppdesc pdesc
 from x$ksppi a, x$ksppcv b
 where a.indx = b.indx and a.ksppinm like '_max_reasonable_scn_rate';

NAME                                               VALUE      PDESC
------------------------------                   ---------- ------------------------------
_max_reasonable_scn_rate       32768      Max reasonable SCN rate

以下参考http://www.zhongweicheng.com/?p=1759

SQL> set linesize 132
column name format a30
column value format a25
 select x.ksppinm name,
        y.ksppstvl value,
        y.ksppstdf isdefault,
        decode(bitand(y.ksppstvf, 7),
               1,
               'MODIFIED',
               4,
               'SYSTEM_MOD',
               'FALSE') ismod,
        decode(bitand(y.ksppstvf, 2), 2, 'TRUE', 'FALSE') isadj
   from sys.x$ksppi x, sys.x$ksppcv y
  where x.inst_id = userenv('Instance')
    and y.inst_id = userenv('Instance')
    and x.indx = y.indx
    and x.ksppinm like '%_&par%'
  order by translate(x.ksppinm, ' _', ' ')
 /
 
Enter value for par: external_scn_rejection_thresh
old  15:     and x.ksppinm like '%_&par%'
new  15:     and x.ksppinm like '%_external_scn_rejection_thresh%'

NAME                           VALUE                     ISDEFAULT ISMOD      ISADJ
------------------------------ ------------------------- --------- ---------- -----
_external_scn_rejection_thresh 24                        TRUE      FALSE      FALSE
old_hours