プラガブルデータベース PDB の隠しパラメタの設定値とその意味を確認する方法｜マルチテナント Oracle

SQL> set lin 1000
SQL> col Description for a50
SQL> col Parameter for a30
SQL> col Value for a20

SQL> 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 in(
'_gc_read_mostly_locking','_disable_interface_checking' ,'_gc_policy_minimum');

Parameter                      Description                                        Value
------------------------------ -------------------------------------------------- --------------------
_disable_interface_checking    disable interface checking at startup              FALSE
_gc_policy_minimum             dynamic object policy minimum activity per minute  1500
_gc_read_mostly_locking        if TRUE, enable read-mostly locking                TRUE

SQL> select a.ksppinm "Parameter",a.KSPPDESC "Description",b.ksppstvl "Value"
from x$ksppi a, x$ksppcv b where a.indx = b.indx;

：
Parameter                      Description                                        Value
------------------------------ -------------------------------------------------- --------------------
_hcs_no_smooth_drill_all       perform smooth drill all                           FALSE
_hcs_no_smooth_hierarchize     perform hierarchize smoothing                      FALSE
_hcs_no_smooth_remove_all      smooth and remove ALL member                       FALSE
_hcs_no_sql_pred_push          push sql query predicates into hierarchy targets   FALSE
_hcs_no_vis_totals             generate visual totals                             FALSE
_hcs_ignore_unsupported_calcs  ignore unsupported calcs                           FALSE
_hcs_query_hint                query hint
_hcs_no_bd_agg_opt             optimize base data aggregation                     FALSE
_hcs_no_sp_jback_opt           optimize single parent joinback                    FALSE
_hcs_no_av_jback_opt           optimize analytic view query joinback              FALSE
_hcs_no_all_prune              prune hierarchies pinned to ALL level              FALSE

Parameter                      Description                                        Value
------------------------------ -------------------------------------------------- --------------------
_hcs_avcache_dynamic_enabled   enable/disable av cache DYNAMIC definition         FALSE
_hcs_no_hord_in_oby_prune      prune levels if HIER_ORDER referenced only in ORDE FALSE
                               R BY


4846 rows selected.