获取数据库中所有隐藏参数

 SELECT ksppinm, ksppstvl, ksppdescITPUB个人空间 Vv#T.Obog:jA)B
   FROM x$ksppi x, x$ksppcv y
LiZr#BZ0   WHERE x.indx = y.indx
r(xS'l c0  AND translate(ksppinm,'_','#') like '#%'
1N8m9a1P s E+~6~0  order by ksppinm;

KSPPINM                                                          KSPPSTVL                                                                         KSPPDESCITPUB个人空间7[.l9{_8w [@ |
i8d|~
---------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------------------------
[T/D`(PRO'F0_NUMA_instance_mapping                                           Not specified                                                                    Set of nodes that this instance should run onITPUB个人空间/d;@"u7M#\Cs
_NUMA_pool_size                                                  Not specified                                                                    aggregate size in bytes of NUMA pool
j^X`*ko(t\2H0_PX_use_large_pool                                               FALSE                                                                            Use Large Pool as source of PX buffers
:?!aPx.C"|k3Ia0_abort_recovery_on_join                                          FALSE                                                                            if TRUE, abort recovery on join reconfigurationsITPUB个人空间5Y,Z'b`2W
_active_standby_fast_reconfiguration                             TRUE                                                                             if TRUE optimize dlm reconfiguration for active/standby OPSITPUB个人空间J%qTbR.k_H~~ v
g@
_adaptive_direct_read                                            TRUE                                                                             Adaptive Direct ReadITPUB个人空间TNMN,k f:n
_adaptive_fetch_enabled                                          TRUE                                                                             enable/disable adaptive fetch in parallel group by
)~6uecYk%v:Y*`D0_affinity_on                                                     TRUE                                                                             enable/disable affinity at run time
4w4B._,I9zd{;t0_aiowait_timeouts                                                100                                                                              Number of aiowait timeouts before error is reported
$K$l/Wn8Uh"~0_all_shared_dblinks                                                                                                                               treat all dblinks as shared
2yl^Cnt0_allocate_creation_order                                         FALSE                                                                            should files be examined in creation order during allocationITPUB个人空间r5ht3u1?%N
_allocation_update_interval                                      3                                                                                interval at which successful search in L1 should be updated
#g'HU3SPC0_allow_error_simulation                                          FALSE                                                                            Allow error simulation for testing
Kh K ~ o8OZZS^0_allow_read_only_corruption                                      FALSE                                                                            allow read-only open even if database is corruptITPUB个人空间C'Z#i't)n`-n!o
_allow_resetlogs_corruption                                      FALSE                                                                            allow resetlogs even if it will cause corruptionITPUB个人空间JHO0d6f vi
_allow_terminal_recovery_corruption                              FALSE                                                                            Finish terminal recovery even if it may cause corruption
ybV
UlcG3^(u
p#J0_always_anti_join                                                CHOOSE                                                                           always use this method for anti-join when possible
{!j+u$OM(~ X'b0_always_semi_join                                                CHOOSE                                                                           always use this method for semi-join when possibleITPUB个人空间"R9b+J.}1z,Q*Re8[$BY*q
_always_star_transformation                                      FALSE                                                                            always favor use of star transformationITPUB个人空间E%h-Rp^
_app_ctx_vers                                                    TRUE                                                                             enable app ctx versioningITPUB个人空间A
@Cwa!na Bky B

这是其中的一些