查Oracle的隐藏参数

我都是放在$ORACLE_HOME/rdbms/admin下，看起来像个Oracle提供的脚本
$ cat show_para.sql  
col p_name for a40
col p_DESCRIPTION for a50
col p_value for a30
set linesize 10000
SELECT   i.ksppinm p_name,
    i.ksppdesc p_description,
    CV.ksppstvl p_VALUE,
    CV.ksppstdf isdefault,
    DECODE (BITAND (CV.ksppstvf, 7),1, 'MODIFIED',4, 'SYSTEM_MOD', 'FALSE')
    ismodified,
    DECODE (BITAND (CV.ksppstvf, 2), 2, 'TRUE', 'FALSE') isadjusted
    FROM   sys.x$ksppi i, sys.x$ksppcv CV
    WHERE       i.inst_id = USERENV ('Instance')
    AND CV.inst_id = USERENV ('Instance')
    AND i.indx = CV.indx
    AND upper(i.ksppinm) LIKE upper('%&p%')
    ORDER BY   REPLACE (i.ksppinm, '_', '');

比如我现在想查CBC Latch的数量，如下操作：

SQL*Plus: Release 11.2.0.1.0 Production on Sat Feb 16 18:51:17 2013
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @?/rdbms/admin/show_para　　--@代表运行，?代表$ORACLE_HOME
Enter value for p: latch                                --输入latch，如果不记得CBC Latch的参数，那就做糊涂查询
old  12:     AND upper(i.ksppinm) LIKE upper('%&p%')
new  12:     AND upper(i.ksppinm) LIKE upper('%latch%')


P_NAME                                   P_DESCRIPTION                                      P_VALUE                        ISDEFAULT ISMODIFIED ISADJ
---------------------------------------- -------------------------------------------------- ------------------------------ --------- ---------- -----
_cp_num_hash_latches                     connection pool number of hash latches             1            TRUE      FALSE      FALSE
_db_block_hash_latches                   Number of database block hash latches              4096     TRUE      FALSE      FALSE--这个参数就是CBC Latch
_db_block_lru_latches                    number of lru latches                              16                            　TRUE      FALSE      FALSE
_db_blocks_per_hash_latch                Number of blocks per hash latch                                        TRUE      FALSE      FALSE
_deq_ht_child_latches                    deq ht child latches                               8                              　　TRUE      FALSE      FALSE
_disable_latch_free_SCN_writes_via_32cas disable latch-free SCN writes using 32-bit compare FALSE      TRUE      FALSE      FALSE

Oracle中有很多隐藏参数，一般不建议修改，默认值为佳。

**********本博客所有内容均为原创，如有转载请注明作者和出处!!!**********
Name:    guoyJoe

QQ:        252803295

Email:    oracledba_cn@hotmail.com

Blog:      http://blog.csdn.net/guoyJoe

ITPUB:   http://www.itpub.net/space-uid-28460966.html

OCM:     http://education.oracle.com/education/otn/YGuo.HTM
 _____________________________________________________________
加群验证问题：哪些SGA结构是必需的，哪些是可选的？否则拒绝申请!!!

答案在：http://blog.csdn.net/guoyjoe/article/details/8624392

Oracle@Paradise 　总群:127149411

Oracle@Paradise No.1群:177089463(已满)

Oracle@Paradise No.2群:121341761

Oracle@Paradise No.3群:140856036