pat98's always & forever

Oracle 21c Read-only Home 테스트

Read-Only Home 이란?
18c 에 처음 소개된 개념이며, 읽기 전용 Oracle 홈을 사용하면 여러 서버에 자동으로 원활하게 배포할 수 있는 Oracle 소프트웨어를 쉽고 유연하며 소프트웨어 이미지 기반으로 배포할 수 있습니다. 읽기 전용 Oracle 홈은 또한 확장된 다운타임 없이 Oracle Database의 패치 및 업데이트를 가능하게 합니다. 패치는 단순히 정의된 위치에서 주어진 바이너리 세트를 교체하는 것을 의미하기 때문입니다.

21c 의 경우 parameter 화일 default 위치가 read-only home 때문에 아래와 같은 위치에 생성됨.
/oracle/app/oracle/dbs
/oracle/app/oracle/homes/OraDB21Home1/network/admin/

- S/W Only 로 engine 만 설치한 상태

- orabasetab 확인 Y 인 상태이면 , read-only home 이 활성화 되어 있는것임.

[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/install# cat orabasetab
#orabasetab file is used to track Oracle Home associated with Oracle Base
/oracle/app/oracle/product/21.0.0/dbhome_1:/oracle/app/oracle:OraDB21Home1:Y:

[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/bin# ./orabasehome
/oracle/app/oracle/homes/OraDB21Home1

[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/bin# ./orabaseconfig
/oracle/app/oracle

- read-only home 을 비활성화 함.

[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/bin# ./roohctl -disable
Disabling Read-Only Oracle home.
Update orabasetab file to disable Read-Only Oracle home.
Orabasetab file has been updated successfully.
Read-Only Oracle home has been disabled successfully.
Check the log file /oracle/app/oracle/cfgtoollogs/roohctl/roohctl-210928AM112828.log for more details.

- orabasetab 확인 Y->N 로 바뀌어 있음.

[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/install# cat orabasetab
#orabasetab file is used to track Oracle Home associated with Oracle Base
/oracle/app/oracle/product/21.0.0/dbhome_1:/oracle/app/oracle:OraDB21Home1:N:

- - read-only home 을 다시 활성화 함.

[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/bin# ./roohctl -enable
Enabling Read-Only Oracle home.
Update orabasetab file to enable Read-Only Oracle home.
Orabasetab file has been updated successfully.
Create bootstrap directories for Read-Only Oracle home.
Bootstrap directories have been created successfully.
Bootstrap files have been processed successfully.
Bootstrap files have been processed successfully.
Read-Only Oracle home has been enabled successfully.
Check the log file /oracle/app/oracle/cfgtoollogs/roohctl/roohctl-210928AM113155.log for more details.

- orabasetab 확인 N->Y 로 바뀌어 있음.
[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/install# cat orabasetab
#orabasetab file is used to track Oracle Home associated with Oracle Base
/oracle/app/oracle/product/21.0.0/dbhome_1:/oracle/app/oracle:OraDB21Home1:Y:

- Listener 와 DB를 start 하고 테스트

[ORA21C]oracle@:/home/oracle# lsnrctl start
LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 28-SEP-2021 11:33:59
Copyright (c) 1991, 2021, Oracle.  All rights reserved.
Starting /oracle/app/oracle/product/21.0.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 21.0.0.0.0 - Production
System parameter file is /oracle/app/oracle/homes/OraDB21Home1/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/ora21c/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora21c)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora21c)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 21.0.0.0.0 - Production
Start Date                28-SEP-2021 11:33:59
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/homes/OraDB21Home1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/ora21c/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora21c)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

SQL> startup

SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /oracle/app/oracle/dbs/spfileORA21C.ora

[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/bin# ./roohctl -disable
Disabling Read-Only Oracle home.
Update orabasetab file to disable Read-Only Oracle home.
Orabasetab file has been updated successfully.
Read-Only Oracle home has been disabled successfully.
Check the log file /oracle/app/oracle/cfgtoollogs/roohctl/roohctl-210928PM125107.log for more details.

[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/bin# ./roohctl -enable
Enabling Read-Only Oracle home.
Cannot enable Read-Only Oracle home in a configured Oracle home.

[ORA21C]oracle@:/oracle/app/oracle/product/21.0.0/dbhome_1/install# cat orabasetab
#orabasetab file is used to track Oracle Home associated with Oracle Base
/oracle/app/oracle/product/21.0.0/dbhome_1:/oracle/app/oracle:OraDB21Home1:N:

* 테스트 결과 
=> 21c는 read-only home이  Default 이므로 disable 했을 경우는 Configuration 화일 및 listener.ora 화일 등을 기존과 같은 $ORACLE_HOME/dbs 또는 $ORACLE_HOME/network/admin 아래로 생성하고 기동해 주어야 함.
=> binary 만 있는 상태에서 read-only home 을 disable <-> enable 하는 것은 허용
=> listener 및 DB 가 생성된 상태에서 한번 Disable 한  read-only home 을 다시 enable 하는 것은 허용되지 않음
=> 웬만하면 아직 21c는 쓰지 않는 것이 좋겠다!!

                                                 
                   

https://blogs.oracle.com/database/post/oracle-database-21c-now-available-on-linux?elq_mid=200615&sh=232506150421291619&cmid=WWMK210820P00027C0001

2021년 8월 13일 Oracle 21c 버전이 정식 Release 되었다. 아직 리눅스만 가능하고..

설치 가능한 OS 리스트는 아래와 같다.

Oracle Linux 7.4/7.6 도 가능하지만 실무에선 RHEL 을 많이 사용하므로 8.2 이상에서만 가능하다고 보는게 속편하겠다.

• Oracle Linux 8.2 with the Unbreakable Enterprise Kernel 6: 5.4.17-2011.1.2.el8uek.x86_64 or later 
• Oracle Linux 8.2 with the Red Hat Compatible Kernel: 4.18.0-193.19.1.el8_2.x86_64 or later 
• Oracle Linux 7.6 with the Unbreakable Enterprise Kernel 5: 4.14.35-2025.404.1.el7uek.x86_64 or later 
• Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 4: 4.1.12-124.53.1.el7uek.x86_64 or later 
• Red Hat Enterprise Linux 8.2: 4.18.0-193.19.1.el8_2.x86_64 or later 
• SUSE Linux Enterprise Server 15 SP1: 4.12.14-197.29- default or later

또한 21c 버전은 Innovation Release 여서 19c 버전보다 제품지원 기간이 짧으므로 실무도입에는 이를 반드시 고려해야겠다.

- 설치 과정은 기존 버전 및 19c 등과 유사하며 다만 CDB 사용이 강제되었기 때문에 이에 대한 이해가 반드시 필요하다.

1) Database SW 인스톨

$ORACLE_HOME 내에 해당 화일 Upload 후 압축해제

cd $ORACLE_HOME

unzip LINUX.X64_213000_db_home

./runInstaller

만일 runInstaller 실행후 아래와 같은 에러 메세지를 만난다면 해당 rpm 을 다운로드 받고 설치해 주도록 하자.

 ./runInstaller
/oracle/app/oracle/product/21.0.0/dbhome_1/perl/bin/perl: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory

[root@ora21c install]# rpm -Uvh libnsl-2.28-151.0.1.el8.x86_64.rpm --nodeps

다시 실행

./runInstaller

[root@ora21c ~]# /oracle/app/oraInventory/orainstRoot.sh
Changing permissions of /oracle/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /oracle/app/oraInventory to dba.
The execution of the script is complete.

[root@ora21c ~]# /oracle/app/oracle/product/21.0.0/dbhome_1/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /oracle/app/oracle/product/21.0.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.

2) Database 를 생성한다.

./dbca

- 21c 부터 Non-CDB는 구성할수 없게 되었다. 무조건 PDB를 생성해야 함. (empty CDB 만드는 것은 선택할수 있다.)

나머지는 이전과 동일하다.

완료!!

[ORA21C]oracle@:/home/oracle# ss
SQL*Plus: Release 21.0.0.0.0 - Production on Mon Aug 30 15:29:02 2021
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle.  All rights reserved.
Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

sys@ORA21C> select status from v$instance;
STATUS
------------
OPEN

On-Premise 21.3 버전 기준 Hidden Parameter 조회

5997 rows selected.

KSPPINM                                  KSPPSTVL
---------------------------------------- ------------------------------
_appqos_qt                               10
_appqos_po_multiplier                    1000
_appqos_cdb_setting                      0
_ior_serialize_fault                     0
_shutdown_completion_timeout_mins        60
_inject_startup_fault                    0
_session_modp_list                       2
_wait_outlier_detection_enable           OFF
_wait_outlier_event_names
_wait_outlier_lambda_x1000               1500
_wait_outlier_dump_flags                 0
_wait_outlier_min_waits                  10
_wait_outlier_num_outliers               600
_spin_count                              1
_latch_miss_stat_sid                     0
_max_sleep_holding_latch                 4
_max_exponential_sleep                   0
_other_wait_threshold                    0
_other_wait_event_exclusion
_use_vector_post                         TRUE
_latch_class_0
_latch_class_1
_latch_class_2
_latch_class_3
_latch_class_4
_latch_class_5
_latch_class_6
_latch_class_7
_latch_classes
_ultrafast_latch_statistics              TRUE
_enable_reliable_latch_waits             TRUE
_latch_wait_list_pri_sleep_secs          1
_wait_breakup_time_csecs                 300
_wait_breakup_threshold_csecs            600
_disable_wait_state
_wait_tracker_num_intervals              0
_wait_tracker_interval_secs              10
_wait_samples_max_time_secs              120
_wait_samples_max_sections               40
_wait_yield_mode                         yield
_wait_yield_hp_mode                      yield
_wait_yield_sleep_time_msecs             1
_wait_yield_sleep_freq                   100
_wait_yield_yield_freq                   20
_post_wait_queues_num_per_class
_super_shared_enable                     FALSE
_super_shared_conversion_threshold       300
_super_shared_max_exclusive_conversions  4
_latch_pause_mode                        static
_latch_pause_count                       0
lock_name_space
processes                                300
sessions                                 472
_min_sys_process                         2
_enable_dynamic_sessions                 FALSE
_dynamic_sessions_inc_count              1000
_dynamic_sessions_force_timeout          30
_dynamic_sessions_min_force_timeout      5
_dynamic_sessions_wait_timeout           100
_max_dynamic_sessions                    472
_dynamic_sessions_max_oom_timeout        300
_session_prediction_failover_buffer      1
_process_prediction_failover_buffer      1
_enable_dynamic_processes                FALSE
_dynamic_processes_force_timeout         6
_max_dynamic_processes                   300
_dynamic_processes_wait_timeout          100
_process_percent_rampup_start            300
_process_percent_rampup_end              300
_ksu_proc_percent_threshold              70
_ksu_proc_percent_target                 50
_dynamic_processes_max_oom_timeout       300
_so_percent_upper_bound_strt             70
_so_percent_upper_bound_final            90
_so_percent_lower_bound_strt             60
_so_percent_lower_bound_final            80
_session_percent_rampup_start            472
_session_percent_rampup_end              472
_session_so_max_inc                      20000
_process_so_max_inc                      20000
_session_limit_percent_cap               25
timed_statistics                         TRUE
timed_os_statistics                      0
resource_limit                           TRUE
license_max_sessions                     0
license_sessions_warning                 0
_session_idle_bit_latches                0
_ksu_diag_kill_time                      5
_ksuitm_dont_kill_dumper                 FALSE
_disable_image_check                     FALSE
_num_longop_child_latches                1
_longops_per_latch                       64
_longops_enabled                         TRUE
_test_ksusigskip                         5
long_module_action                       TRUE
_disable_kcbhxor_osd                     FALSE
_disable_kgghshcrc32_osd                 FALSE
_disable_system_state                    4294967294
_system_state_runtime_limit              4294967294
_system_state_cputime_limit              4294967294
_disable_system_state_wait_samples       FALSE
_session_wait_history                    10
_pkt_enable                              FALSE
_pkt_start                               FALSE
_pkt_pmon_interval                       50
_collapse_wait_history                   FALSE
_short_stack_timeout_ms                  30000
_sga_early_trace                         0
_kill_session_dump                       FALSE
_logout_storm_rate                       0
_logout_storm_timeout                    5
_logout_storm_retrycnt                   600
_ksuitm_addon_trccmd
_timeout_actions_enabled                 TRUE
_idle_session_kill_enabled               TRUE
_session_allocation_latches              1
standby_db_preserve_states               NONE
_suspended_session_timeout               300
_wait_for_busy_session                   10
_process_allocation_slots                100
instance_abort_delay_time                0
_show_login_pdb_sessions                 FALSE
_disable_highres_ticks                   FALSE
_disable_os_time_page                    FALSE
_timer_precision                         10
_dbrm_quantum
_highres_drift_allowed_sec               1
_lowres_drift_allowed_sec                5
_vktm_assert_thresh                      30
_iorm_tout                               1000
__oracle_base                            /oracle/app/oracle
_rman_roundrobin_placement
_process_heartbeat_range                 3
_max_shutdown_abort_secs                 10
_cpu_count_startup                       0
cpu_count                                1
cpu_min_count                            1
_disable_cpu_check                       FALSE
_available_core_count                    0
_cpu_eff_thread_multiplier
_single_process                          FALSE
_dbg_proc_startup                        FALSE
_enqueue_deadlock_time_sec               5
_enqueue_sync_retry_attempts             15
_enqueue_sync_sim_mem_error              FALSE
_enqueue_wall_clock_time                 FALSE
_number_ksim_group_req_threshold         64
_number_cached_attributes                10
instance_groups
_number_cached_group_memberships         2048
_number_group_memberships_per_cache_line 6
_ksim_time_monitor                       auto
_group_membership_bucket_scan_timeout    5
_group_membership_bucket_batch_size      8
_group_membership_entries_per_bucket     100
_kss_quiet                               TRUE
_kss_callstack_type
event
_oradebug_force                          FALSE
_ksdxdocmd_default_timeout_ms            30000
_ksdxdocmd_enabled                       TRUE
_ksdx_charset_ratio                      0
_oradebug_cmds_at_startup
_disable_oradebug_commands               restricted
_watchpoint_on                           FALSE
_ksdxw_num_sgw                           10
_ksdxw_num_pgw                           10
_ksdxw_stack_depth                       4
_ksdxw_stack_readable                    FALSE
_ksdxw_cini_flg                          0
_ksdxw_nbufs                             1000
_hw_watchpoint_on                        TRUE
sga_max_size                             2516582400
_enable_shared_pool_durations            TRUE
_NUMA_pool_size                          Not specified
_enable_NUMA_optimization                FALSE
_enable_NUMA_support                     FALSE
_enable_NUMA_interleave                  TRUE
_touch_sga_pages_during_allocation       FALSE
use_large_pages                          TRUE
_max_largepage_alloc_time_secs           10
_use_hugetlbfs_for_SGA                   FALSE
_hugetlbfs_mount_point_for_sga
_use_hugetlbfs_per_granule               FALSE
_numgrans_per_file                       64
_system_memory_simulate                  FALSE
_disable_sga_filedel                     FALSE
_enable_memory_protection_keys           FALSE
_dump_10261_level                        0
_numa_shift_enabled                      TRUE
_numa_shift_value                        0
_freeze_kgh_timestamp                    FALSE
pre_page_sga                             TRUE
shared_memory_address                    0
hi_shared_memory_address                 0
_use_ism                                 TRUE
lock_sga                                 FALSE
_NUMA_instance_mapping                   Not specified
_simulator_upper_bound_multiple          2
_simulator_pin_inval_maxcnt              16
_simulator_lru_rebalance_thresh          10240
_simulator_lru_rebalance_sizthr          5
_simulator_bucket_mindelta               8192
_simulator_lru_scan_count                8
_simulator_internal_bound                10
_simulator_reserved_obj_count            1024
_simulator_reserved_heap_count           4096
_simulator_sampling_factor               2
_realfree_heap_max_size                  32768
_realfree_heap_pagesize                  65536
_realfree_pq_heap_pagesize               65536
_realfree_heap_mode                      0
_use_realfree_heap                       TRUE
_pga_large_extent_size                   1048576
_uga_cga_large_extent_size               262144
_total_large_extent_memory               0
_use_ism_for_pga                         TRUE
_private_memory_address
_kgh_restricted_trace                    0
_kgh_restricted_subheaps                 180
_kgh_free_list_min_effort                12
_ksm_shared_pool_stats_num_pdb           8
_ksm_shared_pool_stats_minsz             524288
_ksm_sp_rcr_hits                         10
_mem_annotation_sh_lev                   0
_mem_annotation_pr_lev                   0
_mem_annotation_scale                    1
_mem_annotation_store                    FALSE
_4031_dump_bitvec                        67194879
_4031_max_dumps                          100
_4031_dump_interval                      300
_4031_sga_dump_interval                  3600
_4031_sga_max_dumps                      10
_4030_dump_bitvec                        4095
_numa_trace_level                        0
_mem_std_extent_size                     4096
_kgsb_threshold_size                     16777216
_endprot_chunk_comment                   chk 10235 dflt
_endprot_heap_comment                    hp 10235 dflt
_endprot_subheaps                        TRUE
_endprot_stack_segments                  FALSE
_alloc_perm_as_free                      FALSE
_ksm_pre_sga_init_notif_delay_secs       0
_ksm_post_sga_init_notif_delay_secs      0
_defer_sga_enabled                       FALSE
_defer_sga_min_total_defer_segs_sz       107374182400
_defer_sga_alloc_chunk_size              1073741824
_defer_sga_min_spsz_at_startup           53687091200
_defer_sga_test_alloc_intv               0
_sga_alloc_slaves_term_timeout_secs      120
_ksmlsaf                                 0
processor_group_name
_pga_limit_target_perc                   200
_pga_limit_watch_perc                    50
_pga_limit_time_to_interrupt             2
_pga_limit_interrupt_smaller             FALSE
_pga_limit_time_until_idle               15
_pga_limit_time_until_killed             30
_pga_limit_use_immediate_kill            TRUE
_pga_limit_dump_summary                  TRUE
_pga_limit_watch_size                    104857600
_pga_limit_min_req_size                  4194304
_pga_limit_check_wait_time               1000000
_pga_limit_simulated_physmem_size        0
_pga_limit_physmem_perc                  90
_max_physmem_perc_sga                    80
_max_physmem_perc_mmt                    90
_pga_limit_per_process_minimum           3145728
_pga_auto_snapshot_threshold             524288000
_pga_auto_snapshot_percentage            20
_memory_adi_enabled                      TRUE
_memory_adi_precise_errors               FALSE
_sga_heap_chunk_alignment                FALSE
_sga_heap_chunk_alignment_disabled       FALSE
_memory_adi_bytes_per_alloc              0
_memory_adi_extend                       FALSE
_memory_adi_heap_mask                    610
_memory_adi_module_mask                  0
_NUMA_bind_mode                          default
_pdb_vm_max_size
allow_group_access_to_sga                FALSE
_gas_partition_size                      0
_suspend_4036_timeout                    14400
_suspend_4031_timeout                    14400
_heap_dump_timeout                       60
_pga_in_sga_param1
_pga_in_sga_param2
_pga_in_sga_param3
_pga_in_sga_param4
_pga_in_sga_param5
sga_min_size                             0
__sga_current_size                       0
__shared_pool_size                       520093696
shared_pool_size                         0
__large_pool_size                        16777216
large_pool_size                          0
__java_pool_size                         0
java_pool_size                           0
__streams_pool_size                      0
streams_pool_size                        0
_unified_pga_max_pool_size               0
_large_pool_min_alloc                    65536
shared_pool_reserved_size                26004684
_shared_pool_reserved_pct                5
_shared_pool_reserved_min_alloc          4400
java_soft_sessionspace_limit             0
java_max_sessionspace_size               0
_kghdsidx_count                          1
pga_aggregate_limit                      2147483648
_pga_limit_tracing                       0
_force_java_pool_zero                    FALSE
_pga_aggregate_xmem_limit                0
_parameter_spfile_sync                   FALSE
_test_param_1                            25
_test_param_2
_test_param_3
_test_param_4
_test_param_4_1
_test_param_5                            25
_test_param_6                            0
_test_param_7                            100, 1100, 2100, 3100, 4100
_test_param_8                            20
_test_param_9
_test_param_9_1                          0
_test_param_9_2                          0_startup
_test_param_9_3                          1_startup, 2_startup, 3_startu
                                         p

_test_param_10
_test_param_10_bi                        10
_test_param_10_i
_test_param_11_base                      3
_test_param_11_dep                       0_STARTUP, 1_STARTUP, 2_STARTU
                                         P

_test_param_12                           0
_test_param_13                           FALSE
_test_param_14
_test_param_15                           50
_test_param_spare
_test_param_pdb_spare
spfile                                   /oracle/app/oracle/dbs/spfileO
                                         RA21C.ora

instance_type                            RDBMS
_disable_instance_params_check           FALSE
_parameter_table_block_size              2048
ignore_session_set_param_errors
_high_priority_processes                 LGWR|LMS*|LM1*|LM2*|LM3*|LM4*|
                                         LM5*|LM6*|LM7*|LM8*|LM9*

_highest_priority_processes              VKTM
_os_sched_high_priority                  1
_os_sched_highest_priority               1
_ksb_restart_clean_time                  30000
_ksb_restart_policy_times                0, 60, 120, 240
_bg_spawn_diag_opts                      0
_static_backgrounds
_mpmt_enabled_backgrounds                *
_background_process_opts                 0
_ksd_test_param                          999
uniform_log_timestamp_format             TRUE
_kse_die_timeout                         60000
_stack_guard_level                       0
_kse_pc_table_size                       256
_kse_signature_entries                   0
_kse_signature_limit                     7
_kse_snap_ring_size                      100
_kse_snap_ring_record_stack              FALSE
_kse_snap_ring_suppress                  942 1403
_kse_snap_ring_disable                   FALSE
_kse_snap_ring_record_min
_kse_trace_int_msg_clear                 FALSE
_system_api_interception_debug           FALSE
_kse_ssnt                                FALSE
_kse_alt_stack_sig_syms                  25
_kse_auto_core                           FALSE
_symbol_no_translation                   FALSE
_messages                                600
_enqueue_locks                           5580
_enqueue_resources                       2296
_enqueue_hash                            979
_enqueue_debug_multi_instance            FALSE
_enqueue_hash_chain_latches              1
_enqueue_deadlock_scan_secs              0
_enqueue_deadlock_detect_all_global_lock FALSE
s

_enqueue_paranoia_mode_enabled           FALSE
_ksi_trace
_ksi_trace_bucket                        SHARED
_ksi_trace_bucket_size                   LCK1:1048576-REST:8192
_ksi_clientlocks_enabled                 TRUE
_ksi_pdb_checks                          TRUE
_trace_processes                         ALL
_trace_events
_trace_buffers                           ALL:256
_trace_dump_static_only                  FALSE
_trace_dump_all_procs                    FALSE
_trace_dump_cur_proc_only                FALSE
_trace_dump_client_buckets               TRUE
_cdmp_diagnostic_level                   2
nls_language                             AMERICAN
nls_territory                            AMERICA
nls_sort
nls_date_language
nls_date_format
nls_currency
nls_numeric_characters
nls_iso_currency
nls_calendar
nls_time_format
nls_timestamp_format
nls_time_tz_format
nls_timestamp_tz_format
nls_dual_currency
nls_comp                                 BINARY
nls_length_semantics                     BYTE
nls_nchar_conv_excp                      FALSE
_nchar_imp_cnv                           TRUE
_nls_parameter_sync_enabled              TRUE
_ioslave_issue_count                     500
_ioslave_batch_count                     1
disk_asynch_io                           TRUE
tape_asynch_io                           TRUE
_io_slaves_disabled                      FALSE
dbwr_io_slaves                           0
_lgwr_io_slaves                          0
_arch_io_slaves                          0
_backup_disk_io_slaves                   0
backup_tape_io_slaves                    FALSE
_fg_iorm_slaves                          1
_backup_io_pool_size                     1048576
_disable_file_locks                      FALSE
_ksfd_verify_write                       FALSE
_disable_odm                             FALSE
_enable_fast_file_zero                   TRUE
_enable_kernel_io_outliers               FALSE
fileio_network_adapters
_enable_list_io                          FALSE
filesystemio_options                     none
dnfs_batch_size                          4096
_dnfs_rdma_max                           1048576
_dnfs_rdma_min                           8192
_dnfs_rdma_enable                        rman
_omf                                     enabled
_aiowait_timeouts                        100
_io_shared_pool_size                     4194304
_max_io_size                             1048576
_io_statistics                           TRUE
_disk_sector_size_override               FALSE
_simulate_disk_sectorsize                0
_simulate_logical_sectorsize             0
_enable_asyncvio                         FALSE
_iocalibrate_max_ios                     0
_iocalibrate_init_ios                    2
clonedb                                  FALSE
instant_restore                          FALSE
_io_outlier_threshold                    500
_io_internal_test                        0
_lgwr_io_outlier                         0
_io_osd_param                            1
_fob_dgaalloc                            TRUE
_fob_ospshare                            TRUE
_ksfd_fob_pct                            0
_disksize_binary_search                  FALSE
_instant_file_create                     FALSE
http_proxy
ssl_wallet
_ksfdx_tests
_db_file_direct_io_count                 1048576
_cell_fast_file_create                   TRUE
_cell_fast_file_restore                  TRUE
_instant_file_create_exascale            FALSE
_fsdirect_fast_file_create               TRUE
_file_size_increase_increment            67108864
_ksfqp_row_count                         0
ofs_threads                              4
_ofs_write_buffer_size                   1048576
_ofs_read_buffer_size                    1031680
_default_oracle_fs_type                  ofs
_use_dynamic_shares                      1
_dynamic_share_range_factor              2
_cpu_util_adj_force                      1
_cpu_util_adj_target                     0
_low_server_threshold                    0
_high_threshold_delta                    65535
_min_lwt_lt                              24
_max_lwt_cpu_ratio                       2
_active_session_idle_limit               5
_active_session_legacy_behavior          FALSE
resource_manager_cpu_allocation          0
_resource_manager_plan
resource_manager_plan
_vkrm_schedule_interval                  10
_dbrm_dynamic_threshold                  989922280
_rm_superlong_threshold                  0
_resource_manager_always_off             FALSE
_io_resource_manager_always_on           FALSE
resource_manager_cpu_scope               INSTANCE_ONLY
_enable_os_cpu_rm                        FALSE
_max_small_io                            0
_max_large_io                            0
_auto_assign_cg_for_sessions             FALSE
_rm_numa_simulation_pgs                  0
_rm_numa_simulation_cpus                 0
_rm_numa_sched_enable                    TRUE
_dbrm_runchk                             32769000
_dbrm_short_wait_us                      300
_dbrm_num_runnable_list                  0
_db_check_cell_hints                     FALSE
_pqq_enabled                             TRUE
db_performance_profile
_rm_force_caging                         FALSE
_min_sys_percentage
_min_autotask_percentage
max_iops                                 0
max_mbps                                 0
_db_cache_max_sz                         0
_shared_pool_max_sz                      0
max_idle_time                            0
max_idle_blocker_time                    0
_rm_exadata_pdb_cpu_cnt                  FALSE
_rm_exadata_partition_fc                 FALSE
_rm_exadata_pdb_cpu_cnt_mult             2
_rm_atp_cpu_cnt_scale                    1
_hang_cpu_hung_thresh_sec                120
_pqq_debug_txn_act                       FALSE
_pqq_pdb_load_publish_threshold          0
_ksr_unit_test_processes                 0
_ksr_control_flags                       0
_ksr_control_dyn_flags                   0
_ksv_spawn_control_all                   FALSE
_ksv_max_spawn_fail_limit                5
_ksv_pool_wait_timeout                   600
_ksv_pool_hang_kill_to                   0
_ksvppktmode                             0
_ksv_static_flags1                       0
_ksv_dynamic_flags1                      0
_ksv_slave_exit_timeout                  120
_asm_slow_client_timeout_percentage      50
_gcs_spin_check_instance_threshold       30
_third_spare_parameter
_bug31828999_lm_nodrm_service_pct        95
_fifth_spare_parameter
_bug32171622_asm_reloc_restart_timeout   900
_bug32093558_srvntfn_max_job_time        180
_bug32093558_j0_deq_maxwait_time         0
_bug31789178_asm_quorum_hb               FALSE
_tenth_spare_parameter
_eleventh_spare_parameter
_bug32498459_max_small_page_sga_size     34359738368
_thirteenth_spare_parameter
_fourteenth_spare_parameter
_fifteenth_spare_parameter
_sixteenth_spare_parameter
_seventeenth_spare_parameter
_eighteenth_spare_parameter
_nineteenth_spare_parameter
_twentieth_spare_parameter
_twenty-first_spare_parameter
_twenty-second_spare_parameter
_twenty-third_spare_parameter
_twenty-fourth_spare_parameter
_twenty-fifth_spare_parameter
_twenty-sixth_spare_parameter
_twenty-seventh_spare_parameter
_twenty-eighth_spare_parameter
_twenty-ninth_spare_parameter
_thirtieth_spare_parameter
_thirty-first_spare_parameter
_thirty-second_spare_parameter
_thirty-third_spare_parameter
_thirty-fourth_spare_parameter
_thirty-fifth_spare_parameter
_thirty-sixth_spare_parameter
_thirty-seventh_spare_parameter
_thirty-eighth_spare_parameter
_thirty-ninth_spare_parameter
_fortieth_spare_parameter
_forty-first_spare_parameter
_forty-second_spare_parameter
_forty-third_spare_parameter
_forty-fourth_spare_parameter
_forty-fifth_spare_parameter
_forty-sixth_spare_parameter
_forty-seventh_spare_parameter
_forty-eighth_spare_parameter
_forty-ninth_spare_parameter
_fiftieth_spare_parameter
_fifty-first_spare_parameter
_fifty-second_spare_parameter
_fifty-third_spare_parameter
_fifty-fourth_spare_parameter
_fifty-fifth_spare_parameter
_fifty-sixth_spare_parameter
_fifty-seventh_spare_parameter
_fifty-eighth_spare_parameter
_fifty-ninth_spare_parameter
_sixtieth_spare_parameter
_sixty-first_spare_parameter
_sixty-second_spare_parameter
_sixty-third_spare_parameter
_sixty-fourth_spare_parameter
_sixty-fifth_spare_parameter
_sixty-sixth_spare_parameter
_sixty-seventh_spare_parameter
_sixty-eighth_spare_parameter
_sixty-ninth_spare_parameter
_seventieth_spare_parameter
_seventy-first_spare_parameter
_seventy-second_spare_parameter
_seventy-third_spare_parameter
_seventy-fourth_spare_parameter
_seventy-fifth_spare_parameter
_seventy-sixth_spare_parameter
_seventy-seventh_spare_parameter
_seventy-eighth_spare_parameter
_seventy-ninth_spare_parameter
_eightieth_spare_parameter
_bug31918168_keusp_stream_batch_size     DEFAULT
_bug31990919_keusp_max_num_alloc_buf     DEFAULT
_eighty-third_spare_parameter
_eighty-fourth_spare_parameter
_eighty-fifth_spare_parameter
_eighty-sixth_spare_parameter
_eighty-seventh_spare_parameter
_eighty-eighth_spare_parameter
_eighty-ninth_spare_parameter
_ninetieth_spare_parameter
_ninety-first_spare_parameter
_ninety-second_spare_parameter
_ninety-third_spare_parameter
_ninety-fourth_spare_parameter
_ninety-fifth_spare_parameter
_ninety-sixth_spare_parameter
_ninety-seventh_spare_parameter
_ninety-eighth_spare_parameter
_ninety-ninth_spare_parameter
_one-hundredth_spare_parameter
_one-hundred-and-first_spare_parameter
_one-hundred-and-second_spare_parameter
_one-hundred-and-third_spare_parameter
_one-hundred-and-fourth_spare_parameter
_one-hundred-and-fifth_spare_parameter
_one-hundred-and-sixth_spare_parameter
_one-hundred-and-seventh_spare_parameter
_one-hundred-and-eighth_spare_parameter
_one-hundred-and-ninth_spare_parameter
_one-hundred-and-tenth_spare_parameter
_one-hundred-and-eleventh_spare_paramete
r

_one-hundred-and-twelfth_spare_parameter
_one-hundred-and-thirteenth_spare_parame
ter

_one-hundred-and-fourteenth_spare_parame
ter

_one-hundred-and-fifteenth_spare_paramet
er

_one-hundred-and-sixteenth_spare_paramet
er

_one-hundred-and-seventeenth_spare_param
eter

_one-hundred-and-eighteenth_spare_parame
ter

_one-hundred-and-nineteenth_spare_parame
ter

_one-hundred-and-twentieth_spare_paramet
er

_one-hundred-and-twenty-first_spare_para
meter

_one-hundred-and-twenty-second_spare_par
ameter

_one-hundred-and-twenty-third_spare_para
meter

_one-hundred-and-twenty-fourth_spare_par
ameter

_one-hundred-and-twenty-fifth_spare_para
meter

_one-hundred-and-twenty-sixth_spare_para
meter

_one-hundred-and-twenty-seventh_spare_pa
rameter

_one-hundred-and-twenty-eighth_spare_par
ameter

_one-hundred-and-twenty-ninth_spare_para
meter

_one-hundred-and-thirtieth_spare_paramet
er

_one-hundred-and-thirty-first_spare_para
meter

_one-hundred-and-thirty-second_spare_par
ameter

_one-hundred-and-thirty-third_spare_para
meter

_one-hundred-and-thirty-fourth_spare_par
ameter

_one-hundred-and-thirty-fifth_spare_para
meter

_one-hundred-and-thirty-sixth_spare_para
meter

_one-hundred-and-thirty-seventh_spare_pa
rameter

_one-hundred-and-thirty-eighth_spare_par
ameter

_one-hundred-and-thirty-ninth_spare_para
meter

_one-hundred-and-fortieth_spare_paramete
r

_allow_synonym_for_credential            TRUE
_cloudsql_offload_enabled                FALSE
_bug32183142_hang_fast_track_progressing FALSE
_sessions

_enable_perpdb_suplog                    FALSE
_bug30932330_forceopen_bind_undotbs      FALSE
_bug32533019_DON_for_update_enabled      FALSE
_one-hundred-and-forty-seventh_spare_par FALSE
ameter

hybrid_read_only                         FALSE
read_only                                FALSE
_kebm_autotask_cont_resource_schedule    FALSE
_cache_fusion_pipelined_updates_enable
_pdb_refresh_apply_master_key_rekey      TRUE
_logminer_parallel_read                  TRUE
_one-hundred-and-fifty-fourth_spare_para FALSE
meter

_one-hundred-and-fifty-fifth_spare_param FALSE
eter

_one-hundred-and-fifty-sixth_spare_param FALSE
eter

_one-hundred-and-fifty-seventh_spare_par FALSE
ameter

_one-hundred-and-fifty-eighth_spare_para FALSE
meter

_one-hundred-and-fifty-ninth_spare_param FALSE
eter

_one-hundred-and-sixtieth_spare_paramete FALSE
r

_one-hundred-and-sixty-first_spare_param FALSE
eter

_one-hundred-and-sixty-second_spare_para FALSE
meter

_one-hundred-and-sixty-third_spare_param FALSE
eter

_one-hundred-and-sixty-fourth_spare_para FALSE
meter

_one-hundred-and-sixty-fifth_spare_param FALSE
eter

_one-hundred-and-sixty-sixth_spare_param FALSE
eter

_one-hundred-and-sixty-seventh_spare_par FALSE
ameter

_one-hundred-and-sixty-eighth_spare_para FALSE
meter

_one-hundred-and-sixty-ninth_spare_param FALSE
eter

_one-hundred-and-seventieth_spare_parame FALSE
ter

_one-hundred-and-seventy-first_spare_par FALSE
ameter

_one-hundred-and-seventy-second_spare_pa FALSE
rameter

_one-hundred-and-seventy-third_spare_par FALSE
ameter

_one-hundred-and-seventy-fourth_spare_pa FALSE
rameter

_one-hundred-and-seventy-fifth_spare_par FALSE
ameter

_one-hundred-and-seventy-sixth_spare_par FALSE
ameter

_one-hundred-and-seventy-seventh_spare_p FALSE
arameter

_one-hundred-and-seventy-eighth_spare_pa FALSE
rameter

_one-hundred-and-seventy-ninth_spare_par FALSE
ameter

_one-hundred-and-eightieth_spare_paramet FALSE
er

_one-hundred-and-eighty-first_spare_para FALSE
meter

_one-hundred-and-eighty-second_spare_par FALSE
ameter

_one-hundred-and-eighty-third_spare_para FALSE
meter

_one-hundred-and-eighty-fourth_spare_par FALSE
ameter

_one-hundred-and-eighty-fifth_spare_para FALSE
meter

_one-hundred-and-eighty-sixth_spare_para FALSE
meter

_one-hundred-and-eighty-seventh_spare_pa FALSE
rameter

_one-hundred-and-eighty-eighth_spare_par FALSE
ameter

_one-hundred-and-eighty-ninth_spare_para FALSE
meter

_one-hundred-and-ninetieth_spare_paramet FALSE
er

_one-hundred-and-ninety-first_spare_para FALSE
meter

_one-hundred-and-ninety-second_spare_par FALSE
ameter

_one-hundred-and-ninety-third_spare_para FALSE
meter

_one-hundred-and-ninety-fourth_spare_par FALSE
ameter

_one-hundred-and-ninety-fifth_spare_para FALSE
meter

_one-hundred-and-ninety-sixth_spare_para FALSE
meter

_one-hundred-and-ninety-seventh_spare_pa FALSE
rameter

_one-hundred-and-ninety-eighth_spare_par FALSE
ameter

_one-hundred-and-ninety-ninth_spare_para FALSE
meter

_two-hundredth_spare_parameter           FALSE
_two-hundred-and-first_spare_parameter   FALSE
_two-hundred-and-second_spare_parameter  FALSE
_two-hundred-and-third_spare_parameter   FALSE
_two-hundred-and-fourth_spare_parameter  FALSE
_two-hundred-and-fifth_spare_parameter   FALSE
_two-hundred-and-sixth_spare_parameter   FALSE
_two-hundred-and-seventh_spare_parameter FALSE
_two-hundred-and-eighth_spare_parameter  FALSE
_two-hundred-and-ninth_spare_parameter   FALSE
_two-hundred-and-tenth_spare_parameter   FALSE
_two-hundred-and-eleventh_spare_paramete FALSE
r

_two-hundred-and-twelfth_spare_parameter FALSE
_two-hundred-and-thirteenth_spare_parame FALSE
ter

_two-hundred-and-fourteenth_spare_parame FALSE
ter

_two-hundred-and-fifteenth_spare_paramet FALSE
er

_two-hundred-and-sixteenth_spare_paramet FALSE
er

_two-hundred-and-seventeenth_spare_param FALSE
eter

_two-hundred-and-eighteenth_spare_parame FALSE
ter

_two-hundred-and-nineteenth_spare_parame FALSE
ter

_two-hundred-and-twentieth_spare_paramet FALSE
er

_first_spare_pdb_parameter
_second_spare_pdb_parameter
_third_spare_pdb_parameter
_fourth_spare_pdb_parameter
_fifth_spare_pdb_parameter
_sixth_spare_pdb_parameter
_seventh_spare_pdb_parameter
_eighth_spare_pdb_parameter
_ninth_spare_pdb_parameter
_tenth_spare_pdb_parameter
_eleventh_spare_pdb_parameter
_twelfth_spare_pdb_parameter
_thirteenth_spare_pdb_parameter
_fourteenth_spare_pdb_parameter
_fifteenth_spare_pdb_parameter
_sixteenth_spare_pdb_parameter
_seventeenth_spare_pdb_parameter
_eighteenth_spare_pdb_parameter
_nineteenth_spare_pdb_parameter
_twentieth_spare_pdb_parameter
_twenty-first_spare_pdb_parameter
_twenty-second_spare_pdb_parameter
_twenty-third_spare_pdb_parameter
_twenty-fourth_spare_pdb_parameter
_twenty-fifth_spare_pdb_parameter
_twenty-sixth_spare_pdb_parameter
_twenty-seventh_spare_pdb_parameter
_twenty-eighth_spare_pdb_parameter
_twenty-ninth_spare_pdb_parameter
_thirtieth_spare_pdb_parameter
_thirty-first_spare_pdb_parameter
_thirty-second_spare_pdb_parameter
_thirty-third_spare_pdb_parameter
_thirty-fourth_spare_pdb_parameter
_thirty-fifth_spare_pdb_parameter
_thirty-sixth_spare_pdb_parameter
_thirty-seventh_spare_pdb_parameter
_thirty-eighth_spare_pdb_parameter
_thirty-ninth_spare_pdb_parameter
_fortieth_spare_pdb_parameter
_forty-first_spare_pdb_parameter
_forty-second_spare_pdb_parameter
_forty-third_spare_pdb_parameter
_forty-fourth_spare_pdb_parameter
_forty-fifth_spare_pdb_parameter
_forty-sixth_spare_pdb_parameter
_forty-seventh_spare_pdb_parameter
_forty-eighth_spare_pdb_parameter
_forty-ninth_spare_pdb_parameter
_fiftieth_spare_pdb_parameter
_pdb_force_cfd                           FALSE
_disable_last_successful_login_time      FALSE
_fifty-third_spare_pdb_parameter
_fifty-fourth_spare_pdb_parameter
_fifty-fifth_spare_pdb_parameter
_fifty-sixth_spare_pdb_parameter
_fifty-seventh_spare_pdb_parameter
_fifty-eighth_spare_pdb_parameter
_fifty-ninth_spare_pdb_parameter
_sixtieth_spare_pdb_parameter
_sixty-first_spare_pdb_parameter
_sixty-second_spare_pdb_parameter
_sixty-third_spare_pdb_parameter
_sixty-fourth_spare_pdb_parameter
_sixty-fifth_spare_pdb_parameter
_sixty-sixth_spare_pdb_parameter
_sixty-seventh_spare_pdb_parameter
_sixty-eighth_spare_pdb_parameter
_sixty-ninth_spare_pdb_parameter
_seventieth_spare_pdb_parameter
_ksipc_mode                              0
_inet_cluster_interconnects
_ksipc_loopback_ips
_ksipc_service_level
_ksipc_window_size
_ksipc_cksum_level
_ksipc_common_sl
_ksipc_service_mask                      1
_ksipc_heap_extent                       1048576
_ksipc_mga_segment_size                  268435456
_ksipc_group_sz                          1024
_ksipcsnsrv
_ipc_aggr_limit_percentage               40
_ksipc_trace_bucket                      PRIVATE
_ksipc_trace_bucket_size                 IPC0:1048576-REST:8192
_ksipc_libipc_path
_ksipc_wait_flags                        0
_ksipc_spare_param1                      0
_ksipc_netintr_timeout                   ipq.KSMSQ_UDP_TRANS=30
_ksipc_spare_param3                      0
_ksipc_spare_param4                      0
_ksipc_spare_param5                      0
_ksipc_skgxp_library_path
_ksipc_skgxp_compat_library_path
_ksipc_ipclw_library_path
_ksipc_ipclw_enable_param
_ksipc_ipclw_conn_dump                   0
_ksipc_ipclw_cksum_enable                0
_ksipc_ipclw_rcvbuf_mb                   0
_ksipc_ipclw_spare_param2
_ksipc_ipclw_spare_param3
_ksipc_ipclw_spare_param4
_ksipc_ipclw_spare_param5
_ksipc_ipclw_spare_param6
_ksipc_ipclw_spare_param7
_ksipc_ipclw_spare_param8
_ksipc_aspc_enabled                      FALSE
_ksxp_send_timeout                       300
_ksxp_ping_enable                        TRUE
_ksxp_ping_polling_time                  0
_ksxp_disable_dynamic_loading            FALSE
_ksxp_disable_rolling_migration          FALSE
_skgxp_udp_use_tcb                       TRUE
_ksxp_disable_ipc_stats                  FALSE
_ksxp_max_stats_bkts                     0
_ksxp_init_stats_bkts                    0
_ksxp_stats_mem_lmt                      0
cluster_interconnects
_rm_cluster_interconnects
_ksxp_disable_clss                       0
_ksxp_dump_timeout                       20
_ksxp_diagmode                           OFF
_skgxp_reaping                           1000
_ksxp_reaping                            50
_ksxp_wait_flags                         0
_ksxp_lw_post_flags                      0
_ksxp_control_flags                      0
_skgxp_udp_hiwat_warn                    1000
_skgxp_udp_ach_reaping_time              120
_skgxp_udp_timed_wait_seconds            5
_skgxp_udp_timed_wait_buffering          1024
_skgxp_udp_keep_alive_ping_timer_secs    300
_disable_duplex_link                     TRUE
_diag_diagnostics                        TRUE
_disable_interface_checking              FALSE
_skgxp_udp_interface_detection_time_secs 60
_skgxp_udp_lmp_on                        FALSE
_skgxp_udp_lmp_mtusize                   0
_skgxp_udp_enable_dynamic_credit_mgmt    0
_skgxp_udp_ack_delay                     0
_skgxp_gen_ant_ping_misscount            3
_skgxp_gen_rpc_no_path_check_in_sec      5
_skgxp_gen_rpc_timeout_in_sec            300
_skgxp_gen_ant_off_rpc_timeout_in_sec    30
_skgxp_min_zcpy_len                      0
_skgxp_min_rpc_rcv_zcpy_len              0
_skgxp_zcpy_flags                        0
_skgxp_ctx_flags1                        0
_skgxp_ctx_flags1mask                    0
_skgxp_dynamic_protocol                  0
_skgxp_inets
_ksxp_skgxp_inets
_skgxp_ant_options
_ksxp_skgxp_ant_options
_skgxp_rgn_ports                         0
_ksxp_skgxp_ctx_flags1                   0
_ksxp_skgxp_ctx_flags1mask               0
_ksxp_skgxp_dynamic_protocol             4096
_ksxp_skgxp_rgn_ports                    0
_ksxp_dynamic_skgxp_param
_ksxp_if_config                          0
_ksxp_exa_ip_config                      0
_ksxp_ksmsq_ip_config                    0
_ksxp_compat_flags                       0
_ksxp_spare_param1
_ksxp_validate_cnh_life_cycle            0
_skgxp_spare_param1
_ksxp_skgxp_spare_param1
_skgxp_spare_param2
_ksxp_skgxp_spare_param2
_skgxp_spare_param3
_ksxp_skgxp_spare_param3
_skgxp_spare_param4
_ksxp_xrc_cm_port
_skgxp_spare_param5
_skgxpg_last_parameter                   27
_ksxp_skgxpg_last_parameter              27
_ksxp_testing                            0
_ksxp_reporting_process                  LMD0
_ksxp_unit_test_byte_transformation      FALSE
_ksxp_ipclw_enabled                      1
_ipc_config_opts_stat                    0
_ipc_config_opts_dyn                     0
_ipc_emu_aop_timeout                     0
_ksipc_efchecks                          3
_ksxp_save_sockets                       0
_ksxp_save_sockets_pattern               *
_ksxp_ipclw_ptswinsz                     8
_ksxp_poll_netintr_timeout               3600
_buffer_requests_to_drain                5
_ksmd_protect_mode                       off
_ksmd_trace                              0
_ksmg_granule_size                       16777216
file_mapping                             FALSE
_filemap_dir
_object_statistics                       TRUE
_object_stats_max_entries                3072
_datapump_conv_pga_lim                   0
_datapump_metadata_buffer_size           131072
_datapump_tabledata_buffer_size          262144
_datapump_compressbas_buffer_size        0
max_datapump_jobs_per_pdb                100
max_datapump_parallel_per_job            50
_datapump_gather_stats_on_load           FALSE
_datapump_bypass_tstz_check              FALSE
_datapump_hide_cdb_warning               FALSE
_dp_force_length_semantics               NONE
service_names                            ORA21C
__dg_broker_service_names
_enable_rlb                              TRUE
_enable_midtier_affinity                 TRUE
_midtier_affinity_cluswait_prc_threshold 6
_midtier_affinity_goodness_threshold     2000
_service_cleanup_timeout                 30
_disable_modsvc_refresh
_max_services                            8200
_kswsas_ht_log_size                      7
_ksws_java_patching                      0
_kswsas_db_svc_mapping
_kswsas_num_jp_slaves                    0
_kswsas_drain_kill_batch_size            5
_ksws_goodness_control                   1
_enable_plcmnt_pol_usage                 FALSE
_plcmnt_template_svc_name
_ksws_modsvc_call_out_enabled            FALSE
_ksws_use_placement_template_attribute   FALSE
_kswsas_close_pdb_on_lstsvc              TRUE
_ksws_fallback_to_root                   FALSE
_ksws_enable_alb                         TRUE
_ksws_alb_test_drain_timeout             300
_ksws_alb_test_selection_bias            100
_ksws_alb_test_load_percent              106
_ksws_alb_test_load_balance_frequency    300
_ksws_alb_test_delta_override            0
_ksws_alb_block_service                  FALSE
_kswsas_pdb_auto_close_timeout           600
_ksws_alb_session_age                    120
_ksws_rlb_cpu_busy_scope                 TRUE
_disable_health_check                    FALSE
threaded_execution                       FALSE
_mpmt_enabled                            FALSE
_mpmt_prefer_enabled                     TRUE
_mpmt_single_process_instance            FALSE
_mpmt_procs_per_osp                      100
_mpmt_use_fthread                        FALSE
_mpmt_fthread_mode                       0
_prespawn_enabled                        FALSE
_prespawn_min_count                      10
_prespawn_batch_count                    20
_prespawn_fg_init_count                  0
_prespawn_bg_init_count                  0
_proc_grp_enabled                        3
_proc_grp_numa_map
_spawn_diag_thresh_secs                  30
_spawn_diag_opts                         0
_sched_delay_sample_interval_ms          1000
_sched_delay_max_samples                 4
_sched_delay_sample_collection_thresh_ms 200
_sched_delay_measurement_sleep_us        1000
_sched_delay_os_tick_granularity_us      16000
_min_time_between_psp0_diag_secs         300
_NUMA_float_spawner                      FALSE
_accept_versions
_disable_rolling_patch                   0
_rolling_patchlevel
_hang_analysis_num_call_stacks           3
_local_hang_analysis_interval_secs       3
_deadlock_resolution_level               1
_deadlock_resolution_incidents_enabled   TRUE
_deadlock_resolution_incidents_always    FALSE
_deadlock_resolution_min_wait_timeout_se 60
cs

_deadlock_resolution_signal_process_thre 60
sh_secs

_heur_deadlock_resolution_secs           0
_deadlock_diagnostic_level               2
_deadlock_record_to_alert_log            TRUE
_blocking_sess_graph_cache_size
_diag_proc_enabled                       TRUE
_diag_proc_stack_capture_type            1
_diag_proc_max_time_ms                   30000
_hang_msg_checksum_enabled               TRUE
_kspol_tac_timeout                       5
_disable_12751                           FALSE
_diskmon_pipe_name
_dskm_health_check_cnt                   20
_dskm_single_instance                    FALSE
_exadata_feature_on                      FALSE
_ksz_dummy_parameter
_ksz_dummy_parameter2
_ksmb_debug                              0
_pmon_enable_dead_blkrs                  TRUE
_pmon_dead_blkrs_scan_rate_secs          3
_pmon_dead_blkrs_alive_chk_rate_secs     3
_pmon_dead_blkrs_max_cleanup_attempts    5
_pmon_dead_blkrs_max_blkrs               50
_pmon_cleanup_max_dfs                    100
_pmon_max_consec_posts                   5
_dead_process_scan_interval              60
_main_dead_process_scan_interval         0
_idle_session_scan_frequency             60
_pmon_idle_scan_interval                 60
_cleanup_timeout                         150
_cleanup_timeout_flags                   0
_pmon_min_slaves                         1
_pmon_max_slaves                         10
_pmon_slaves_arr_size                    150
_pmon_trees_per_slave                    10
_pmon_new_slave_secs                     30
_pmon_slave_stop_secs                    60
_pmon_incr_slaves                        3
_pmon_exitnfy_enabled                    FALSE
_use_platform_compression_lib            TRUE
_use_platform_encryption_lib             TRUE
_use_hybrid_encryption_mode              FALSE
_xengem_diagmode                         OFF
_xengem_devname                          DEFAULT
_xengem_enabled                          TRUE
_ksmsq_hintmaxinst                       1024
_ksmsq_hintmaxproc                       300
_ksmsq_conn_per_epoch                    0
_lthread_cleanup_intv_secs               1
_lthread_enabled                         TRUE
_lthread_debug                           FALSE
_lthread_max_spawn_time_csecs            12000
_lthread_spawn_check_intv_ms             10
_lthread_clnup_pmon_softkill_wait_secs   1
_lthread_clnup_spawner_sk_wait_secs      30
_lthread_clnup_hk_wait_secs              3
_lthread_step_debugging                  FALSE
_lthread_idle_timeout_secs               600
clonedb_dir
_maxrpop_files_inst                      4
_maxrpop_instances                       8
_use_large_pages_for_mga                 FALSE
_use_fallocate_for_mga                   FALSE
_mga_large_page_path
_ksgl_max_dyn_latches                    1024
_ksgl_ltchs_held_ctxt                    8
_ksrma_enabled                           AUTO
_ksrma_gsm_base_addr
_gsm_pool_size                           134217728
enable_dnfs_dispatcher                   FALSE
_force_cloud_on                          FALSE
_cloud_service_sim                       0
_oracle_employee_testing                 FALSE
_skip_oradism_check                      FALSE
_enable_per_container_acl                FALSE
_quarantine_enabled                      TRUE
_quarantine_max_objs                     10000
_quarantine_max_mem                      1
_quarantine_per_hour                     60
_test_xmem_alloc_size                    0
_use_platform_hash_function              TRUE
_sess_template_enabled                   TRUE
_sess_template_spares                    TRUE
_sess_template_purge_time_mins           60
_sess_template_max_cache_size            5
_sess_template_all_overflow              FALSE
_sess_template_cache_buckets             128
_sess_template_new_lists                 16
__sess_template_test_attrs               FALSE
_sess_sign_num_pools                     16
_dbnest_enable                           NONE
dbnest_enable                            NONE
_instance_dbnest_name
_dbnest_pdb_scm_level                    STRICT1
_dbnest_pdb_fs_type                      DEFAULT
_dbnest_pdb_fs_conf
dbnest_pdb_fs_conf
_dbnest_pdb_scm_conf
_dbnest_stage_dir
_dbnest_resource_opts                    0
_dbnest_skip_fed_root                    TRUE
_capability_simulate
_cstats_enabled                          FALSE
_enable_nvm_dispatcher                   0
_nvm_dispatchers                         3
_nvm_dispatcher_bind_policy              1
_nvmeof_zcopy_enable                     FALSE
kafka_config_file
_enable_tcpinfo_statistics               238
_tcpinfo_statistics_save_atexit          FALSE
_connect_string_settings_after_logon_tri 0
ggers

_connect_string_settings_unalterable     0
_connstr_test_param                      0
_workload_attributes
_ut_fast_lrg_prediction                  FALSE
_hstpr_prediction_interval               10080
_hstpr_use_periodic_prediction           TRUE
_hstpr_use_linear_prediction             TRUE
_session_save_prediction                 FALSE
_process_save_prediction                 FALSE
_session_max_pred_increase               20000
_process_max_pred_increase               20000
_actgrp_spawn_offload                    TRUE
__unified_pga_pool_size                  0
_unified_pga_pool_size                   0
_unified_pga_gran_free_timeout           3000
_unified_pga_gran_leak_timeout           180000
_unified_pga_block_size                  262144
_unified_pga_list_count                  16
_enable_unified_memory                   FALSE
_kspmxs_flush_cache_size                 1
_kspmxs_max_regions                      64
_kspmxs_usid_map_size                    1024
_kspmxs_latch_usid_map_size              256
_kspmxs_wait_buckets                     1024
_kspmxs_max_waits                        4
_kspmxs_upgrade_mutexes                  64
_kspmxs_latch_freelists                  2
_kspmxs_txn_freelists                    32
_kspmx_enabled                           FALSE
__wait_test_param                        0
__latch_test_param                       0
_diag_daemon                             TRUE
_dump_system_state_scope                 local
_dump_trace_scope                        global
_dump_interval_limit                     120
_dump_max_limit                          5
_diag_dump_timeout                       30
_diag_dump_request_debug_level           1
_diag_crashdump_level                    10
_full_diag_on_rim                        FALSE
_diag_large_packets                      TRUE
_hang_detection_enabled                  TRUE
_hang_deadlock_resolution_enabled        TRUE
_hang_cross_boundary_hang_detection_enab TRUE
led

_hang_cross_cluster_hang_detection_enabl TRUE
ed

_hang_asm_hang_resolution_enabled        FALSE
_hang_resolution_partial_hangs_on_asm_en TRUE
abled

_hang_px_resolution_on_asm_enabled       TRUE
_hang_application_hang_resolution_enable FALSE
d

_hang_mark_some_idle_waits_terminal      FALSE
_hang_singleton_detection_rw_enabled     FALSE
_hang_singleton_resolution_rw_enabled    FALSE
_hang_trace_interval                     32
_hang_root_ha_phase_trigger_time         300
_hang_hung_session_ewarn_percent         34
_hang_max_session_hang_time              96
_hang_low_wait_time_cutoff               6
_hang_hang_blocked_session_delta_percent 20
_threshold

_hang_blocked_session_percent_threshold  20
_hang_high_session_count_update_hb_thres 2000
hold

_hang_fast_tracked_hang_verification_int 10
erval

_hang_ft_min_degrading_samples_percent_t 60
hreshold

_hang_resolution_scope                   INSTANCE
_hang_allow_resolution_on_single_nonrac  DBRM
_hang_max_instance_allow_node_eviction   1
_hang_max_local_db_clients_allowed       0
_hang_resolution_policy                  HIGH
_hang_resolution_confidence_promotion    FALSE
_hang_resolution_global_hang_confidence_ FALSE
promotion

_hang_resolution_allow_archiving_issue_t TRUE
ermination

_hang_resolution_promote_process_termina TRUE
tion

_hang_promote_process_termination_interv 70
al

_hang_resolution_percent_hung_sessions_t 300
hreshold

_hang_resolution_percent_hung_sessions_t 5000
hreshold2

_hang_signature_list_match_output_freque 10
ncy

_hang_hang_analyze_output_hang_chains    TRUE
_hang_short_stacks_output_enabled        TRUE
_hm_analysis_oradebug_sys_dump_level     0
_global_hang_analysis_interval_secs      10
_hang_verification_interval              46
_hang_sess_enq_wait_resltn_trig_time     0
_hang_sess_enq_wait_blocked_session_thre 5
shold

_hang_intersecting_chains_scanning_enabl TRUE
ed

_hang_log_verified_hangs_to_alert        FALSE
_hang_log_io_hung_sessions_to_alert      FALSE
_hang_log_important_hangs_to_alert       TRUE
_hang_appl_issue_session_threshold       0
_hang_ignored_hangs_interval             300
_hang_ignored_hang_count                 1
_hang_ignore_hngmtrc_interval            150
_hang_hs_hang_metrics_enabled            TRUE
_hang_metrics_recent_bitmap_threshold    50
_hang_metrics_older_bitmap_threshold     25
_hang_monitor_archiving_related_hang_int 300
erval

_hang_hiload_promoted_ignored_hang_count 2
_hang_delay_resolution_for_libcache      TRUE
_hang_terminate_session_replay_enabled   TRUE
_hang_lws_file_count                     5
_hang_lws_file_space_limit               100000000
_hang_base_file_count                    5
_hang_base_file_space_limit              100000000
_hang_running_in_lrg                     FALSE
_hang_analyze_elapsed_time_limit         1800
_hang_bool_spare1                        TRUE
_hang_bool_spare2                        TRUE
_hang_bool_spare3                        TRUE
_hang_int_spare1                         0
_hang_int_spare2                         0
_hang_int_spare3                         0
_hang_hiprior_session_attribute_list
_hang_enable_processstate                TRUE
_diag_xm_enabled                         FALSE
_hm_xm_enabled                           TRUE
_trace_navigation_scope                  global
_max_protocol_support                    10000
_lm_check_ges_resource                   0
_lm_optmode_switch                       0
_lm_resource_recycle_cnt                 32
_lm_hash_control                         5
_lm_lms                                  0
gcs_server_processes                     0
_lm_dynamic_lms                          FALSE
_lm_max_lms                              0
_ges_server_processes                    1
_lm_activate_lms_threshold               100
_lm_lmd_waittime                         8
_lm_lms_waittime                         3
_lm_procs                                1088
_lm_lms_priority_dynamic                 TRUE
_lm_lms_rt_threshold
_lm_lms_opt_priority                     TRUE
_lm_lms_priority_check_frequency         60000
_lm_db_rank                              6
_lm_db_ranks
_lm_ress                                 6000
_lm_locks                                12000
_lm_master_weight                        1
active_instance_count
_active_instance_count                   1024
_active_standby_fast_reconfiguration     TRUE
_lm_enq_rcfg                             TRUE
_lm_asm_enq_hashing                      TRUE
_lm_xids                                 1196
_lm_res_part                             128
_lm_drm_window                           0
_lm_drm_max_requests                     100
_lm_drm_xlatch                           0
_lm_drm_disable                          0
_lm_drm_disable_kjfc                     FALSE
_lm_contiguous_res_count                 128
_lm_num_pt_buckets                       8192
_lm_num_pt_latches                       128
_lm_node_join_opt                        FALSE
_lm_no_sync                              TRUE
_lm_non_fault_tolerant                   FALSE
_lm_cache_res_cleanup                    25
_lm_cache_allocated_res_ratio            50
_lm_cache_res_skip_cleanup               20
_lm_cache_res_cleanup_tries              10
_lm_cache_res_type                       TMHWHVDI
_lm_cache_enqueue
_lm_reloc_use_mhint                      FALSE
_lm_cache_lvl0_cleanup                   0
_lm_cache_res_options                    0
_ogms_home
_lm_sync_timeout                         163
_lm_ticket_active_sendback               50
_lm_rcfg_timeout                         489
_lm_rcfg_kjcdump_time                    60
_lm_enq_lock_freelist
_lm_enqueue_freelist                     3
_lm_dd_interval                          10
_lm_dd_scan_interval                     5
_lm_dd_search_cnt                        3
_lm_dd_max_search_time                   180
_lm_dd_maxdump                           50
_lm_dd_ignore_nodd                       FALSE
_lm_enqueue_blocker_dump_timeout         120
_lm_enqueue_blocker_dump_timeout_cnt     30
_lm_enqueue_blocker_kill_timeout         0
_dlmtrace
_lm_tx_delta                             16
_lm_proc_freeze_timeout                  70
_lm_deferred_msg_timeout                 163
_lm_use_new_defmsgtmo_action             TRUE
_lm_dump_null_lock                       FALSE
_lm_file_affinity
_lm_file_read_mostly
_lm_enable_aff_benefit_stats             FALSE
_lm_num_bnft_stats_buckets               1
_lm_drm_banned_objs
_lm_drm_max_banned_objs                  235
_lm_da_win_enable                        TRUE
_lm_da_window                            1
_lm_async_da                             FALSE
_lm_da_window_interval                   0
_lm_share_lock_opt                       TRUE
_lm_share_lock_pdbisolation              TRUE
_lm_enq_iso_enabled                      TRUE
_lm_res_hash_bucket                      0
_lm_res_tm_hash_bucket                   0
_ges_diagnostics                         TRUE
_fair_remote_cvt                         FALSE
_lm_rcvr_hang_check_frequency            20
_lm_rcvr_hang_allow_time                 70
_lm_rcvr_hang_kill                       TRUE
_lm_rcvr_hang_check_system_load          TRUE
_lm_rcvr_hang_systemstate_dump_level     0
_lm_rcvr_hang_cfio_kill                  FALSE
_lm_lmon_nowait_latch                    TRUE
_ges_dd_debug                            1
_lm_global_posts                         TRUE
_rcfg_parallel_replay                    TRUE
_parallel_replay_msg_limit               4000
_rcfg_parallel_fixwrite                  TRUE
_parallel_fixwrite_bucket                1000
_rcfg_parallel_verify                    FALSE
_rcfg_disable_verify                     TRUE
_drm_parallel_freeze                     TRUE
_dump_rcvr_ipc                           TRUE
_ges_health_check                        0
_kill_enqueue_blocker                    2
_lm_psrcfg                               TRUE
_lm_single_inst_affinity_lock            FALSE
_lm_preregister_css_restype              CF
_inquiry_retry_interval                  3
_lm_drm_object_scan                      TRUE
_lm_spare_threads                        0
_lm_spare_undo                           0
_lm_rcvinst                              TRUE
_lm_use_gcr                              TRUE
_lm_use_tx_tsn                           TRUE
_lm_local_hp_enq                         TRUE
_lm_broadcast_res                        enable_broadcast
_gcs_testing                             0
_gcs_pkey_history                        16384
_lm_drm_we_size                          2000
_lm_drm_we_interval                      60
_read_mostly_instance                    FALSE
_read_mostly_instance_qa_control         0
_read_mostly_slave_timeout               20
_read_only_slave_timeout                 30
_read_mostly_enable_logon                FALSE
_ges_designated_master                   TRUE
_lm_big_cluster_optimizations            TRUE
_ges_lmd_mapping                         *
_ges_hash_groups                         *
_ges_default_lmds                        *
_ges_nres_divide                         0
_lm_lms_spin                             FALSE
_lm_freeze_kill_time                     30
_lm_no_lh_check                          FALSE
_lm_drmopt12                             56
_lm_drm_filters                          3
_lm_drm_duration_limit
_lm_drm_duration_limit_type              2
_lm_fdrm_stats                           FALSE
_lm_drm_filter_history_window
_lm_drm_filter_history_window_type       2
_lm_lhupd_interval                       5
_lm_high_load_threshold                  5
_lm_high_load_sysload_percentage         90
_lm_low_load_percentage                  75
_lm_drm_hiload_percentage                200
_lm_drm_lowload_percentage               200
_lm_drm_min_interval                     600
_lm_drm_batch_time                       10
_lm_inherited_max_requests               100
_lm_adrm_options                         3
_lm_adrm_scan_timeout                    50
_lm_adrm_interval                        300
_lm_adrm_time_out                        120
_lm_enqueue_timeout                      360
_lm_resend_open_convert_timeout          30
_lm_process_lock_q_scan_limit            100
_ges_direct_free                         FALSE
_ges_resource_memory_opt                 4
_ges_gather_res_reuse_stats              FALSE
_ges_direct_free_res_type
_lm_domain_hash_buckets                  64
_ges_fggl                                TRUE
_ges_freeable_res_chunk_free             TRUE
_ges_freeable_res_chunk_free_interval    180
_lm_share_lock_restype
_lm_nonisolated_restype                  TOTTUL
_ges_dump_open_locks                     FALSE
_lm_exadata_fence_type                   TRUE
_rond_test_mode                          0
instance_mode                            READ-WRITE
_lm_pdb_domains_enable                   7
_lm_singleton_pdb_opt                    TRUE
_lm_uid_default_lookup_value             TRUE
_lm_enable_translation                   FALSE
_lm_chk_inv_domenq_ops                   TRUE
_lm_rm_object_bypass                     TRUE
_cluster_instances_number                4
_reconfiguration_opt_level               237
_lm_lazy_recovery_member_timeout         300
_lm_lazy_domain_timeout                  600
_enqueue_scan_interval                   0
_parallel_lmd_reconfig                   1
_rac_dbtype_reset                        FALSE
_lm_recovery_set                         1
_reader_farm_isolation_enable            FALSE
_reader_farm_isolation_time_threshold    200
_lm_wait_for_hub_rcv_timeout             300000
_lm_pdb_wait_all_gone                    FALSE
_lm_rcvinst_sga_threshold                85
_lm_rcvinst_atp_opt                      TRUE
_lm_new_esm                              1
_lm_ges_rht_mem_pct                      15
_lm_ges_rht_alloc_size                   4096
_lm_gcs_rht_alloc_size                   4096
_lm_pdb_weight_opts                      27
_lm_recovery_pdbw_reduction              4
_ges_optimizations                       3
_adg_distributed_lockmaster              FALSE
_ges_mseq_demo                           0
__maintenance_is_planned                 0
_defer_while_patching                    0
_lm_dynamic_sga_target
_lm_default_failure_action               0
_lm_enable_pdb_abort                     0
_lm_better_ddvictim                      TRUE
_kjdd_call_stack_dump_enabled            FALSE
_kjdd_wfg_dump_cntrl                     0
_dd_validate_remote_locks                TRUE
_omni_enqueue_enable                     1
_lm_omni_ack_timeout                     60
_dlm_stats_collect                       1
_dlm_stats_collect_mode                  6
_dlm_stats_collect_slot_interval         60
_dlm_stats_collect_du_limit              3000
_dlm_cache_warmup_slaves                 2
_lm_msg_batch_size                       0
_lm_tickets                              1000
_lm_ticket_min                           50
_lm_msg_cleanup_interval                 3000
_lm_throttle_time_interval               60
_lm_idle_connection_check                TRUE
_lm_idle_connection_load_check           TRUE
_lm_idle_connection_check_interval       140
_lm_idle_connection_kill                 TRUE
_lm_idle_connection_kill_max_skips       1
_lm_idle_connection_instance_check_callo TRUE
ut

_lm_idle_connection_quorum_threshold     50
_lm_idle_connection_action               kill
_lm_send_mode                            auto
_lm_postevent_buffer_size                256
_lm_msg_pool_dump_threshold              20000
_lm_msg_pool_user_callstack_dump         FALSE
_lm_num_msg_pools_per_type               1
_lm_ticket_check_inject                  FALSE
_lm_ticket_low_limit_warning             10
_lm_kill_fg_on_timeout                   TRUE
_lm_idle_connection_max_ignore_kill_coun 2
t

_lm_send_queue_length                    5000
_lm_send_queue_batching                  TRUE
_lm_process_batching                     TRUE
_lm_sq_batch_factor                      2
_lm_sq_batch_type                        auto
_lm_sq_batch_waittick                    3
_lm_sendproxy_reserve                    25
_lm_checksum_batch_msg                   0
_lm_batch_compression_threshold          0
_lm_compression_scheme                   zlib
_lm_validate_pbatch                      FALSE
_lm_watchpoint_maximum                   3
_lm_watchpoint_timeout                   3600
_lm_free_queue_threshold                 0
_lm_mp_avail_queue_threshold             0
_lm_mp_bulk_mbuf_free                    FALSE
_lm_mp_latch_trigger                     4000
_lm_mp_latch_trigger_soft                40000
_lm_mp_expand_reg_pool_percent           5
_lm_mp_expand_big_pool_percent           1
_lm_mp_share_lms_pools                   TRUE
_lm_mp_small_lms_pools                   TRUE
_lm_mp_additional_reg_buffers            20
_lm_mp_additional_big_buffers            20
_lm_wait_pending_send_queue              TRUE
_lm_hashtable_bkt_low                    3
_lm_hashtable_bkt_high                   5
_lm_hashtable_bkt_thr                    70
_lm_comm_tkts_adaptive                   TRUE
_lm_comm_tkts_calc_period_length         100000
_lm_comm_tkts_max_periods                10
_lm_comm_tkts_min_increase_wait          10
_lm_comm_tkts_min_decrease_wait          120
_lm_comm_tkts_nullreq_threshold          1
_lm_comm_tkts_mult_factor                1
_lm_comm_tkts_sub_factor                 10
_lm_comm_tkts_max_add                    5
_lm_comm_tkts_adpt_rsv                   1
_lm_comm_msgq_fixed_buffers              FALSE
_lm_comm_msgq_copy_buffers               FALSE
_lm_comm_msgq_bufr_multiple              8
_lm_comm_channel                         msgq
_lm_comm_msgq_busywait                   0
_lm_comm_reap_count                      1
_lm_comm_slow_op_stat_dump_threshold     5
_lm_comm_slow_op_spx_loop_threshold      30000
_lm_comm_slow_op_loop_threshold          15
_lm_comm_rcv_msg_history_slots           50
_lm_comm_sync_seq_on_send_failure        TRUE
_lm_tkt_leak_check_count                 5
_lm_tkt_leak_check_seconds               300
_lm_comm_send_proxy_nr_delay             10
_lm_comm_send_proxy_tkt_return           TRUE
_lm_gl_hash_scheme                       1
_abort_recovery_on_join                  FALSE
_send_ast_to_foreground                  AUTO
_reliable_block_sends                    TRUE
_blocks_per_cache_server                 16
_object_reuse_bast                       2
_cluster_flash_cache_slave_file
_cluster_flash_cache_slave_size          0
__persistent_cl2_slave_size              0
_gcs_trace_bucket                        FALSE
_gcs_trace_bucket_size                   LMS:1048576-RMV:1048576-CRV:10
                                         48576-DBW:524288

_lms_rollbacks                           1000
_gcs_enable_private_iterator             TRUE
_rf_blocks_per_entity                    5
_gcs_cluster_flash_cache_persistency     FALSE
_gcs_track_reliable_block_sends          FALSE
_gcs_freelists_alloc_percent             0
_gcs_current_rdma                        1
_gcs_current_rdma_grant_global           TRUE
_gcs_spin_check_threshold                4096
_gcs_spin_check_time_interval            300
_send_close_with_block                   TRUE
_gcs_fast_reconfig                       TRUE
_cr_grant_global_role                    TRUE
_cr_grant_local_role                     AUTO
_cr_grant_only                           FALSE
_skip_assume_msg                         TRUE
_gcs_resources                           0
_gcs_latches                             128
_gcs_process_in_recovery                 TRUE
_scatter_gcs_resources                   FALSE
_gcs_res_per_bucket                      4
_gcs_res_hash_buckets
_gcs_reserved_resources                  400
_gcs_cr_master_ping_remote               TRUE
_cr_multiblock_grant_only                FALSE
_gcs_partial_open_mode                   1
_gcs_dynamic_sga                         FALSE
_gcs_integrity_checks                    1
_gcs_dynamic_sga_preference              0
_gcs_shadow_locks                        0
_scatter_gcs_shadows                     FALSE
_gcs_disable_remote_handles              FALSE
_gcs_disable_skip_close_remastering      FALSE
_gcs_min_slaves                          0
_gcs_min_cr_slaves                       0
_gcs_dynamic_slaves                      TRUE
_gcs_reserved_shadows                    400
_gcs_crslave_longq_cnt                   2000
_gcs_crslave_longq_us                    1000
_gcs_crslave_check_time                  10
_gcs_recoverable_asserts                 0
_gcs_lsr_frequency                       60
_gcs_disable_imc_preallocation           FALSE
_gcs_verify_antilock                     FALSE
_side_channel_batch_size                 240
_side_channel_batch_timeout              6
_side_channel_batch_timeout_ms           500
_broadcast_scn_wait_timeout              10
_broadcast_scn_mode                      1
_hb_redo_msg_interval                    100
_master_direct_sends                     63
_read_mostly_lock_mitigation             TRUE
_age_block_batch_timeout_ms              1000
_nameservice_consistency_check           TRUE
_nameservice_request_batching            TRUE
_cgs_send_timeout                        300
_cgs_ticket_sendback                     50
_cgs_msg_batch_size                      4096
_cgs_msg_batching                        TRUE
_cgs_comm_readiness_check                1
_imr_active                              TRUE
_imr_max_reconfig_delay                  75
_imr_splitbrain_res_wait                 0
_imr_disk_voting_interval                3
_imr_systemload_check                    TRUE
_imr_device_type                         controlfile
_imr_highload_threshold
_imr_evicted_member_kill                 TRUE
_imr_evicted_member_kill_wait            20
_imr_avoid_double_voting                 TRUE
_imr_diskvote_implementation             auto
_imr_extra_reconfig_wait                 10
_imr_controlfile_access_wait_time        10
_imr_rr_holder_kill_time                 300
_imr_check_css_incarnation_number        TRUE
_imr_rim_mount_device                    FALSE
_imr_largest_hub_membership              TRUE
_imr_non_blocking_device_driver          TRUE
_imr_dd_slave_wait_time                  30
_imr_mount_retry_wait_time               20
_imr_remount_retry_wait_time             60
_imr_slave_debug                         0
_imr1_slave                              1
_cluster_library                         clss
_cgs_reconfig_timeout                    0
_cgs_node_kill_escalation                TRUE
_cgs_node_kill_escalation_wait           0
_cgs_zombie_member_kill_wait             20
_cgs_reconfig_extra_wait                 3
_cgs_health_check_in_reconfig            FALSE
_cgs_memberkill_from_rim_instance        FALSE
_cgs_os_level_connection_check           1
_cgs_os_level_connection_reqno           0
_cgs_os_level_connection_dynamicthread   TRUE
_cgs_combine_css_events                  31
_cgs_publish_netinfo_collect_event_haip  TRUE
_cgs_publish_netinfo_collect_event_chm   rcfg-half-timeout,rcfg-timeout
                                         ,rcfg-done,idleconn-half-timeo
                                         ut,idleconn-timeout-imr,idleco
                                         nn-cln,rcfg-begin,rcfg-pngchkd
                                         one,rcfg-memchg

_cgs_publish_netinfo_collect_event_chmjf TRUE
_cgs_publish_netinfo_collect_event_chmjf 0
_batchsz

_cgs_clscevents_dumpinterval             600
_cgs_query_net_interface                 SCLSI
_cgs_tickets                             1000
_cgs_dball_group_registration            local
_cgs_dbgroup_poll_time                   600
_cgs_allgroup_poll_time                  20000
_cgs_big_group_enabled                   FALSE
_cgs_support_rim_disc                    TRUE
_ipc_switch_reconfig_needed              FALSE
_lm_dynamic_load                         TRUE
_lm_rm_slaves                            1
_lm_sp_slaves                            0
_lm_sp_slave_mode                        0
_lm_wrkr_slaves                          0
_lm_wrkr_mode                            0
_lm_timed_statistics_level               0
_shutdown_sync_enable                    TRUE
_lm_lms_no_yield                         FALSE
_lm_max_lms_block_time                   5
_lm_sndq_flush_int                       5
_lm_watchpoint_kjmddp
_rmv_dynamic_priority                    TRUE
_lm_use_us_timer                         FALSE
_lm_receiver_type                        0
_notify_crs                              FALSE
_crs_2phase                              bypass
_kill_diagnostics_timeout                60
_ges_diagnostics_asm_dump_level          11
_ges_num_blockers_to_kill                1
_ges_vbfreelists                         0
_lm_hb_callstack_collect_time            5
_lm_hb_callstack_collect_time_long       60
_lm_hb_disable_check_list                ARC*
_lm_hb_enable_acl_check                  TRUE
_lm_hb_acceptable_hang_condition         default
_lm_hb_maximum_hang_report_count         20
_lm_hb_exponential_hang_time_factor      2
_lm_hb_cfio_timeout                      70
_lm_hb_lgio_timeout                      70
_lm_hb_per_proc_timeout                  default
_lm_hb_per_proc_behavior                 default
_lm_hb_timeout_extension
_lm_hwc_disabled                         FALSE
_lmhb_procstate_dump_runtime_limit       60
_lmhb_procstate_dump_cputime_limit       60
_lmhb_max_dynamic_hb                     10
_hang_statistics_collection_interval     15
_hang_statistics_collection_ma_alpha     30
_hang_statistics_high_io_percentage_thre 25
shold

_gcr_enable_high_cpu_kill                FALSE
_gcr_enable_high_memory_kill             FALSE
_gcr_enable_high_cpu_rm                  TRUE
_gcr_enable_high_cpu_rt                  TRUE
_gcr_high_cpu_threshold                  10
_gcr_high_memory_threshold               10
_gcr_min_free_memory_hard_limit          1073741824
_gcr_cpu_min_hard_limit                  0
_gcr_cpu_min_free                        10
_gcr_mem_min_free                        10
_gcr_use_css                             TRUE
_gcr_css_use_2group_lock                 TRUE
_gcr_css_group_try_lock_delay
_gcr_css_group_query_boost
_gcr_css_group_update_interval
_gcr_css_group_update2_interval
_gcr_css_group_large
_gcr_tick
_gcr_enable_statistical_cpu_check        TRUE
_gcr_enable_new_drm_check                TRUE
_gcr_max_rt_procs
_gcr_enable_kill_inst_diags              FALSE
_increase_lms_process                    0
_enable_increase_lms_process             TRUE
_reset_increase_lms_process              TRUE
_increase_lmd_process                    0
_reset_increase_lmd_process              TRUE
_size_of_log_table                       100
_gcr_dump_cpu_consumers                  FALSE
_gcr_cpu_consumer_dump_level             0
_gcr_high_lfsci_threshold                1800
_gcr_high_fbwt_threshold                 300
_gcr_enable_ktfbue_gather_stats          TRUE
_gcr_enable_async_slaves                 TRUE
_gcr_high_cpwt_threshold                 30
_gcr_enable_pdb_abort                    FALSE
_gcr_high_hashlist_latch_wait_misses     10000
_gcr_high_hashlist_latch_nowait_misses   10000
_gcr_ges_longchain_mult                  5
_gcr_ges_cachedres_mult                  20
_gcr_disabled_metrics
_gcr_disabled_actions
_kjac_force_outcome_current_session      FALSE
_kjac_direct_path_enabled                TRUE
_lm_rac_spare_p1                         0
_lm_rac_spare_p2                         0
_lm_rac_spare_p3                         0
_lm_rac_spare_p4                         0
_lm_rac_spare_p5                         0
_lm_rac_spare_p6
_lm_rac_spare_p7
_lm_rac_spare_p8
_lm_rac_spare_p9
_lm_rac_spare_p10
_lm_rac_spare_dp1                        0
_lm_rac_spare_dp2                        0
_lm_rac_spare_dp3                        0
_lm_rac_spare_dp4                        0
_lm_rac_spare_dp5                        0
_lm_rac_spare_dp6
_lm_rac_spare_dp7
_lm_rac_spare_dp8
_lm_rac_spare_dp9
_lm_rac_spare_dp10
_lm_rac_spare_p11                        0
_lm_rac_spare_p12                        0
_lm_rac_spare_p13                        0
_lm_rac_spare_p14
_lm_rac_spare_p15
_lm_rac_spare_p16
_ka_enabled                              FALSE
_ka_mode                                 0
_ka_locks_per_sector                     12
_ka_msg_reap_count                       40
_ka_compatibility_requirement            all
_ka_allow_reenable                       FALSE
_ka_pbatch_messages                      TRUE
_ka_doorbell                             0
_ka_scn_enabled                          FALSE
_ka_scn_accel_shrmem                     TRUE
_ka_scn_use_ka_msgs                      TRUE
_ka_grant_policy                         AUTO
_ka_msg_wait_count                       20
_ka_lma_msg_wait_count                   100
_ka_max_wait_delay                       1000
_ka_lma_wait_time                        200
_kjlton                                  FALSE
_kjltmaxgt                               1000
_kjltmaxht                               1000
_ipddb_enable                            FALSE
_gcs_cluster_flash_cache_mode            0
_gcs_flash_cache_mode                    0
_node_instcnt_average_interval           1800
_node_instcnt_sample_frequency           60
_node_instcnt_update_frequency           300
_high_priority_node_instcnt_cap          FALSE
sga_target                               2516582400
__sga_target                             2516582400
memory_target                            0
memory_max_target                        0
_disable_streams_pool_auto_tuning        FALSE
_sga_shrink_allow                        FALSE
_sga_grow_batch_size                     2147483648
_memory_management_tracing               0
_memory_mgmt_immreq_timeout              150
_memory_checkinuse_timeintv              30
_memory_mgmt_fail_immreq                 FALSE
_memory_sanity_check                     0
_init_granule_interval                   10
_shared_pool_max_size                    0
_shared_pool_minsize_on                  FALSE
_streams_pool_max_size                   0
_simulate_mem_transfer                   FALSE
_memory_nocancel_defsgareq               FALSE
_memory_imm_mode_without_autosga         TRUE
_max_defer_gran_xfer_atonce              10
_asm_allow_small_memory_target           FALSE
_memory_broker_stat_interval             30
_automemory_broker_interval              3
_memory_broker_shrink_heaps              15
_memory_broker_shrink_java_heaps         900
_memory_broker_shrink_streams_pool       900
_memory_broker_shrink_timeout            60000000
_memory_broker_log_stat_entries          5
_memory_initial_sga_split_perc           60
_memory_broker_marginal_utility_sp       7
_memory_broker_marginal_utility_bc       12
_memory_broker_sga_shrink_chunked        TRUE
_memory_broker_sga_shrink_chunk_size     20
_memory_broker_sga_grow_split            TRUE
_memory_broker_sga_grow_splitif_size     20
_dump_scn_increment_stack
_big_scn_test_mode                       2
control_files                            /oracle/oradata/ORA21C/control
                                         01.ctl, /oracle/oradata/ORA21C
                                         /control02.ctl

_controlfile_enqueue_timeout             900
_controlfile_enqueue_holding_time        120
_controlfile_enqueue_holding_time_tracki 0
ng_size

_controlfile_update_check                OFF
_controlfile_enqueue_dump                FALSE
_controlfile_block_size                  0
_controlfile_section_init_size
_controlfile_section_max_expand
db_file_name_convert
_dgpdb_file_name_convert
log_file_name_convert
control_file_record_keep_time            7
_kill_controlfile_enqueue_blocker        TRUE
_controlfile_backup_copy_check           TRUE
_controlfile_cell_flash_caching          3
_controlfile_split_brain_check           FALSE
_controlfile_auto_convert_behaviour      AUTO_CONVERT
_controlfile_verify_on_mount             FALSE
db_block_buffers                         0
_db_block_buffers                        229086
_db_block_cache_protect                  false
_db_block_cache_protect_internal         0
db_block_checksum                        TYPICAL
db_ultra_safe                            OFF
db_block_size                            8192
_dbwr_tracing                            0
_tsenc_tracing                           0
_disable_multiple_block_sizes            FALSE
_db_fast_obj_truncate                    TRUE
_db_fast_obj_ckpt                        TRUE
_enable_obj_queues                       TRUE
_db_obj_enable_ksr                       TRUE
_small_table_threshold                   4581
_pdb_small_table_threshold               20
_pmem_small_table_threshold              20
_very_large_object_threshold             500
_dbwr_async_io                           TRUE
_recovery_percentage                     50
_db_lost_write_checking                  2
_db_lost_write_tracing                   FALSE
__db_cache_size                          1828716544
db_cache_size                            0
_db_block_numa                           1
db_2k_cache_size                         0
db_4k_cache_size                         0
db_8k_cache_size                         0
db_16k_cache_size                        0
db_32k_cache_size                        0
db_keep_cache_size                       0
db_recycle_cache_size                    0
memoptimize_pool_size                    0
__shared_io_pool_size                    134217728
_shared_io_pool_size                     0
_db_hot_block_tracking                   FALSE
_db_block_bad_write_check                FALSE
db_big_table_cache_percent_target        0
_db_full_db_cache_diff_pct               5
_db_cache_xmem_size                      0
__db_cache_xmem_size_metadata            0
_db_keep_cache_xmem_size                 0
__db_keep_cache_xmem_size_metadata       0
_db_recycle_cache_xmem_size              0
__db_recycle_cache_xmem_size_metadata    0
_db_2k_cache_xmem_size                   0
__db_2k_cache_xmem_size_metadata         0
_db_4k_cache_xmem_size                   0
__db_4k_cache_xmem_size_metadata         0
_db_8k_cache_xmem_size                   0
__db_8k_cache_xmem_size_metadata         0
_db_16k_cache_xmem_size                  0
__db_16k_cache_xmem_size_metadata        0
_db_32k_cache_xmem_size                  0
__db_32k_cache_xmem_size_metadata        0
_memoptimize_xmem_pool_size              0
__memoptimize_xmem_pool_size_metadata    0
_db_pmem_direct_map_size                 0
__db_pmem_direct_map_size_metadata       0
encrypt_new_tablespaces                  CLOUD_ONLY
tablespace_encryption_default_algorithm  AES128
_disable_system_tablespaces_enc_enforcem FALSE
ent

_cell_object_expiration_hours            24
_db_block_lru_latches                    9
_db_percpu_create_cachesize              2
_db_initial_cachesize_create_mb          256
_db_num_evict_waitevents                 16384
_db_todefer_cache_create                 TRUE
_db_minimum_auxsize_percent              0
_db_imoltp_hashidx_force_nonctg          0
_kcb_reused_max                          16384
_db_nvm_promotion_deferred_tchcnt        195
db_writer_processes                      1
_db_block_known_clean_pct                2
_db_block_max_scan_pct                   40
_db_large_dirty_queue                    25
_db_writer_max_writes                    0
_db_writer_chunk_writes                  0
_db_block_med_priority_batch_size        0
_db_block_hi_priority_batch_size         0
_db_writer_histogram_statistics          FALSE
_dbwr_scan_interval                      300
_db_writer_flush_imu                     TRUE
_db_writer_coalesce_write_limit          131072
_db_writer_coalesce_encrypted_buffers    TRUE
_db_writer_coalesce_area_size            4194304
_db_writer_nomemcopy_coalesce            FALSE
_selftune_checkpoint_write_pct           3
_db_writer_verify_writes                 FALSE
_dbwr_stall_write_detection_interval     900
_dbwr_flashlock_shrink_limit             0
_log_switch_tracing_timeout              200
_log_switch_tracing_iterations           5
_enable_dbwr_auto_tracing                0
_dbwr_nowrite_assert_interval            7200
_dbwr_nwp_assert_interval                1800
_remessage_dbwrs                         0
_db_cache_pmemp_len                      10000
_db_cache_pmem_confidence_try            0
_db_cache_pmem_touch_rate_compare_per    95
_db_cache_pmem_promotion_touch_rate_thre 30
shold_time

_db_cache_pmem_promotion_touch_rate_rese 300
t_interval

_db_cache_xmem_promotion_algo_chosen     38
_db_block_prefetch_quota                 10
_db_block_prefetch_wasted_threshold_perc 2
_db_block_prefetch_limit                 0
_db_block_prefetch_override              0
_rbr_ckpt_tracing                        0
_db_cache_pre_warm                       TRUE
buffer_pool_keep
buffer_pool_recycle
_db_percent_hot_default                  50
_db_percent_hot_keep                     0
_db_percent_hot_recycle                  0
_db_aging_hot_criteria                   2
_db_xmem_hot_switch_criteria             195
_db_aging_stay_count                     0
_db_aging_cool_count                     1
_db_aging_touch_time                     3
_db_aging_freeze_cr                      FALSE
_db_block_hash_buckets                   524288
_db_block_hash_latches                   4096
_db_blocks_per_hash_latch
_db_handles_cached                       10
_db_handles                              3000
_wait_for_sync                           TRUE
_db_block_vlm_check                      FALSE
_db_block_vlm_leak_threshold             4
_db_block_trace_protect                  FALSE
_db_flash_cache_slow_io_adjustment_inter 3600
val

_db_cache_miss_check_les                 FALSE
_db_block_max_cr_dba                     6
_write_clones                            3
_db_cache_silicon_secured_memory         TRUE
_check_block_after_checksum              FALSE
_trace_pin_time                          FALSE
_pin_time_statistics                     FALSE
_db_fast_obj_check                       FALSE
_db_block_temp_redo                      FALSE
_db_block_adjchk_level                   0
_db_block_adjcheck                       TRUE
_db_required_percent_fairshare_usage     10
_db_block_check_objtyp                   TRUE
_db_block_do_full_mbreads                FALSE
_shared_iop_max_size                     134217728
_shared_io_pool_buf_size                 1048576
_siop_flashback_scandepth                20
_shared_io_pool_debug_trc                0
_shared_io_set_value                     FALSE
_trace_buffer_wait_timeouts              0
_buffer_busy_wait_timeout                100
_influx_scn_wait_timeout                 1
_influx_scn_waits                        100000
_db_cache_crx_check                      FALSE
_db_cache_mman_latch_check               FALSE
_db_block_cache_history_lru              FALSE
_db_flash_cache_encryption               FALSE
_db_xmem_cache_encryption                TRUE
_db_block_header_guard_level             0
_db_block_table_scan_buffer_size         4194304
_db_cache_process_cr_pin_max             2147483647
_db_block_corruption_recovery_threshold  5
_db_block_chunkify_ncmbr                 FALSE
_db_cache_wait_debug                     0
_db_full_caching                         TRUE
_fastpin_enable                          1
_bps_sanity_checks                       FALSE
_db_prefetch_histogram_statistics        FALSE
_flush_undo_after_tx_recovery            TRUE
_enable_dbwr_parallel_invalidations      TRUE
_enable_buffer_header_history            TRUE
_db_block_iterations_for_rm              2000
_db_block_scandepth_for_rm               20
_spare_test_parameter                    0
db_flash_cache_file
db_flash_cache_size                      0
_db_2k_flash_cache_file
_db_2k_flash_cache_size                  0
_db_4k_flash_cache_file
_db_4k_flash_cache_size                  0
_db_8k_flash_cache_file
_db_8k_flash_cache_size                  0
_db_16k_flash_cache_file
_db_16k_flash_cache_size                 0
_db_32k_flash_cache_file
_db_32k_flash_cache_size                 0
_db_flash_cache_keep_limit               80
_db_flash_cache_write_limit              1
_db_flash_cache_force_replenish_limit    8
_db_l2_tracing                           0
_db_flash_cache_max_read_retry           10
_db_flash_cache_max_latency              400
_db_flash_cache_max_slow_io              3
_db_flash_cache_max_outstanding_writes   32
_db_flash_cache_disable_write_batchsize  4096
_db_dump_from_disk_and_efc               0
_numa_buffer_cache_stats                 0
_dynamic_hash_bucket_array               TRUE
_switch_current_scan_scn                 TRUE
_cleanout_shrcur_buffers                 TRUE
_avoid_scn_growth                        1
_fast_cr_clone                           TRUE
_clone_during_split                      TRUE
_db_cache_block_read_stack_trace         0
_child_read_ahead_dba_check              FALSE
_data_warehousing_scan_buffers           TRUE
_data_warehousing_scan_flash_buffers     FALSE
_data_warehousing_serial_scan            TRUE
_db_dw_scan_obj_cooling_policy           CACHE_SIZE
_db_dw_scan_obj_cooling_interval         100
_db_dw_scan_obj_cooling_factor           500
_db_dw_scan_obj_warming_increment        1000
_db_dw_scan_adaptive_cooling             FALSE
_db_dw_scan_max_shadow_count             5
_pq_numa_working_set_affinity            TRUE
_db_bt_cache_only_readmostly_obj_on_roi  FALSE
_auto_bmr_noretry_window                 1800
_sga_clear_dump                          FALSE
_clear_buffer_before_reuse               FALSE
_disable_adp_adj_buf_check               FALSE
_db_cache_block_read_stack_trace_where1  0
_db_cache_block_read_stack_trace_where2  0
_db_cache_block_read_stack_trace_where3  0
_allow_fallback_to_dbkey                 FALSE
_override_datafile_encrypt_check         FALSE
_disable_data_block_check_after_decrypt  FALSE
_assert_encrypted_tablespace_blocks      TRUE
_verify_encrypted_tablespace_keys        TRUE
_synchronous_rewrap_rac_ts_keys          FALSE
_defer_rewrap_controlfile_key_history    FALSE
_inject_simulated_error_period           131072
_enable_pmem_direct_cache                TRUE
_enable_pmem_exchange                    TRUE
_enable_pmem_prefetch                    FALSE
_pmem_exchange_cold_victim_threshold     0
_force_pmem_direct_mapped_cache_scan     TRUE
_assert_single_current_buffer            FALSE
db_cache_advice                          ON
_db_cache_advice_sample_factor           4
_db_cache_advice_max_size_factor         2
_db_cache_advice_sanity_check            FALSE
_db_cache_advice_hash_latch_multiple     16
_db_cache_advice_size_submultiple        10
_db_pmem_auto_resize_interval            10
_db_mttr_advice                          ON
_db_mttr_sim_target
_db_mttr_sample_factor                   64
_db_mttr_partitions                      0
_db_mttr_sim_trace_size                  256
_db_mttr_trace_to_alert                  FALSE
_obj_ckpt_tracing                        0
_immediate_commit_propagation            TRUE
_external_scn_rejection_threshold_hours  24
_c3_external_scn_rejection_threshold_hou 4464
rs

_max_reasonable_scn_rate                 32768
_external_scn_logging_threshold_seconds  86400
_external_scn_rejection_delta_threshold_ 0
minutes

_low_scn_headroom_warning_threshold_days 90
_high_intrinsic_scn_growth_alert         1440
compatible                               21.0.0
_redo_compatibility_check                FALSE
_db_block_check_for_debug                FALSE
_db_always_check_system_ts               TRUE
_skip_unconverted_change_vector          FALSE
_log_checkpoint_recovery_check           0
_two_pass                                TRUE
_recovery_verify_writes                  FALSE
_disable_recovery_read_skip              FALSE
_buddy_instance                          1
_buddy_instance_start_rba_timeout        9
_buddy_instance_num_read_buffers         4
_buddy_instance_scan_phase_threshold     3
_instance_recovery_bloom_filter_size     83886080
_instance_recovery_bloom_filter_fprate   0
_fatalprocess_redo_dump_time_limit       0
_nonfatalprocess_redo_dump_time_limit    3600
_redo_transport_stream_writes            TRUE
_redo_transport_stream_test              TRUE
_redo_transport_vio_size_req             1048576
log_archive_dest_1
log_archive_dest_2
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_10
log_archive_dest_11
log_archive_dest_12
log_archive_dest_13
log_archive_dest_14
log_archive_dest_15
log_archive_dest_16
log_archive_dest_17
log_archive_dest_18
log_archive_dest_19
log_archive_dest_20
log_archive_dest_21
log_archive_dest_22
log_archive_dest_23
log_archive_dest_24
log_archive_dest_25
log_archive_dest_26
log_archive_dest_27
log_archive_dest_28
log_archive_dest_29
log_archive_dest_30
log_archive_dest_31
log_archive_dest_state_1                 enable
log_archive_dest_state_2                 enable
log_archive_dest_state_3                 enable
log_archive_dest_state_4                 enable
log_archive_dest_state_5                 enable
log_archive_dest_state_6                 enable
log_archive_dest_state_7                 enable
log_archive_dest_state_8                 enable
log_archive_dest_state_9                 enable
log_archive_dest_state_10                enable
log_archive_dest_state_11                enable
log_archive_dest_state_12                enable
log_archive_dest_state_13                enable
log_archive_dest_state_14                enable
log_archive_dest_state_15                enable
log_archive_dest_state_16                enable
log_archive_dest_state_17                enable
log_archive_dest_state_18                enable
log_archive_dest_state_19                enable
log_archive_dest_state_20                enable
log_archive_dest_state_21                enable
log_archive_dest_state_22                enable
log_archive_dest_state_23                enable
log_archive_dest_state_24                enable
log_archive_dest_state_25                enable
log_archive_dest_state_26                enable
log_archive_dest_state_27                enable
log_archive_dest_state_28                enable
log_archive_dest_state_29                enable
log_archive_dest_state_30                enable
log_archive_dest_state_31                enable
log_archive_start                        FALSE
log_archive_dest
log_archive_duplex_dest
log_archive_min_succeed_dest             1
_dg_corrupt_redo_log                     0
_local_arc_assert_on_wait                FALSE
_defer_eor_orl_arch_for_so               TRUE
fal_client
fal_server
_enable_ffw                              TRUE
log_archive_trace                        0
_log_archive_trace_pids
_redo_transport_sanity_check             0
_fix_fuzzy_scn                           FALSE
_dg_cf_check_timer                       15
_bypass_srl_for_so_eor                   FALSE
_redo_transport_redo_log_management
_rta_sync_wait_timeout                   10
_log_archive_prot_auto_demote            FALSE
_serialize_lgwr_sync_io                  FALSE
data_guard_sync_latency                  0
_mgd_rcv_handle_orphan_datafiles         FALSE
_standby_auto_flashback                  TRUE
_real_time_apply_sim                     0
_defer_rcv_during_sw_to_sby              FALSE
_skip_trstamp_check                      TRUE
log_archive_config
_log_archive_buffers                     10
_redo_transport_compress_all             TRUE
_rtc_infeasible_threshold                25
log_archive_format                       %t_%s_%r.dbf
data_guard_max_io_time                   240
data_guard_max_longio_time               240
_redo_log_record_life                    168
_redo_log_debug_config                   0
_redo_log_check_backup                   10
_async_rta_broadcast                     FALSE
_rtabnd_update_offload                   TRUE
_redo_transport_async_mode               0
_log_archive_strong_auth                 TRUE
_redo_transport_max_kbytes_sec           0
_redo_transport_min_kbytes_sec           10
_redo_transport_catch_up_bandwidth_perce 50
ntage

_redo_transport_resource_management      FALSE
redo_transport_user
_lgwr_ns_nl_min                          500
_lgwr_ns_nl_max                          1000
_redo_transport_stall_time               360
_redo_transport_stall_time_long          3600
log_archive_max_processes                4
_max_lns_shutdown_archival_time          30
_lgwr_max_ns_wt                          1
_ns_max_flush_wt                         1
_ns_max_send_delay                       15
_lgwr_ta_sim_err                         0
_lgwr_ns_sim_err                         0
_log_archive_network_redo_size           10
_switchover_to_standby_switch_log        FALSE
_max_async_wait_for_catch_up             20
_redo_transport_evict_threshold          10
_num_rlslaves                            2
_lgwr_delay_write                        FALSE
_enable_redo_global_post                 FALSE
_cache_orl_during_open                   ALL
_image_redo_gen_delay                    0
_enable_pdb_skiplist_redogen             TRUE
_enable_pdb_skiplist_recovery            TRUE
_simulate_dax_storage                    DISABLE
_force_dax_io_err                        0
log_buffer                               6770688
_log_silicon_secured_memory              TRUE
_enable_log_memory_protection_key        FALSE
_target_log_write_size                   0
_target_log_write_size_timeout           0
_target_log_write_size_spinwait          0
_target_log_write_size_percent_for_poke  100
log_checkpoint_interval                  0
log_checkpoint_timeout                   1800
_log_switch_timeout                      0
archive_lag_target                       0
_log_buffers_debug                       FALSE
_log_buffers_corrupt                     FALSE
_log_simultaneous_copies                 2
_use_single_log_writer                   TRUE
_adaptive_scalable_log_writer_evaluation 60
_interval

_adaptive_scalable_log_writer_evaluation 100
_fraction

_max_outstanding_log_writes              1
_log_write_worker_task_prefetch          EARLY
_log_write_worker_task_spinwait          0
_log_write_worker_post_spinwait          0
_adaptive_scalable_log_writer_enable_wor 200
ker_threshold

_adaptive_scalable_log_writer_disable_wo 50
rker_threshold

_adaptive_scalable_log_writer_sampling_c 128
ount

_adaptive_scalable_log_writer_sampling_t 3
ime

_adaptive_scalable_log_writer_enable_wor 999900
ker_aging

_log_parallelism_max                     1
_log_parallelism_dynamic                 TRUE
_max_log_write_parallelism               1
_lost_write_parallelism_change_tracking  2
_serial_log_write_worker_io              FALSE
_parallel_log_write_cleanup              FALSE
_log_private_parallelism_mul             10
_log_private_mul                         5
_lightweight_hdrs                        TRUE
_redo_read_from_memory                   TRUE
_desired_readmem_rate                    90
_log_read_buffer_size                    8
_validate_readmem_redo                   HEADER_ONLY
_mirror_redo_buffers                     FALSE
_fg_log_checksum                         TRUE
_verify_fg_log_checksum                  FALSE
_disable_logging                         FALSE
_simulated_log_write_usecs               0
_log_buffer_coalesce                     FALSE
_redo_write_coalesce_all_threshold       0
_redo_write_coalesce_slave_threshold     0
_redo_write_sync_single_io               TRUE
_fg_sync_sleep_usecs                     0
_fg_fast_sync_sleep_usecs                0
_fg_fast_sync_spin_usecs                 100
_fg_fast_sync_slack_usecs                1
_fg_fast_sync_sleep_target_pct           50
_exa_pmemlog_threshold_usec              100
_log_file_sync_timeout                   10
_use_adaptive_log_file_sync              TRUE
_adaptive_log_file_sync_use_polling_thre 200
shold

_adaptive_log_file_sync_use_postwait_thr 50
eshold

_adaptive_log_file_sync_use_postwait_thr 1001
eshold_aging

_adaptive_log_file_sync_sampling_count   128
_adaptive_log_file_sync_sampling_time    3
_adaptive_log_file_sync_sched_delay_wind 60
ow

_adaptive_log_file_sync_poll_aggressiven 0
ess

_adaptive_log_file_sync_high_switch_freq 3
_threshold

_max_pending_scn_bcasts                  8
_lgwr_posts_for_pending_bcasts           FALSE
_long_log_write_warning_threshold        500
_boc_mode                                AUTO
_boc_rdma_wait_time                      0
_long_bcast_ack_warning_threshold        500
_enable_flash_logging                    TRUE
_check_pdbid_in_redo                     FALSE
_log_write_info_size                     4096
_cache_fusion_pipelined_updates          TRUE
_rac_propagate_last_rba                  TRUE
_log_writer_worker_dlm_hearbeat_update_f 5000
req

_hb_redo_interval                        1000
db_files                                 200
db_file_multiblock_read_count            128
_db_file_exec_read_count                 128
_db_file_optimizer_read_count            8
_db_file_noncontig_mblock_read_count     11
read_only_open_delayed                   FALSE
cluster_database                         FALSE
_cluster_database_instances              1
db_create_file_dest
db_create_online_log_dest_1
db_create_online_log_dest_2
db_create_online_log_dest_3
db_create_online_log_dest_4
db_create_online_log_dest_5
db_recovery_file_dest
db_recovery_file_dest_size               0
_db_recovery_temporal_file_dest
standby_file_management                  MANUAL
_standby_switchover_timeout              120
_hard_protection                         FALSE
_datafile_cow                            FALSE
_max_filestat_tries                      10
_disable_file_resize_logging             FALSE
_file_set_enqueue_timeout                1200
_file_offline_sync_timeout               900
_allow_error_simulation                  FALSE
_roi_first_open_wait                     120
_db_file_format_io_buffers               4
_disable_read_only_open_dict_check       FALSE
_standby_flush_mode                      SLFLUSH
_causal_standby_wait_timeout             20
_online_file_conversion_batchsize        16
_pdb_transition_clean_bg_delay           0
_gc_undo_affinity                        TRUE
_gc_disable_s_lock_brr_ping_check        TRUE
_gc_policy_time                          20
_gc_policy_rm_dirty_percent              1
_gc_policy_minimum                       1500
_gc_affinity_ratio                       50
_gc_transfer_ratio                       75
_gc_anti_lock_ratio                      66
_recovery_asserts                        FALSE
_gc_vector_read                          TRUE
_gc_element_percent                      105
_gc_latches                              32
_gc_keep_recovery_buffers                TRUE
_gc_keep_undo_recovery_buffers           TRUE
_recovery_read_limit                     1024
_gc_dump_remote_lock                     TRUE
_gc_drm_windows                          8
_gc_max_reg_sz                           68719476736
_gc_xmem_rdma                            FALSE
_gc_defer_time                           0
_gc_defer_ping_index_only                TRUE
_gc_delay_ping                           TRUE
_kcl_debug                               TRUE
_kcl_index_split                         TRUE
_fairness_threshold                      2
_gc_interconnect_checksum                FALSE
_cr_server_log_flush                     TRUE
_gc_log_flush                            TRUE
_async_recovery_reads                    TRUE
_async_recovery_claims                   TRUE
_bwr_for_flushed_pi                      TRUE
_send_requests_to_pi                     TRUE
_gc_check_bscn                           TRUE
_gc_global_lru                           AUTO
_gc_global_lru_touch_count               5
_gc_global_lru_touch_time                60
_gc_statistics                           TRUE
_gc_coalesce_recovery_reads              TRUE
_gc_global_checkpoint_scn                TRUE
_gc_undo_block_disk_reads                TRUE
_gc_affinity_locking                     TRUE
_gc_affinity_locks                       TRUE
_gc_read_mostly_locking                  TRUE
_gc_persistent_read_mostly               TRUE
_gc_bypass_readers                       TRUE
_gc_max_downcvt                          4096
_gc_fusion_compression                   1024
_gc_down_convert_after_keep              TRUE
_gc_flush_during_affinity                TRUE
_gc_cr_server_read_wait                  TRUE
_gc_read_mostly_flush_check              FALSE
_gc_override_force_cr                    TRUE
_gc_bg_merge                             TRUE
_gc_fg_merge                             TRUE
_gc_first_dirty_merge                    TRUE
_gc_no_fairness_for_clones               TRUE
_gc_sanity_check_cr_buffers              FALSE
_gc_save_cleanout                        FALSE
_gc_temp_affinity                        FALSE
_gc_fg_spin_time                         0
_gc_object_queue_max_length              0
_gc_async_send                           TRUE
_gc_try_to_skip_imc_flush                TRUE
_gc_msgq_buffers                         0
_gc_serve_from_flash_cache               FALSE
_gc_trace_freelist_empty                 FALSE
_gc_skip_undo_disk_read                  TRUE
_gc_blocking_pins                        FALSE
_gc_trace_blocking_pins                  FALSE
_gc_enable_cr_bypass                     TRUE
_gc_numa_lock_elements                   FALSE
_gc_buckets_per_latch                    0
_gc_integrity_checks                     1
_light_work_rule_debug                   FALSE
_gc_fast_index_split_wait                0
_gc_fast_index_split_timeout             100
_gc_partial_cleanout                     TRUE
_gc_undo_rdma_read                       FALSE
_gc_undo_header_rdma_read                TRUE
_gc_lease_time                           10000
_gc_spin_time                            32
_gc_down_convert_after_write             TRUE
_gc_rdma_connections                     8000
_gc_disable_cell_populate                FALSE
_adaptive_direct_read                    TRUE
_adaptive_direct_write                   TRUE
_db_block_align_direct_read              TRUE
_db_noarch_disble_optim                  FALSE
_db_disable_temp_encryption              FALSE
db_unrecoverable_scn_tracking            TRUE
_kcbl_assert_reset_slot                  TRUE
_direct_io_slots                         0
_direct_io_skip_cur_slot_on_error        TRUE
_direct_io_wslots                        0
_direct_io_via_mapped_pmem               TRUE
thread                                   0
_thread_state_change_timeout_pnp         1800
_disable_incremental_checkpoints         FALSE
_disable_thread_internal_disable         FALSE
_disable_selftune_checkpointing          FALSE
_selftune_checkpointing_lag              300
_target_rba_max_lag_percentage           81
_no_recovery_through_resetlogs           FALSE
enabled_PDBs_on_standby                  *
_auto_rekey_during_mrcv                  TRUE
_auto_rcv_pdb_open                       1
fast_start_io_target                     0
fast_start_mttr_target                   0
_log_blocks_during_backup                TRUE
_allow_resetlogs_corruption              FALSE
_allow_terminal_recovery_corruption      FALSE
_allow_read_only_corruption              FALSE
_allow_file_1_offline_error_1245         FALSE
_recovery_skip_cfseq_check               FALSE
log_checkpoints_to_alert                 FALSE
db_lost_write_protect                    NONE
_db_shadow_lost_write_protect            NOT_SET
_db_lost_write_corrupt_block             FALSE
_flush_log_buffer_timeout                0
_flush_log_buffer_force                  FALSE
_switchover_to_standby_option            OPEN_ALL_IGNORE_SESSIONS
_switchover_timeout                      0
_switchover_through_cascade              TRUE
_auto_bmr_file_header                    TRUE
_fast_psby_conversion                    TRUE
_adg_instance_recovery                   TRUE
_ac_enable_dscn_in_rac                   FALSE
_ac_strict_SCN_check                     FALSE
_allow_convert_to_standby                FALSE
_early_flush_delta                       0
_flush_redo_to_standby                   0
_disable_dict_check_pdb_open             FALSE
_clear_preserved_buffers                 TRUE
_datafile_create_wait_time               0
_datafile_create_min_wait_time           0
_skip_pdb_recovery_if_keystore_not_open  FALSE
_defer_rcv_pdb_attach                    TRUE
recovery_parallelism                     0
_serial_recovery                         FALSE
_coord_message_buffer                    0
_multiple_instance_recovery              FALSE
_backup_compress                         FALSE
_backup_kgc_scheme                       ZLIB
_backup_kgc_medium_scheme                DEFAULT
_backup_kgc_bz2_bufsz                    0
_backup_kgc_bz2_type                     0
_backup_kgc_bz2_niters                   0
_backup_kgc_lzo_bufsz                    262144
_backup_kgc_zlib_complevel               1
_backup_kgc_zlib_windowbits              15
_backup_kgc_zlib_memlevel                8
_backup_kgc_bzip2_blksiz                 9
_backup_kgc_zstd_complevel               3
_backup_kgc_zstd_bufsz                   262144
_backup_ksfq_bufmem_max                  268435456
_backup_ksfq_bufsz                       0
_backup_ksfq_bufcnt                      0
_backup_disk_bufsz                       0
_backup_disk_bufcnt                      0
_backup_seq_bufsz                        0
_backup_seq_bufcnt                       0
_backup_file_bufsz                       0
_backup_file_bufcnt                      0
_restore_maxopenfiles                    8
_backup_max_gap_size                     4294967294
_backup_min_ct_unused_optim              2097152
_unused_block_compression                TRUE
_restore_spfile
_dummy_instance                          FALSE
_rman_io_priority                        3
_backup_encrypt_opt_mode                 4294967294
_disable_initial_block_compression       FALSE
_undo_block_compression                  TRUE
_disable_block_corruption_track          FALSE
_update_datafile_headers_with_space_info FALSE
rmation

_disable_cell_optimized_backups          FALSE
_backup_align_write_io                   TRUE
_backup_dynamic_buffers                  TRUE
_backup_automatic_retry                  10
_krb_trace_buffer_size                   131072
_sparse_backing_file                     AVM
_catalog_foreign_restore                 FALSE
_restore_create_directory                TRUE
_backup_max_wallet_session               50
_backup_block0                           default
_restore_block0                          on
_write_renamed_datafile_name             FALSE
_backup_int_spare1                       4294967294
_backup_int_spare2                       4294967294
_backup_int_spare3                       4294967294
_backup_int_spare4                       4294967294
_backup_text_spare1
_backup_text_spare2
_backup_text_spare3
_backup_text_spare4
_backup_bool_spare1                      FALSE
_backup_bool_spare2                      FALSE
_backup_bool_spare3                      FALSE
_backup_bool_spare4                      FALSE
_krb_check_osd_block_endianess           TRUE
_backup_interrupt_wait_time              1000
_controlfile_autobackup_delay            300
_deferred_log_dest_is_valid              TRUE
_log_deletion_policy                     mandatory
_prefered_standby
_auto_bmr                                enabled
_auto_bmr_req_timeout                    60
_auto_bmr_sess_threshold                 30
_auto_bmr_pub_timeout                    10
_auto_bmr_fc_time                        60
_auto_bmr_bg_time                        3600
_auto_bmr_sys_threshold                  100
_auto_bmr_max_rowno                      1024
_krbabr_trace_buffer_size                131072
_preplugin_backup                        enabled
_auto_export_preplugin_backup            TRUE
_backup_appliance_enabled                FALSE
_ba_container_filesystem_ausize          4194304
_ba_max_groups                           0
_ba_max_containers                       0
_ba_max_seg_bytes                        4000
_ba_cf_trace_buffer_size                 131072
_ba_timeouts_enabled                     TRUE
enable_goldengate_replication            FALSE
_tts_allow_charset_mismatch              FALSE
_xtts_allow_pre10                        FALSE
_xtts_set_platform_info                  FALSE
_bypass_xplatform_error                  FALSE
_aux_dfc_keep_time                       1440
_forced_endian_type                      UNKNOWN
_allow_cross_endian_dictionary           FALSE
_query_on_physical                       TRUE
_recoverable_recovery_batch_percent      50
_undo_tbs_slave_percent                  0
_recoverable_recovery_max_influx_buffers 100000
_disable_incremental_recovery_ckpt       FALSE
_clone_one_pdb_recovery                  FALSE
_incremental_recovery_ckpt_min_batch     500
_time_based_rcv_ckpt_target              180
_time_based_rcv_hdr_update_interval      180
_multi_instance_pmr                      TRUE
_disable_active_influx_move              FALSE
_abort_on_mrp_crash                      FALSE
_keep_19907_during_recovery              FALSE
_defer_log_boundary_ckpt                 TRUE
_defer_log_count                         100
_transient_logical_clear_hold_mrp_bit    FALSE
_log_max_optimize_threads                128
_reduce_sby_log_scan                     TRUE
_sync_primary_wait_time                  5
_standby_implicit_rcv_timeout            3
_readable_standby_sync_timeout           10
_readable_standby_sync_interval          0
_adg_parselock_timeout                   0
_adg_influx_qscn_gap                     0
_adg_parselock_timeout_sleep             100
_adg_objectlock_timeout                  0
_adg_objectlock_attempts                 2
_adg_objectlock_maxnum                   1000
_adg_count_beyond_limit                  0
_adg_defer_segstat                       TRUE
inmemory_adg_enabled                     TRUE
_adg_adt_redirect_catchup_wait_time      12000
_adg_adt_redirect_apply_lag_threshold    12000
_read_only_violation_max_count           500
_read_only_violation_max_count_per_modul 100
e

_read_only_violation_dump_to_trace       FALSE
_adg_redirect_upd_to_primary_max_retries 500
_media_recovery_read_batch               32
_standby_causal_heartbeat_timeout        2
_use_pdb_parselock                       TRUE
_snapshot_recovery_enabled               TRUE
_adg_auto_close_pdb                      TRUE
_bct_public_dba_buffer_size              0
_bct_initial_private_dba_buffer_size     0
_bct_bitmaps_per_file                    8
_bct_file_block_size                     0
_bct_file_extent_size                    0
_bct_chunk_size                          0
_bct_crash_reserve_size                  262144
_bct_buffer_allocation_size              2097152
_bct_buffer_allocation_max               1073741824
_bct_buffer_allocation_min_extents       1
_bct_fixtab_file
_disable_primary_bitmap_switch           FALSE
_bct_health_check_interval               60
_bct_public_dba_buffer_dynresize         2
_bct_public_dba_buffer_dynresize_delay   3600
_bct_public_dba_buffer_maxsize           0
_bct_mrp_timeout                         5
_krc_trace_buffer_size                   131072
_kra_trace_buffer_size                   131072
_kra_cfile_compaction                    TRUE
db_flashback_retention_target            1440
_validate_flashback_database             FALSE
_flashback_allow_noarchivelog            FALSE
_verify_flashback_redo                   TRUE
_flashback_verbose_info                  FALSE
_flashback_dynamic_enable_failure        0
_flashback_dynamic_enable                TRUE
_allow_drop_snapshot_standby_grsp        FALSE
_flashback_marker_cache_size             328
_flashback_marker_cache_enabled          TRUE
_flashback_database_test_only            FALSE
_allow_drop_ts_with_grp                  FALSE
_df_hist_offl_override                   FALSE
_propogate_restore_point                 TRUE
_fb_recovery_slave_count                 0
_disable_orphan_pdb_recovery             FALSE
_max_flashback_shrink_size               1048576
_test_flashback_shrink                   0
_flashback_logfile_enqueue_timeout       600
_fb_log_max_rereads                      100
_flashback_barrier_interval              1800
_flashback_standby_barrier_interval      1
_flashback_stby_support_mira             TRUE
_flashback_standby_check_barrier_MIRA    20
_flashback_standby_check_minpfh_MIRA     15
_flashback_max_standby_sync_span         300
_flashback_fuzzy_barrier                 TRUE
_disable_kcb_flashback_blocknew_opt      FALSE
_disable_kcbl_flashback_blocknew_opt     FALSE
_disable_flashback_wait_callback         FALSE
_check_block_new_invariant_for_flashback FALSE
_allow_compatibility_adv_w_grp           FALSE
_minimum_db_flashback_retention          60
_flashback_delete_chunk_MB               128
_flashback_11_1_block_new_opt            FALSE
_flashback_marker_for_every_grp          FALSE
_flashback_log_size                      1000
_flashback_log_min_size                  100
_db_flashback_log_min_size               16777216
_db_flashback_log_min_total_space        0
_flashback_copy_latches                  10
_flashback_n_log_per_thread              128
_flashback_max_n_log_per_thread          2048
_flashback_generation_buffer_size        4194304
_allocate_flashback_buffer               FALSE
_flashback_max_log_size                  0
_flashback_log_io_error_behavior         0
_flashback_prepare_log                   TRUE
_flashback_size_based_on_redo            TRUE
_flashback_validate_controlfile          FALSE
_flashback_format_chunk_mb               4
_flashback_format_chunk_mb_dwrite        16
_flashback_log_rac_balance_factor        10
_flashback_write_max_loop_limit          10
_flashback_hint_barrier_percent          20
_drop_flashback_logical_operations_enq   FALSE
_percent_flashback_buf_partial_full      50
_flashback_reclaim_monitor_window        7
_flashback_reclaim_speed_up              FALSE
_tdb_debug_mode                          16
_log_read_buffers                        8
_change_vector_buffers                   1
_change_vector_read_sample_ratio         0
_partial_log_preserve_space              TRUE
_db_block_prefetch_skip_reading_enabled  TRUE
_db_block_prefetch_fast_longjumps_enable TRUE
d

_db_block_prefetch_private_cache_enabled TRUE
_datafile_write_errors_crash_instance    TRUE
_datafile_open_errors_crash_instance     TRUE
_siop_perc_of_bc_x100                    625
_siop_init_mem_gradually                 TRUE
_db_flashback_iobuf_size                 1
_db_flashback_num_iobuf                  64
_flashback_enable_ra                     TRUE
_nologging_sendbuf_ratio                 90
_nologging_slots                         20
_nologging_load_slotsz                   1048576
_nologging_block_cleanout_delay          300
_force_logging_in_upgrade                TRUE
_nologging_mode_override                 0
_nologging_txn_history_to_sessions_perce 100
nt

_nologging_fetch_slv_wt                  600
_nologging_progress_keep_alive           10
_nologging_kcnbuf_hash_buckets           1024
_nologging_kcnbuf_hash_latches           256
_nologging_standby_hot_buffer_timeout    500
_nologging_standby_cold_buffer_timeout   500
_nbr_recovery_timeout                    60
_nbr_recovery_max_request_size           8
_nbr_recovery_target_bufs                0
_nologging_apply_stall_time              1000
_nologging_standby_fetch_disable         FALSE
_nologging_standby_refetch_disable       FALSE
_nologging_standby_dtc_expire            600
_nologging_sdcl_append_wait              200
_nologging_txn_cmt_wait                  1500
_max_data_transfer_cache_size            536870912
_data_transfer_cache_bc_perc_x100        500
data_transfer_cache_size                 0
__data_transfer_cache_size               0
_nologging_fetch_retry_interval_hot      60
_nologging_fetch_retry_interval_cold     1800
_nologging_fetch_demote_count            10
_nologging_fetch_initial_interval        2
_max_kcnibr_ranges                       1048576
_mira_mark_archivelog_timeout            60
enable_imc_with_mira                     FALSE
_mira_num_receive_buffers                25
_mira_num_local_buffers                  25
_mira_sender_process                     2
_mira_rcv_max_buffers                    500
_krpm_trace_buffer_size                  262144
_mira_rcv_catchup_buffers                5
_mira_free_unused_buffers                TRUE
_dbcomp_msg_ver                          1
_dbcomp_maxdump                          100
_shadow_lost_write_found                 118
_shadow_lost_write_tracing               0
adg_account_info_tracking                LOCAL
adg_redirect_dml                         FALSE
_alter_adg_redirect_behavior             none
_psr_opt                                 enable feature
_kcrfwrma_flags                          0
_dgpdb_standby_controlfile_name          dgpdb_temp_copy_cf_%u_stby_%u_
                                         %u.cf

dml_locks                                2076
_row_locking                             always
_serializable                            FALSE
_scn_wait_interface_max_timeout_secs     2147483647
_scn_wait_interface_max_backoff_time_sec 600
s

replication_dependency_tracking          TRUE
_ktb_debug_flags                         8
_log_committime_block_cleanout           FALSE
_ktc_latches                             0
_prescomm                                FALSE
_recursive_imu_transactions              FALSE
_ktc_debug                               0
_enable_minscn_cr                        TRUE
_txn_control_trace_buf_size              4096
transactions                             519
transactions_per_rollback_segment        5
_ktu_latches                             0
_transaction_auditing                    TRUE
_smu_error_simulation_site               0
_smu_error_simulation_type               0
_imtxn_table_enable                      TRUE
_imtxn_table_max_undo_segs               1024
_imtxn_table_max_slts_per_seg            34
_imtxn_table_max_inc_per_slt             1
_imtxn_table_flags                       3
_temp_undo_disable_adg                   FALSE
temp_undo_enabled                        FALSE
_temp_undo_optimal_extents               0
_rollback_stopat                         0
_discrete_transactions_enabled           FALSE
_in_memory_undo                          TRUE
_imu_pools                               3
_branch_tagging                          TRUE
_row_cr                                  TRUE
_enable_block_level_transaction_recovery TRUE
_cleanup_rollback_entries                100
rollback_segments
_rollback_segment_initial                1
undo_management                          AUTO
_offline_rollback_segments
_corrupted_rollback_segments
_rollback_segment_count                  0
undo_tablespace                          UNDOTBS1
_smu_timeouts
_smu_debug_mode                          0
_undo_debug_mode                         0
_tablespaces_per_transaction             10
_verify_undo_quota                       FALSE
_undo_ofd_enabled                        TRUE
_undo_ofd_excess                         10
_undo_ofd_reserve                        30
_txn_spare1                              0
_txn_spare2                              0
_txn_spare3                              0
_in_memory_tbs_search                    TRUE
_highthreshold_undoretention             31536000
_undo_autotune                           TRUE
undo_retention                           900
_collect_undo_stats                      TRUE
_collect_tempundo_stats                  TRUE
_indoubt_pdb_transactions_force_outcome  COMMIT
_min_undosegs_for_parallel_fptr          100
_number_of_undo_blocks_to_prefetch       8
_runtime_limit_parallel_fptr             60
_cputime_limit_parallel_fptr             60
_temp_undo_disable_refresh_clone         TRUE
_imtxnrma_table_enable                   FALSE
_imtxnrma_table_flags                    0
_transaction_recovery_servers            0
fast_start_parallel_rollback             LOW
_parallel_recovery_stopat                32767
resumable_timeout                        0
_resumable_critical_alert                0
_cr_trc_buf_size                         8192
_max_cr_rollbacks                        1000
_disable_txn_alert                       0
_undo_debug_usage                        0
_db_change_notification_enable           TRUE
_minact_timeout                          180
_disable_flashback_archiver              0
_disable_fba_qrw                         0
_disable_fba_wpr                         0
_flashback_archiver_partition_size       0
_fbda_busy_percentage                    0
_fbda_inline_percentage                  0
_fbda_debug_mode                         0
_fbda_debug_assert                       0
_fbda_global_bscn_lag                    0
_fbda_rac_inactive_limit                 0
_fbda_adv_gbl_bscn_bcast_interval        0
_fbda_tcrv_cleanup_lag                   3600
_securefile_log_num_latches              0
_securefile_log_shared_pool_size         0
_cli_cachebktalloc                       100
_ilm_mem_limit                           10
_ktilmsc_exp                             600
_ktilm_uga_off                           FALSE
_inmemory_check_prot_meta                FALSE
_inmemory_private_journal_quota          100
_inmemory_txnpjrnl_debug                 0
_inmemory_private_journal_sharedpool_quo 20
ta

_inmemory_private_journal_numbkts        512
_inmemory_private_journal_numgran        255
_inmemory_private_journal_maxexts        5000000
_inmemory_journal_scan                   0
_inmemory_journal_format                 1
_inmemory_journal_scan_format            TRUE
_inmemory_journal_cla_stride             4
_inmemory_partrowlock_threshold          10
_inmemory_pin_hist_mode                  16
_inmemory_txn_checksum                   0
_inmemory_buffer_waittime                100
_inmemory_retention_time                 120
_inmemory_cudrop_timeout                 1000
_inmemory_exclto_timeout                 100
_inmemory_num_hash_latches               256
_inmemory_strdlxid_timeout               0
_inmemory_incremental_repopulation       TRUE
_inmemory_repopulate_optimize            TRUE
_inmemory_transaction_options            2806
_inmemory_waitinvis_count                8
_inmemory_lock_for_smucreate             FALSE
_inmemory_relimcusz_thresh               25
_inmemory_shared_journal_maxexts         1024
_inmemory_shared_journal_minexts_repop   256
_inmemory_direct_reads                   1
_inmemory_grpcolinv_buffer_size          131072
_inmemory_grpcolinv_granularity          1
_inmemory_crclone_buffer_size            131072
_inmemory_crclone_threshold_rows         100
_inmemory_crclone_min_clones             6
_inmemory_crclone_min_space_percent      50
_inmemory_patch_threshold_blocks         25
_inmemory_patch_background_blocks        200
_inmemory_patch_commit_path              FALSE
_inmemory_smu_patch_options              7
_inmemory_adg_quiesce_timeout            2
_inmemory_adg_periodic_sort              FALSE
_inmemory_adg_batched_flush              TRUE
_inmemory_adg_parallel_flush             TRUE
_inmemory_adg_journal_quota              FALSE
_blockchain_txn_apis_enabled             TRUE
_blockchain_txn_test_lvl                 0
_ktst_rss_min                            100
_ktst_rss_max                            1000
_ktst_rss_retry                          5
_force_temp_space_cleanup                TRUE
_partition_large_extents                 TRUE
_index_partition_large_extents           FALSE
_force_local_temp                        FALSE
_prefer_local_temp                       FALSE
instance_number                          0
_allocate_creation_order                 FALSE
_log_space_errors                        TRUE
_assm_low_gsp_threshold                  10000
_assm_high_gsp_threshold                 11024
_simulate_io_wait                        0
_bump_highwater_mark_count               0
_assm_segment_extension_percent          100
_old_extent_scheme                       FALSE
_trace_temp                              FALSE
_concurrency_chosen                      10
_no_small_file                           FALSE
_assm_default                            TRUE
_enable_hwm_sync                         TRUE
_hwm_sync_threshold                      10
_enable_check_truncate                   TRUE
_enable_tablespace_alerts                TRUE
_disable_temp_tablespace_alerts          FALSE
_disable_undo_tablespace_alerts          FALSE
_disable_lostwrite_tablespace_alerts     FALSE
_last_allocation_period                  5
_securefiles_forceflush                  FALSE
_securefiles_concurrency_estimate        12
_securefiles_memory_percentofSGA         8
_securefiles_dealloc_cfs                 0
_inst_locking_period                     5
_allocation_update_interval              3
_minimum_blocks_to_shrink                0
_minimum_extents_to_shrink               1
_index_partition_shrink_opt              TRUE
_use_best_fit                            FALSE
_step_down_limit_in_pct                  20
_assm_test_force_rej                     0
_assm_test_force_rej2                    0
_assm_test_reentrant_gsp                 FALSE
_enable_space_preallocation              3
_ktspsrch_maxsc                          1024
_ktspsrch_scexp                          60
_ktspsrch_scchk                          60
_ktspsrch_maxskip                        5
_max_sys_next_extent                     0
_assm_force_fetchmeta                    FALSE
_max_fsu_segments                        1024
_max_fsu_sgapcent                        10
_max_fsu_exptime                         7200
_max_fsu_stale_time                      600
_disable_flashback_recyclebin_opt        TRUE
_max_shrink_obj_stats                    0
_check_ts_threshold                      0
_async_ts_threshold                      1
_enable_securefile_flashback_opt         FALSE
_securefile_shrink_enable_nowaitlck      FALSE
_securefile_shrink_hash_table_limit      100
_disable_def_seg_update                  0
_use_cached_asm_free_space               FALSE
_ena_storage_lmt                         DEFAULT
_kttext_warning                          1285
_ktte_ts_shrink_interval                 3600
_ktte_ts_shrink_group                    6
_ktt_tsid_reuse_threshold                60000
_enable_verbose_gdr                      FALSE
_enable_sysaux_gdr                       FALSE
_gdr_clear_inactive_only                 FALSE
_gdr_clear_active_only                   FALSE
_drop_tablespace_objects                 0
_smon_internal_errlimit                  100
_smon_undo_seg_rescan_limit              10
_smon_ofd_sleep_interval                 300
_enable_12g_bft                          TRUE
_space_align_size                        1048576
_undotbs_stepdown_pcent                  75
_undotbs_regular_tables                  FALSE
_enable_spacebg                          TRUE
_max_spacebg_slaves                      1024
_minmax_spacebg_slaves                   8
_min_spacebg_slaves                      2
_max_spacebg_tasks                       8192
_max_spacebg_msgs_percentage             50
_ktslj_segext_warning                    10
_ktslj_segext_warning_mb                 0
_ktslj_segext_max_mb                     0
_ktslj_segext_retry                      5
_securefiles_fg_retry                    100
_securefiles_breakreten_retry            5
_securefiles_bulkclnout                  TRUE
_securefiles_bulkinsert                  FALSE
_securefiles_bgtimeout                   0
_securefiles_spcutl                      FALSE
_spacebg_sync_segblocks                  TRUE
_trace_ktfs                              FALSE
_trace_ktfs_mem                          FALSE
heat_map                                 OFF
_enable_ilm_flush_stats                  TRUE
_enable_ilm_testflush_stats              FALSE
_disable_12cbigfile                      FALSE
_enable_heatmap_internal                 FALSE
_disable_ilm_internal                    FALSE
_heatmap_format_1block                   FALSE
_test_hm_extent_map                      FALSE
_ilmset_stat_limit                       0
_ilmflush_stat_limit                     0
_heatmap_min_maxsize                     0
_ilmstat_memlimit                        5
_flush_ilm_stats                         0
_create_stat_segment                     0
_drop_stat_segment                       0
_print_stat_segment                      0
_print_inmem_heatmap                     0
_blockhm_flush_period                    3600
_inmemory_auto_distribute                TRUE
_inmemory_autodist_2safe                 FALSE
_inmemory_distribute_timeout             300
_inmemory_distribute_ondemand_timeout    300
_inmemory_granule_size                   134217728
inmemory_size                            0
inmemory_xmem_size                       0
_inmemory_64k_percent                    30
_inmemory_expressions_area_percent       10
_inmemory_min_ima_defersize              0
_inmemory_memprot                        FALSE
__inmemory_ext_rwarea                    0
_inmemory_ext_rwarea                     0
__inmemory_ext_roarea                    0
_inmemory_ext_roarea                     0
inmemory_prefer_xmem_memcompress
inmemory_prefer_xmem_priority
_inmemory_xmem_size                      0
_inmemory_prefer_xmem_memcompress
_inmemory_prefer_xmem_priority
_inmemory_drcancel_cu_percent            80
_trace_ktds                              FALSE
_track_space_reuse                       FALSE
_track_space_reuse_rac                   FALSE
_spacereuse_track_memlimit               10
_print_inmem_srmap                       0
_enable_rejection_cache                  TRUE
_assm_space_cache_hb_expire              3
_assm_l1cleanout_throttle_time           3
_assm_examination_time_threshold         60
_assm_examination_blocks_threshold       8196
_assm_examination_enable_sla             FALSE
_assm_space_cache_max_segments           1024
_assm_segment_repair_fg                  0
_assm_segment_repair_bg                  TRUE
_assm_segment_repair_maxblks             4294967294
_assm_latency_sampling_frequency         0
_assm_segment_repair_timelimit           60
_atp_block_size_default                  TRUE
allow_rowid_column_type                  FALSE
_assm_auto_tracing_threshold             10000
_db_row_overlap_checking                 TRUE
_db_index_block_checking                 TRUE
_kdi_avoid_block_checking                FALSE
db_block_checking                        FALSE
_disable_block_checking                  FALSE
_kd_symtab_chk                           TRUE
_sage_block_checking                     FALSE
_kd_rows_chk                             TRUE
recyclebin                               on
_suppress_identifiers_on_dupkey          FALSE
_compression_compatibility               21.0.0
_check_column_length                     TRUE
_oltp_compression                        TRUE
_inplace_update_retry                    TRUE
_widetab_comp_enabled                    TRUE
_partial_comp_enabled                    TRUE
_limit_itls                              20
_force_hsc_compress                      FALSE
_force_oltp_compress                     FALSE
_force_partial_compress                  FALSE
_force_sys_compress                      TRUE
_force_oltp_update_opt                   TRUE
_force_arch_compress                     0
_compression_advisor                     0
_compression_chain                       90
_compression_above_cache                 0
_oltp_compress_dbg                       0
_oltp_compression_gain                   10
_arch_compression                        TRUE
_arch_comp_dbg_scan                      0
_oltp_comp_dbg_scan                      0
_dbg_scan                                0
_arch_comp_dec_block_check_dump          1
_alternate_iot_leaf_block_split_points   TRUE
_kdu_array_depth                         16
_cell_offload_hybridcolumnar             TRUE
_disable_implicit_row_movement           FALSE
_cu_row_locking                          0
_oltp_spill                              FALSE
_delete_ghost_data                       FALSE
_kd_dbg_control                          0
_block_dump_assert                       FALSE
_release_insert_threshold                5
_walk_insert_threshold                   0
_enable_hash_overflow                    FALSE
_kdtgsp_retries                          1024
_rowlen_for_chaining_threshold           1000
_minfree_plus                            0
_disable_hcc_array_insert                FALSE
_extra_lmn_enabled                       TRUE
_use_seq_process_cache                   TRUE
_pdb_use_sequence_cache                  TRUE
_sequence_scale_noextend                 FALSE
_sequence_scale_extend                   FALSE
_dynamic_sequence_cache                  TRUE
_dynamic_sequence_cache_scale            10
_dynamic_sequence_cache_max              1000000
_analyze_comprehensive                   FALSE
_disable_index_block_prefetching         FALSE
_index_scan_check_skip_corrupt           FALSE
_index_scan_check_stopkey                FALSE
_index_max_inc_trans_pct                 20
_index_split_chk_cancel                  5
_advanced_index_compression_trace        0
_gdr_control_flags                       0
db_index_compression_inheritance         NONE
_index_alert_key_not_found               FALSE
_ffs_in_range_scan_threshold             50
_reuse_index_loop                        5
_kdis_reject_limit                       5
_kdis_reject_level                       24
_kdis_reject_ops                         FALSE
_kdis_split_xid_prune                    TRUE
_kdbl_enable_post_allocation             FALSE
_ldr_io_size                             1048576
_ldr_pga_lim                             0
_ldr_tempseg_threshold                   8388608
_reclaim_lob_index_scan_limit            0
_dbfs_symlink_path_prefix                TRUE
_lmn_invalidlkr_enabled                  TRUE
_ignore_desc_in_index                    FALSE
_kdic_segarr_sz                          0
_runtime_index_key_length_check          0
_keep_remote_column_size                 FALSE
_ctas_numfrags_hint                      0
_ctex_fk_copy_mode                       1
_kdli_trace                              0
_kdli_sort_dbas                          FALSE
_kdli_safe_callbacks                     TRUE
_kdli_inode_preference                   data
_kdli_reshape                            FALSE
_kdli_cache_inode                        TRUE
_kdli_cache_verify                       FALSE
_kdli_cache_size                         8
_kdli_memory_protect                     FALSE
_kdli_rci_lobmap_entries                 255
_kdli_readahead_strategy                 contig
_kdli_readahead_limit                    0
_kdli_sio_on                             TRUE
_kdli_sio_min_read                       0
_kdli_sio_min_write                      0
_kdli_sio_async                          TRUE
_kdli_sio_fgio                           TRUE
_kdli_sio_nbufs                          8
_kdli_sio_niods                          8
_kdli_sio_strategy                       extent
_kdli_sio_fileopen                       none
_kdli_sio_flush                          FALSE
_kdli_sio_bps                            0
_kdli_sio_pga                            FALSE
_kdli_sio_pga_top                        FALSE
_kdli_sio_dop                            2
_kdli_sio_free                           TRUE
_kdli_sio_backoff                        FALSE
_kdli_inline_xfm                         TRUE
_kdli_timer_trc                          FALSE
_kdli_timer_dmp                          FALSE
_kdli_cacheable_length                   0
_kdli_small_cache_limit                  32
_kdli_inject_assert                      0
_kdli_inject_crash                       0
_kdli_space_cache_limit                  2048
_kdli_force_cr                           TRUE
_kdli_force_cr_meta                      TRUE
_kdli_recent_scn                         FALSE
_kdli_itree_entries                      0
_kdli_cache_read_threshold               0
_kdli_cache_write_threshold              0
_kdli_full_readahead_threshold           0
_kdli_force_storage                      none
_kdli_allow_corrupt                      FALSE
_kdli_squeeze                            TRUE
_kdli_buffer_inject                      TRUE
_kdli_inject_batch                       0
_kdli_flush_injections                   TRUE
_kdli_flush_cache_reads                  FALSE
_kdli_checkpoint_flush                   FALSE
_kdli_delay_flushes                      TRUE
_kdli_dbc                                none
_kdli_preallocation_pct                  0
_kdli_preallocation_mode                 length
_kdli_inplace_overwrite                  0
_kdli_sio_write_pct                      100
_kdli_sio_fbwrite_pct                    35
_kdli_vll_direct                         TRUE
_kdli_descn_adj                          FALSE
_kdli_oneblk                             FALSE
_kdli_mts_so                             TRUE
_kdli_ralc_length                        10485760
_kdli_ralc_rounding                      1048576
_kdli_space_cache_segments               16
_kdli_icache_entries                     3
_kdli_full_vll                           FALSE
_kdli_small_append_redo                  TRUE
_kdli_adaptive_cache_inode               TRUE
_kdli_cache_inode_off_limit              8192
_kdli_STOP_tsn                           0
_kdli_STOP_dba                           0
_kdli_STOP_fsz                           0
_kdli_STOP_bsz                           0
_kdli_STOP_nio                           0
_kdlw_enable_write_gathering             TRUE
_kdlw_enable_ksi_locking                 FALSE
_kdlwp_flush_threshold                   4194304
_kdlwp_memory_check                      TRUE
_kdlxp_cmp_subunit_size                  262144
_kdlxp_minxfm_size                       32768
_kdlxp_lobcompress                       FALSE
_kdlxp_lobcmplevel                       2
_kdlxp_lobcmprciver                      1
_kdlxp_lobencrypt                        FALSE
_kdlxp_xfmcache                          TRUE
_kdlxp_lobcmpadp                         FALSE
_kdlxp_uncmp                             FALSE
_kdlxp_mincmplen                         200
_kdlxp_mincmp                            20
_sf_default_enabled                      TRUE
db_securefile                            PREFERRED
_kdlf_read_flag                          0
_kdlf_fast_move_compressed_lob           TRUE
_kdlf_layers_cache                       TRUE
_kdlxp_lobdeduplicate                    FALSE
_kdlxp_lobdedupvalidate                  TRUE
_kdlxp_dedup_hash_algo                   SHA1
_kdlxp_dedup_flush_threshold             8388608
_kdlxp_dedup_prefix_threshold            1048576
_kdlxp_dedup_inl_pctfree                 5
_kdlxp_dedup_wapp_len                    0
_kdlxp_spare1                            0
_kdlxp_no_dedup_on_insert                FALSE
_securefile_timers                       FALSE
_kdlu_trace_system                       0
_kdlu_trace_layer                        0
_kdlu_max_bucket_size                    4194304
_kdlu_max_bucket_size_mts                131072
_kdz_hcc_track_upd_rids                  FALSE
_kdz_hcc_flags                           0
_kdz_pcode_flags                         0
_enable_columnar_cache                   1
_kdz_proj_nrows                          1024
_kdz_pred_nrows                          32767
_kdzk_enable_init_trace                  FALSE
_kdzk_load_specialized_library           3
_kdzk_specialized_library_name
_kdzk_trace_level                        0
_hpk_project_cost_weighting              20
_hpk_throughput_range                    5
_hpk_compression_range                   5
_inmemory_analyzer_optimize_for          0
_kdz_clear_analysis_percent              60
_dbfs_modify_implicit_fetch              TRUE
_ILM_FILTER_TIME                         0
_ILM_FILTER_TIME_LOWER                   0
_ILM_POLICY_NAME                         FALSE
_inmemory_default_flags                  8459
_inmemory_default_new                    FALSE
inmemory_clause_default
inmemory_force                           DEFAULT
inmemory_query                           ENABLE
_inmemory_default_svc                    0
_inmemory_default_svcname
inmemory_expressions_usage               ENABLE
inmemory_virtual_columns                 MANUAL
_inmemory_disable_selective_vircols      FALSE
_inmemory_expression_count               20
_inmemory_max_expressions_table          50
_inmemory_expressions_mark_unused        FALSE
_inmemory_ime_increpop_threshold         1
_inmemory_opaque_contig_space_percent    80
_inmemory_hybrid_selectivity_threshold   37
_inmemory_query_scan                     TRUE
_inmemory_scan_override                  FALSE
_inmemory_small_segment_threshold        65536
_inmemory_query_fetch_by_rowid           FALSE
_inmemory_pruning                        ON
_inmemory_subcusize                      512
_inmemory_subcu_histsize                 0
_inmemory_enable_sys                     FALSE
_inmemory_populate_fg                    FALSE
_inmemory_pga_per_server                 536870912
inmemory_max_populate_servers            0
_inmemory_servers_throttle_pgalim_percen 55
t

inmemory_trickle_repopulate_servers_perc 1
ent

_inmemory_populate_wait                  FALSE
_inmemory_populate_wait_max              600
_inmemory_imco_cycle                     120
_inmemory_disable_alter_imco_cycle       FALSE
_inmemory_enable_population_verify       1
_inmemory_log_level                      0
_inmemory_fs_verify                      FALSE
_inmemory_force_fs                       FALSE
_inmemory_force_fs_tbs                   SYSAUX
_inmemory_force_fs_tbs_size              1073741824
_inmemory_fs_raise_error                 FALSE
_inmemory_fs_nodml                       FALSE
_inmemory_fs_enable                      TRUE
_inmemory_fsdw_enable                    TRUE
_inmemory_fsdw_populate_threshold_multip 10
lier

_inmemory_faststart_control_flags        0
_inmemory_fsdw_on_populate               TRUE
_inmemory_fsdw_penalty_threshold         20
_inmemory_fsdw_inline                    FALSE
_inmemory_fs_enable_blk_lvl_inv          TRUE
_inmemory_fsdw_cnt                       2147483647
_inmemory_fsdw_maxcnt                    10
_inmemory_fsdw_maxmem                    104755200
_inmemory_fsdw_threshold                 300
_inmemory_fsdw_priority_population_perce 100
nt

_inmemory_fsdw_priority_repopulation_per 90
cent

_inmemory_fsdw_priority_penalty_percent  10
_inmemory_fsdw_schedlrtm                 1
_inmemory_fsdw_scheduler_dedicated       FALSE
_inmemory_fs_blk_inv_blkcnt
_inmemory_fs_blk_inv_blk_percent         50
_inmemory_fs_prune_pct                   10
_inmemory_fs_dmlverify_read_ahead_cnt    10
_inmemory_fsdw_task_timeout              20
_inmemory_fs_tbsmaxsz
_inmemory_enable_stat_alert              FALSE
_inmemory_imcu_align                     TRUE
_inmemory_max_populate_retry             3
_inmemory_imcu_target_rows               0
_inmemory_imcu_target_bytes              0
_inmemory_imcu_source_extents            0
_inmemory_imcu_source_blocks             0
_inmemory_imcu_source_minbytes           1048576
_inmemory_imcu_populate_minbytes         5242880
_inmemory_imcu_source_analyze_bytes      134217728
_inmemory_imcu_target_maxrows            8388608
_inmemory_imcu_source_maxbytes           536870912
_inmemory_max_queued_tasks               0
_inmemory_repopulate_threshold_rows
_inmemory_repopulate_threshold_blocks
_inmemory_pct_inv_rows_invalidate_imcu   50
_inmemory_pct_inv_blocks_invalidate_imcu 100
_inmemory_repopulate_threshold_mintime_f 5
actor

_inmemory_repopulate_threshold_mintime   0
_inmemory_repopulate_threshold_scans     0
_inmemory_repopulate_priority_scale_fact 100
or

_inmemory_repopulate_invalidate_rate_per 0
cent

_inmemory_repopulate_priority_threshold_ 160
row

_inmemory_repopulate_priority_threshold_ 320
block

_inmemory_repopulate_threshold_rows_perc 5
ent

_inmemory_repopulate_threshold_blocks_pe 10
rcent

_inmemory_repopulate_disable             2
_inmemory_checksum                       FALSE
_inmemory_cu_checksum                    FALSE
_inmemory_validate_fetch                 FALSE
_inmemory_journal_row_logging            FALSE
inmemory_optimized_arithmetic            DISABLE
_inmemory_prefix_encode_dsbs             FALSE
_inmemory_vector_encode_override         FALSE
_inmemory_journal_check                  0
_inmemory_rows_check_interrupt           1000
_inmemory_enable_readonly                TRUE
_inmemory_repopulate_flags               2
_inmemory_hwm_expansion                  1
_inmemory_hwm_expansion_rac              0
_inmemory_populate_blocks_threshold      8
_inmemory_hwm_inv_blocks_threshold       64
_inmemory_dbg_scan                       0
_inmemory_query_check                    0
_inmemory_test_verification              0
_inmemory_invalidate_cursors             TRUE
_inmemory_prepopulate_fg                 0
inmemory_deep_vectorization              TRUE
_inmemory_hpk4sql_flags                  0
_inmemory_hpk4sql_debug                  0
_inmemory_hpk4sql_filter_threshold       1
_inmemory_hpk4sql_partbuf_maxrow         1024
_inmemory_hpk4sql_partbuf_minrow         8
_inmemory_hpk4sql_kv_seg_size            0
_inmemory_format_compatible              19.0.0
_inmemory_prepopulate                    TRUE
_inmemory_trickle_repopulate             TRUE
_inmemory_trickle_populate               TRUE
_inmemory_trickle_repopulate_threshold_d 0
irty_ratio

_inmemory_trickle_repopulate_min_interva 300
l

_inmemory_trickle_repopulate_fg          0
_inmemory_max_delta                      5
_inmemory_delta_population               0
_inmemory_min_delta_blocks               50
_inmemory_min_delta_rows                 255
_inmemory_scan_invalid_percent           30
_inmemory_external_table                 TRUE
_inmemory_parallel_load_ext              TRUE
_inmemory_dynamic_scans                  AUTO
_inmemory_dynamic_scans_batch_size       500
_inmemory_dynamic_scans_result_buffers   5000
_inmemory_dynamic_scans_analyze_batch_si 5
ze

_inmemory_dynamic_scan_disable_threshold 20
_inmemory_dynamic_scans_dbg              0
_inmemory_suppress_vsga_ima              FALSE
_inmemory_force_non_engineered           FALSE
_inmemory_hwm_expand_percent             20
_globaldict_enable                       2
_globaldict_chunk_minalloc               FALSE
_globaldict_use_ndv                      TRUE
_globaldict_dbg                          0
_globaldict_reprobe_limit                1
_globaldict_chain_limit                  32
_globaldict_check                        0
_globaldict_analyzer_pct                 100
_globaldict_max_gdsize                   1073741824
inmemory_automatic_level                 OFF
_imado_diagtasks_log_period              5
_imado_diagtasks_purge_period            30
_imado_sysaux_usage_limit                90
_imado_disable_bg                        FALSE
_imado_enable_coloptim                   TRUE
_kdmado_partial_pop_backoff_mb           64
_column_level_stats                      OFF
_imado_mem_threshold                     98
_imado_optim_algo                        GREEDY
_imado_optimize_period                   0
_imado_verification                      0
_imado_evict_sf                          2
_imado_enhancements                      0
_cellcache_default_flags                 2
_cellcache_default_new                   FALSE
_cellcache_clause_default
_index_load_buf_oltp_sacrifice_pct       10
_index_load_buf_oltp_under_pct           85
_index_load_buf_oltp_over_retry          0
_index_load_last_leaf_comp               85
_index_load_min_key_count                10
_index_load_analysis_frequency           4
_kdizoltp_uncompsentinal_freq            16
_kdfs_trace                              1
_kdfs_trace_size                         131072
_kdfs_timer_dmp                          FALSE
_kdfs_fix_control                        0
_worker_threads                          0
_advanced_index_compression_umem_options 2147483647
_advanced_index_compression_options      0
_advanced_index_compression_cmp_options  0
_advanced_index_compression_tst_options  0
_advanced_index_compression_opt_options  0
_advanced_index_compression_options_valu 0
e

_advanced_index_compression_recmp_cusz   90
_advanced_index_compression_recmp_crsz   10
_advanced_index_compression_recmp_nprg   10
_column_stats_mem_limit                  10
_column_stats_flush_interval             60
_column_stats_max_entries_per_stat       5
_kdkv_trace                              FALSE
_kdkv_force_fastpath                     FALSE
_kdkv_index_lossy                        TRUE
_kdkv_index_relocate                     FALSE
_kdkv_fg_populate                        FALSE
_kdkv_fg_no_memopt                       FALSE
_kdkv_fg_drop_memopt                     TRUE
_kdkv_fg_repopulate                      FALSE
_kdkv_indexinvalid                       FALSE
_kdkv_force_samehash                     FALSE
_kdfip_flush_nrows                       2147483647
_kdfip_flush_rowsz                       1048576
_kdfip_flush_rowtm                       60
_kdfip_cmap_nbkt                         16
_kdfip_iga_bufsz                         1048576
_kdfip_iga_maxsz                         2147483648
_kdfip_iga_minsz                         268435456
_kdfip_par_flush                         TRUE
_kdfip_trace                             FALSE
_kdfip_debug                             0
_kdfip_elem_nclatch                      64
_kdfip_bufl_nbkt                         128
_kdfip_drain_sleeps                      60
_kqr_optimistic_reads                    TRUE
_kqr_hot_copy_sample_size                1000000
_kqr_hot_copy_sleep_limit                500
_kqr_max_hot_copies                      16
_kqr_enable_conservative_logging         TRUE
_max_row_cache_dumps                     1000
_row_cache_dump_interval                 0
_row_cache_dump_cooling_period           10
_row_cache_cursors                       20
_kqdsn_instance_digits                   2
_kqdsn_cpu_digits                        3
_kgl_cluster_lock                        TRUE
_kgl_cluster_pin                         TRUE
_kgl_cluster_lock_read_mostly            FALSE
_kgl_latch_count                         0
_kgl_heap_size                           4096
_kgl_fixed_extents                       TRUE
_kgl_bucket_count                        9
_kgl_bucket_bitvector                    TRUE
_kgl_bucket_bitvector_clear              TRUE
_library_cache_advice                    TRUE
_kglsim_maxmem_percent                   5
_kgl_hash_collision                      FALSE
_kgl_time_to_wait_for_locks              15
_kgl_large_heap_warning_threshold        52428800
_kgl_large_heap_assert_threshold         524288000
_synonym_repoint_tracing                 FALSE
_ignore_fg_deps
_trace_kqlidp                            FALSE
_force_standard_compile                  FALSE
_disable_fast_validate                   FALSE
_kgl_message_locks                       0
_kql_clientlocks_enabled                 15
_kgl_debug
_mutex_wait_time                         1
_mutex_spin_count                        255
_mutex_wait_scheme                       2
_kgl_min_cached_so_count                 1
_kgl_hot_object_copies                   0
_kgl_kqr_cap_so_stacks                   0
_invalidate_upon_revoke                  TRUE
_pseudo_bootstrap                        FALSE
_kgl_iterator_action                     SKIP
_max_library_cache_dumps                 1000
_library_cache_dump_interval             0
_library_cache_dump_cooling_period       10
_spec_replace_locks_body                 TRUE
_enable_kqf_purge                        TRUE
create_stored_outlines
_object_number_cache_size                5
_enable_Front_End_View_Optimization      1
_max_remote_tool_requests                10
serial_reuse                             disable
_cursor_features_enabled                 2
_session_page_extent                     2048
_cursor_runtimeheap_memlimit             5242880
_kgx_latches                             1024
_cursor_stats_enabled                    TRUE
_enable_editions_for_users               FALSE
_disable_actualization_for_grant         FALSE
_ignore_edition_enabled_for_EV_creation  FALSE
_cvw_examine_tables_in_from_list_subqry  TRUE
ldap_directory_access                    NONE
_ldap_password_oneway_auth               FALSE
ldap_directory_sysauth                   no
os_roles                                 FALSE
rdbms_server_dn
_lock_dc_users_time                      120
_enable_secure_sub_role                  FALSE
remote_os_roles                          FALSE
_case_sensitive_logon                    TRUE
_VIEW_DICTIONARY_ACCESSIBILITY           FALSE
_restrict_become_user                    TRUE
_enable_http_digest_generation           TRUE
_nls_binary                              TRUE
mandatory_user_profile
_cloud_mandatory_profile_setup           FALSE
_allowed_pvf_owners
_disable_mandatory_profile_onclone       FALSE
_passwordfile_enqueue_timeout            900
remote_login_passwordfile                EXCLUSIVE
license_max_users                        0
_iat_frequency_short                     FALSE
_disable_inheritpriv_grant_public        FALSE
_dynamic_rls_policies                    TRUE
_virtual_column_access_control           TRUE
_allow_triggers_on_vpd_table             FALSE
_allow_insert_with_update_check          FALSE
_session_context_size                    10000
audit_sys_operations                     TRUE
_default_encrypt_alg                     0
_tsenc_obfuscate_key                     NONE
_db_discard_lost_masterkey               FALSE
_db_generate_dummy_masterkey             FALSE
_use_fips_mode                           FALSE
DBFIPS_140                               FALSE
one_step_plugin_for_pdb_with_tde         FALSE
external_keystore_credential_location
_heartbeat_period_multiplier             0
_heartbeat_config                        NONE
_redo_log_key_reuse_count                0
_stats_encryption_enabled                FALSE
_REMOVE_INACTIVE_STANDBY_TDE_MASTER_KEY  FALSE
_standby_newkey_keystore_location
_REMOVE_STDBY_OLD_KEY_AFTER_CHECKPOINT_S TRUE
CN

_ols_cleanup_task                        TRUE
_sys_logon_delay                         1
_pbkdf2_sder_count                       3
_enforce_minimum_password_rollover_time  TRUE
_resource_includes_unlimited_tablespace  FALSE
_grant_unlimited_tablespace_role         FALSE
_priv_for_set_current_schema             FALSE
_xs_cleanup_task                         TRUE
_xs_logon_grant                          FALSE
_xds_max_child_cursors                   100
_fusion_security                         TRUE
_radm_enabled                            TRUE
_strict_redaction_semantics              TRUE
_xs_dispatcher_only                      FALSE
_xs_sidp_allow_sha1                      TRUE
_unified_audit_policy_disabled           FALSE
_asm_audit_sp_param
_disable_asm_audit_feat                  0
_ldap_config_ssl_for_sasl_md5            TRUE
_ldap_config_force_sync_up               FALSE
_ldap_reset_user_account_flc             TRUE
_ldap_no_nested_group_search             FALSE
_ldap_adaptive_to_no_nested_group_search TRUE
_ldap_use_all_direct_groups_only         TRUE
_ldap_warning_on_multi_shared_mappings   FALSE
wallet_root
tde_configuration
pkcs11_library_location
tde_key_cache                            FALSE
heartbeat_batch_size                     5
_purge_idcs_access_token                 FALSE
db_domain
global_names                             FALSE
distributed_lock_timeout                 60
_distributed_recovery_connection_hold_ti 200
me

_reco_sessions_max_percentage            50
commit_point_strength                    1
_k2q_latches                             0
_clusterwide_global_transactions         TRUE
global_txn_processes                     1
_autotune_gtx_threshold                  60
_forwarded_2pc_threshold                 10
_disable_autotune_gtx                    FALSE
_autotune_gtx_interval                   5
_autotune_gtx_idle_time                  600
_enable_separable_transactions           FALSE
_xa_internal_retries                     600
_restrict_db_link_user_entries           10000
_db_link_sources_tracking                TRUE
_external_scn_activity_tracking          TRUE
instance_name                            ORA21C
dispatchers                              (PROTOCOL=TCP) (SERVICE=ORA21C
                                         XDB)

shared_servers                           1
max_shared_servers
max_dispatchers
circuits
shared_server_sessions
_pmon_load_constants                     300,192,64,3,10,10,0,0
_dispatcher_rate_ttl
_dispatcher_rate_scale
_enable_shared_server_vector_io          FALSE
_shared_server_load_balance              0
_enable_shared_server_sizing             TRUE
_enable_shared_server_sizing_slope       FALSE
_shared_server_sizing_coeff              1000
_shared_servers_performance              0
_dispatcher_listen_on_vip                FALSE
_shared_server_num_queues                1
_kernel_message_network_driver           FALSE
_dedicated_server_poll_count             10
_dedicated_server_post_wait_call         FALSE
_dedicated_server_post_wait              FALSE
use_dedicated_broker                     FALSE
_mpmt_fg_enabled                         FALSE
_bequeath_via_broker                     FALSE
connection_brokers                       ((TYPE=DEDICATED)(BROKERS=1)),
                                          ((TYPE=EMON)(BROKERS=1))

_cp_num_hash_latches
_cp_del_free_sess                        TRUE
_cp_del_free_sess_limit_secs             1
_connection_broker_host                  localhost
_connection_broker_handout_accept        FALSE
local_listener                           LISTENER_ORA21C
forward_listener
remote_listener
listener_networks
__reload_lsnr                            0
_disable_duplicate_service_warning       FALSE
_pdb_service_on_root_listener            FALSE
_enable_gsm_listener_networks            TRUE
_singleton_service_goodness_disabled     TRUE
_ignore_pdb_listener                     FALSE
_listener_registration_retry_secs        60
_fast_cursor_reexecute                   FALSE
cursor_space_for_time                    FALSE
session_cached_cursors                   50
_cursor_obsolete_threshold               8192
_disable_cursor_sharing                  FALSE
_cursor_reload_failure_threshold         0
_cursor_diagnostic_node_agedout_count    100
_max_sql_stmt_length                     0
_monitor_sql_stmt_length                 FALSE
_kks_cached_parse_errors                 0
_kks_obsolete_dump_threshold             1
_kks_parse_error_warning                 100
_kks_always_check_bind_equivalence       FALSE
_dump_qbc_tree                           0
_sql_alias_scope                         TRUE
remote_dependencies_mode                 TIMESTAMP
smtp_out_server
_plsql_dump_buffer_events
plsql_v2_compatibility                   FALSE
_ncomp_shared_objects_dir
plsql_warnings                           DISABLE:ALL
plsql_code_type                          INTERPRETED
_plsql_anon_block_code_type              INTERPRETED
plsql_debug                              FALSE
plsql_optimize_level                     2
plsql_ccflags
_inline_sql_in_plsql                     FALSE
plscope_settings                         IDENTIFIERS:NONE
_plsql_native_frame_threshold            4294967294
_plsql_nvl_optimize                      FALSE
_plsql_icd_arg_dump                      FALSE
_plsql_max_stack_size                    0
permit_92_wrap_format                    FALSE
_EnableShadowTypes                       FALSE
java_jit_enabled                         TRUE
java_restrict                            none
job_queue_processes                      20
_post_run_job_evaluation                 FALSE
_job_queue_interval                      5
scheduler_follow_pdbtz                   FALSE
_redef_on_statement                      FALSE
_duplicated_table_complete_refresh_perce 50
nt

_dbms_sql_security_level                 1
parallel_min_percent                     0
_parallel_default_max_instances          1
_system_trig_enabled                     TRUE
_AllowMultInsteadofDDLTrigger            0
_kktAllowInsteadOfDDLTriggeronDDL        0
_EnableDDLTtriggerTracing                FALSE
create_bitmap_area_size                  8388608
bitmap_merge_area_size                   1048576
_kkfi_trace                              FALSE
_lock_ref_constraint_count               50
_lock_next_constraint_count              3
cursor_sharing                           EXACT
_adjust_literal_replacement              FALSE
_kolfuseslf                              FALSE
_lock_ref_descendants_count              50
_kkpogpi_nocpy                           1
_kkpox_prtmv_rel_lock                    0
_system_partition_with_default           FALSE
_autotbs_management_enabled              FALSE
_create_idx_from_constraint              FALSE
_onl_pmo_wait_query                      0
_onl_pmo_wait_timeout                    0
_onl_ddl_progress                        3
_online_pmo_global_index_method          CLEANUP ONLY
_result_cache_auto_size_threshold        100
_result_cache_auto_time_threshold        1000
_result_cache_auto_execution_threshold   1
_result_cache_deterministic_plsql        FALSE
_max_string_size_bypass                  0
_qkslvc_extended_bind_sz                 1
_qkslvc_47510_test                       0
_qkslvc_47510_sys                        1
_utl32k_mv_query                         FALSE
_STFTranslateDynamicSQL                  FALSE
_STFForceTranslateOracleSQL              FALSE
_bigdata_external_table                  TRUE
_external_table_hive_partition_restricte TRUE
d

_qksfgi_disable_action_mask              0
_qksfgi_disable_oct_mask                 0
_qksfgi_dynamic_partitions
_qksfgi_feature_level                    0
_qksfgi_dix_val                          FALSE
_kkpap_zm_pruning_cache                  TRUE
_subquery_pruning_flags                  0
_autoptn_translate_table_name
_autoptn_costing                         FALSE
_autoptn_workload_id                     0
_autoptn_flags                           0
_session_cached_instantiations           60
_protect_frame_heaps                     FALSE
_frame_cache_time                        0
_cursor_cache_time                       900
_aged_out_cursor_cache_time              300
_kxscio_cap_stacks                       FALSE
_plsql_share_instantiation               TRUE
_px_trace                                none
_xt_trace                                none
_xt_coverage                             none
_ku_trace                                none
_optimizer_trace                         none
parallel_min_servers                     2
parallel_max_servers                     20
_parallel_server_idle_time               30000
_parallel_server_sleep_time              1
_px_send_timeout                         300
_dynamic_stats_threshold                 30
parallel_instance_group
_px_execution_services_enabled           TRUE
_parallel_fake_class_pct                 0
_px_load_publish_interval                200
_px_proactive_slave_alloc_threshold      2
_px_load_balancing_policy                UNIFORM
_px_dp_array_size                        32767
_px_parallel_spawn_min_count             2
_px_increase_join_frag_size              TRUE
_px_oneslave_per_instance_parse          TRUE
parallel_execution_message_size          16384
_parallel_execution_message_align        FALSE
_PX_use_large_pool                       FALSE
_parallel_min_message_pool               491520
_px_buffer_ttl                           30
_tq_dump_period                          0
_affinity_on                             TRUE
_enable_default_affinity                 0
_px_max_map_val                          32
_dss_cache_flush                         FALSE
_dss_cache_flush_threshold               1
_hash_join_enabled                       TRUE
hash_area_size                           131072
_hash_multiblock_io_count                0
_cursor_db_buffers_pinned                761
_old_connect_by_enabled                  FALSE
_table_lookup_prefetch_size              40
_multi_join_key_table_lookup             TRUE
_table_lookup_prefetch_thresh            2
_adaptive_fetch_enabled                  TRUE
_query_execution_cache_max_size          131072
_fast_dual_enabled                       TRUE
_newsort_enabled                         TRUE
_newsort_type                            0
_newsort_ordered_pct                     63
_recursive_with_max_recursion_level      0
_sort_spill_threshold                    0
_queue_buffer_max_dump_len               65536
_force_hash_join_spill                   FALSE
_nlj_batching_ae_flag                    2
_sort_sync_min_spillsize                 262144
_sort_sync_min_spill_threshold           90
_sqlexec_cache_aware_hash_join_enabled   TRUE
_sqlexec_encoding_aware_hj_enabled       TRUE
_sqlexec_sort_uses_xmem                  TRUE
_sqlexec_hash_join_uses_xmem             FALSE
_sqlexec_encoding_aware_hj_min_compressi 8
on_ratio

_sqlexec_join_group_aware_hj_enabled     TRUE
_sqlexec_join_group_aware_hj_unencoded_r 50
owsets_tolerated

_sqlexec_cache_aware_hash_aggr_enabled   TRUE
_sqlexec_bitmap_options                  0
_sqlexec_bitmap_sparse_size              100
_sysdate_at_dbtimezone                   FALSE
_sqlexec_hash_aggr_small_mem_blocks      2
timezone_version_upgrade_online          FALSE
_in_memory_cdt                           LIMITED
_in_memory_ts_only                       OFF
_in_memory_memory_threshold              40
_in_memory_cdt_maxpx                     4
_ptt_max_num                             16
private_temp_table_prefix                ORA$PTT_
_in_memory_cleanup_wait_timeout          10000
_fix_control
_sdiag_crash                             NONE
result_cache_mode                        MANUAL
_obsolete_result_cache_mode              MANUAL
result_cache_max_size                    12582912
result_cache_max_result                  5
result_cache_remote_expiration           0
_result_cache_block_size                 4096
_result_cache_copy_block_count           1
_result_cache_global                     TRUE
_result_cache_per_pdb                    TRUE
_result_cache_timeout                    1
_result_cache_white_list
_result_cache_black_list
_result_cache_latch_free_reads           ADMIN
_result_cache_do_recycle_period          300
_result_cache_object_black_list          0
_result_cache_latch_count                1
result_cache_execution_threshold         2
_result_cache_history_size               0
result_cache_max_temp_size               125829120
result_cache_max_temp_result             5
_result_cache_global_send                TRUE
_result_cache_load_rate                  1
_result_cache_use_hash_table             TRUE
_result_cache_auto_time_distance         300
_result_cache_auto_dml_monitoring_slots  4
_result_cache_auto_dml_monitoring_durati 15
on

_result_cache_auto_dml_threshold         16
_result_cache_auto_dml_trend_threshold   20
_parallel_queuing_max_waitingtime
_cell_offload_expressions                TRUE
_cell_materialize_virtual_columns        TRUE
_cell_materialize_all_expressions        FALSE
_cell_offload_sys_context                TRUE
_gby_vector_aggregation_enabled          TRUE
_key_vector_max_size                     0
_key_vector_predicate_enabled            TRUE
_key_vector_predicate_threshold          0
_key_vector_offload                      predicate
_vector_operations_control               0
_vector_serialize_temp_threshold         1000
_always_vector_transformation            FALSE
_vector_aggregation_max_size             0
_vector_dense_accum_max                  100
_key_vector_create_pushdown_threshold    20000
_key_vector_alternate_dictionary         TRUE
_key_vector_force_alternate_dictionary   FALSE
_key_vector_shared_dgk_ht                TRUE
_key_vector_double_enabled               TRUE
_key_vector_timestamp_enabled            TRUE
_cell_offload_vector_groupby_withnojoin  TRUE
_key_vector_join_pushdown_enabled        TRUE
_cell_offload_grand_total                TRUE
_ptf_max_rows                            1024
_qesma_mvob_lru_sz                       25
_qesma_bo_lru_sz                         25
_qesmasc_trc                             0
_ptf_enable_objects                      FALSE
_shard_sesscache_cnt                     0
_oss_skgxp_udp_dynamic_credit_mgmt
shadow_core_dump                         partial
background_core_dump                     partial
background_dump_dest                     /oracle/app/oracle/homes/OraDB
                                         21Home1/rdbms/log

user_dump_dest                           /oracle/app/oracle/homes/OraDB
                                         21Home1/rdbms/log

core_dump_dest                           /oracle/app/oracle/diag/rdbms/
                                         ora21c/ORA21C/cdump

_oradbg_pathname
_shmprotect                              0
_crash_domain_on_exception               0
_online_patch_disable_stack_check        FALSE
_vendor_lib_loc
_disable_sun_rsm                         TRUE
_ipc_test_failover                       0
_ipc_test_mult_nets                      0
_ipc_fail_network                        0
audit_file_dest                          /oracle/app/oracle/admin/ORA21
                                         C/adump

audit_syslog_level
unified_audit_systemlog
unified_audit_common_systemlog
_enable_event_ports                      TRUE
_event_port_opts
_enable_thr_kill                         TRUE
_sem_per_semid
_ops_per_semop
_use_futex_ipc                           FALSE
_posix_spawn_enabled                     TRUE
_datapump_inherit_svcname                TRUE
_mdapi_transform_engine                  LPX
_disable_streams_diagnostics             0
resource_manage_goldengate               FALSE
_max_gg_extracts                         65535
_max_aq_persistent_queue_memory          10
object_cache_optimal_size                10240000
object_cache_max_size_percent            10
_no_objects                              FALSE
lob_signature_enable                     FALSE
_kokli_cache_size                        128
_kokln_current_read                      FALSE
session_max_open_files                   10
_domain_index_batch_size                 2000
_domain_index_dml_batch_size             200
_odci_aggregate_save_space               FALSE
_odci_index_pmo_rebuild                  FALSE
_nchar_imp_conv                          TRUE
_insert_enable_hwm_brokered              TRUE
_pgactx_cap_stacks                       FALSE
open_links                               4
open_links_per_instance                  4
_all_shared_dblinks
_disttxn_for_queries                     TRUE
_close_cached_open_cursors               FALSE
_disable_savepoint_reset                 FALSE
commit_write
commit_wait
commit_logging
_init_sql_file                           ?/rdbms/admin/sql.bsq
optimizer_features_enable                21.1.0
fixed_date
audit_trail                              DB
sort_area_size                           65536
sort_area_retained_size                  0
_sort_multiblock_read_count              2
_shrunk_aggs_enabled                     TRUE
_sql_ncg_mode                            OFF
_cell_storidx_mode                       EVA
_cell_storidx_minmax_enabled             TRUE
_deferred_constant_folding_mode          DEFAULT
_rdbms_internal_fplib_raise_errors       FALSE
_rdbms_internal_fplib_enabled            FALSE
_cell_index_scan_enabled                 TRUE
_cell_range_scan_enabled                 TRUE
_cell_offload_virtual_columns            TRUE
_cell_offload_predicate_reordering_enabl FALSE
ed

_cell_offload_timezone                   TRUE
_direct_read_decision_statistics_driven  TRUE
cell_offload_processing                  TRUE
_cell_offload_hybrid_processing          TRUE
_cell_offload_complex_processing         TRUE
cell_offload_decryption                  TRUE
cell_offload_parameters
_cell_metadata_compression               AUTO
cell_offload_compaction                  ADAPTIVE
cell_offload_plan_display                AUTO
_cell_offload_vector_groupby             TRUE
_cell_offload_vector_groupby_force       FALSE
_shrunk_aggs_disable_threshold           60
_gby_onekey_enabled                      TRUE
db_name                                  ORA21C
db_unique_name                           ORA21C
open_cursors                             300
ifile
sql_trace                                FALSE
os_authent_prefix                        ops$
_sql_connect_capability_table
optimizer_mode                           ALL_ROWS
_optimizer_mode_force                    TRUE
_explain_rewrite_mode                    FALSE
_query_rewrite_or_error                  FALSE
_sort_elimination_cost_ratio             0
sql92_security                           TRUE
_grant_secure_role                       FALSE
_enable_ptime_update_for_sys             FALSE
_sql_connect_capability_override         0
blank_trimming                           FALSE
_always_anti_join                        CHOOSE
_optimizer_null_aware_antijoin           TRUE
_optimizer_partial_join_eval             TRUE
_partition_view_enabled                  TRUE
_always_star_transformation              FALSE
_b_tree_bitmap_plans                     TRUE
star_transformation_enabled              FALSE
_column_elimination_off                  FALSE
_cpu_to_io                               0
_optimizer_extended_cursor_sharing       UDO
_optimizer_extended_cursor_sharing_rel   SIMPLE
_optimizer_adaptive_cursor_sharing       TRUE
_optimizer_cost_model                    CHOOSE
_optimizer_undo_cost_change              21.1.0
_optimizer_system_stats_usage            TRUE
_optimizer_cache_stats                   FALSE
_new_sort_cost_estimate                  TRUE
_complex_view_merging                    TRUE
_simple_view_merging                     TRUE
_unnest_subquery                         TRUE
_optimizer_unnest_all_subqueries         TRUE
_optimizer_unnest_scalar_sq              TRUE
_eliminate_common_subexpr                TRUE
_pred_move_around                        TRUE
_convert_set_to_join                     FALSE
_px_bind_peek_sharing                    TRUE
_px_ual_serial_input                     TRUE
_px_minus_intersect                      TRUE
_remove_aggr_subquery                    TRUE
_distinct_view_unnesting                 FALSE
_optimizer_push_down_distinct            0
_optimizer_cost_based_transformation     LINEAR
_optimizer_squ_bottomup                  TRUE
_optimizer_cbqt_factor                   50
_push_join_predicate                     TRUE
_push_join_union_view                    TRUE
_push_join_union_view2                   TRUE
_fast_full_scan_enabled                  TRUE
_optimizer_skip_scan_enabled             TRUE
_optimizer_join_sel_sanity_check         TRUE
_optim_enhance_nnull_detection           TRUE
_enable_cscn_caching                     FALSE
_parallel_broadcast_enabled              TRUE
_px_broadcast_fudge_factor               100
_px_kxib_tracing                         0
_px_granule_size                         1000000
_px_chunk_size                           1000000
_px_xtgranule_size                       10000
_xtbigdata_max_buffersize                10240
_xtbuffer_size                           0
parallel_degree_policy                   MANUAL
_px_min_granules_per_slave               13
_px_split_batches_per_slave              7
_px_split_use_single_list                TRUE
_px_split_multi_msg                      TRUE
_px_max_granules_per_slave               100
_px_no_stealing                          FALSE
_px_no_granule_sort                      FALSE
_px_proc_constrain                       TRUE
_px_freelist_latch_divisor               2
parallel_adaptive_multi_user             FALSE
parallel_threads_per_cpu                 1
_parallel_adaptive_max_users             4
_parallel_cluster_cache_policy           ADAPTIVE
_parallel_load_balancing                 TRUE
_parallel_load_bal_unit                  0
_parallel_slave_acquisition_wait         1
_px_io_system_bandwidth                  0
_px_io_process_bandwidth                 200
_pdml_slaves_diff_part                   TRUE
_pdml_gim_sampling                       5000
_pdml_gim_staggered                      FALSE
_px_dynamic_opt                          TRUE
_px_dynamic_sample_size                  50
_px_rownum_pd                            TRUE
_predicate_elimination_enabled           TRUE
_groupby_nopushdown_cut_ratio            3
_groupby_orderby_combine                 5000
_temp_tran_block_threshold               100
_temp_tran_cache                         TRUE
_ordered_semijoin                        TRUE
_always_semi_join                        CHOOSE
_ordered_nested_loop                     TRUE
_nested_loop_fudge                       100
_project_view_columns                    TRUE
_no_or_expansion                         FALSE
_optimizer_max_permutations              2000
optimizer_index_cost_adj                 100
optimizer_index_caching                  0
_system_index_caching                    0
_serial_direct_read                      auto
_disable_datalayer_sampling              FALSE
_disable_sample_io_optim                 FALSE
_sample_rows_per_block                   4
_ncmb_readahead_enabled                  0
_ncmb_readahead_tracing                  0
_nlj_batching_enabled                    1
_nlj_batching_misses_enabled             1
_ioq_fanin_multiplier                    2
_index_prefetch_factor                   100
query_rewrite_enabled                    TRUE
query_rewrite_integrity                  enforced
_query_cost_rewrite                      TRUE
_query_rewrite_2                         TRUE
_query_rewrite_1                         TRUE
_query_rewrite_fudge                     90
_query_rewrite_expression                TRUE
_query_rewrite_jgmigrate                 TRUE
_query_rewrite_fpc                       TRUE
_query_rewrite_drj                       FALSE
_query_rewrite_maxdisjunct               257
_query_rewrite_vop_cleanup               TRUE
_mmv_query_rewrite_enabled               TRUE
_bt_mmv_query_rewrite_enabled            TRUE
_add_stale_mv_to_dependency_list         TRUE
_max_rwgs_groupings                      8192
_full_pwise_join_enabled                 TRUE
_partial_pwise_join_enabled              TRUE
_slave_mapping_enabled                   TRUE
_slave_mapping_group_size                0
_local_communication_costing_enabled     TRUE
_local_communication_ratio               50
_parallelism_cost_fudge_factor           350
_left_nested_loops_random                TRUE
_improved_row_length_enabled             TRUE
_px_object_sampling                      200
_px_object_sampling_multiplier           2
_index_join_enabled                      TRUE
_use_nosegment_indexes                   FALSE
_enable_type_dep_selectivity             TRUE
_improved_outerjoin_card                 TRUE
_optimizer_adjust_for_nulls              TRUE
_optimizer_degree                        0
_use_column_stats_for_function           TRUE
_subquery_pruning_cost_factor            20
_subquery_pruning_reduction              50
_subquery_pruning_enabled                TRUE
_subquery_pruning_mv_enabled             FALSE
_parallel_txn_global                     FALSE
_or_expand_nvl_predicate                 TRUE
_like_with_bind_as_equality              FALSE
_table_scan_cost_plus_one                TRUE
_cost_equality_semi_join                 TRUE
_default_non_equality_sel_check          TRUE
_new_initial_join_orders                 TRUE
_oneside_colstat_for_equijoins           TRUE
_column_tracking_level                   53
_optim_peek_user_binds                   TRUE
_mv_refresh_selections                   TRUE
_cursor_plan_enabled                     TRUE
_minimal_stats_aggregation               TRUE
_mv_complete_refresh_conventional        FALSE
_mv_refresh_eut                          TRUE
_mav_refresh_consistent_read             TRUE
_mav_refresh_opt                         0
_mav_refresh_unionall_tables             3
_mv_refresh_delta_fraction               10
_mv_expression_extend_size               4096
_force_temptables_for_gsets              FALSE
pga_aggregate_target                     835715072
__pga_aggregate_target                   838860800
_pga_max_size                            209715200
workarea_size_policy                     AUTO
_smm_auto_min_io_size                    56
_smm_auto_max_io_size                    248
_smm_auto_cost_enabled                   TRUE
_smm_control                             0
_smm_trace                               0
_smm_min_size                            816
_smm_max_size_static                     102400
_smm_px_max_size_static                  408064
_smm_max_size                            102400
_smm_px_max_size                         408064
_smm_retain_size                         0
_smm_bound                               0
_smm_advice_log_size                     0
_smm_advice_enabled                      TRUE
_gs_anti_semi_join_allowed               TRUE
_mv_refresh_use_stats                    FALSE
_mv_refresh_use_no_merge                 TRUE
_mv_refresh_use_hash_sj                  TRUE
_no_stale_joinback_rewrite               FALSE
_mv_refresh_no_idx_rebuild               FALSE
_mv_deferred_no_log_age_val              TRUE
_mv_add_log_placeholder                  TRUE
_optim_new_default_join_sel              TRUE
_optimizer_dyn_smp_blks                  32
optimizer_dynamic_sampling               2
_pre_rewrite_push_pred                   TRUE
_optimizer_new_join_card_computation     TRUE
_mav_refresh_double_count_prevented      FALSE
_pct_refresh_double_count_prevented      TRUE
_mv_refresh_new_setup_disabled           FALSE
_load_without_compile                    none
_precompute_gid_values                   TRUE
_union_rewrite_for_gs                    YES_GSET_MVS
_nested_mv_fast_oncommit_enabled         TRUE
_generalized_pruning_enabled             TRUE
_rowsource_execution_statistics          FALSE
_rowsource_profiling_statistics          TRUE
_rowsource_statistics_sampfreq           128
_bitmap_or_improvement_enabled           TRUE
_intrapart_pdml_enabled                  TRUE
_force_tmp_segment_loads                 FALSE
_force_slave_mapping_intra_part_loads    FALSE
_intrapart_pdml_randomlocal_enabled      TRUE
_optim_adjust_for_part_skews             TRUE
_optimizer_compute_index_stats           TRUE
_optimizer_autostats_job                 TRUE
_optimizer_push_pred_cost_based          TRUE
_optimizer_extend_jppd_view_types        TRUE
_optimizer_filter_pred_pullup            TRUE
_optimizer_connect_by_cost_based         TRUE
_optimizer_connect_by_combine_sw         TRUE
_optimizer_connect_by_elim_dups          TRUE
_connect_by_use_union_all                TRUE
_force_datefold_trunc                    FALSE
statistics_level                         TYPICAL
_array_update_vector_read_enabled        FALSE
_two_pass_reverse_polish_enabled         TRUE
_expand_aggregates                       TRUE
_dump_common_subexpressions              FALSE
_spr_use_AW_AS                           TRUE
_dump_connect_by_loop_data               FALSE
_column_compression_factor               0
_dml_monitoring_enabled                  TRUE
_fic_algorithm_set                       automatic
_fic_area_size                           131072
_fic_min_bmsize                          1024
_dtree_area_size                         131072
_dtree_pruning_enabled                   TRUE
_dtree_binning_enabled                   TRUE
_dtree_max_surrogates                    1
_right_outer_hash_enable                 TRUE
_optimizer_mjc_enabled                   TRUE
_optimizer_sortmerge_join_enabled        TRUE
_cursor_bind_capture_area_size           400
cursor_bind_capture_destination          memory+disk
_flush_plan_in_awr_sql                   0
_cursor_bind_capture_interval            900
_dump_cursor_heap_sizes                  FALSE
_projection_pushdown                     TRUE
_projection_pushdown_debug               0
_px_compilation_debug                    0
_px_compilation_trace                    0
_trace_virtual_columns                   FALSE
_replace_virtual_columns                 TRUE
_virtual_column_overload_allowed         TRUE
_kdt_buffering                           TRUE
_disable_parallel_conventional_load      FALSE
_ltc_trace                               0
_print_refresh_schedule                  false
_optimizer_undo_changes                  FALSE
_optimizer_percent_parallel              101
_optimizer_search_limit                  5
skip_unusable_indexes                    TRUE
_mv_refresh_costing                      rule
_mv_refresh_ana                          0
_cache_stats_monitor                     FALSE
_sta_control                             0
_enable_automatic_sqltune                TRUE
_sql_analyze_enable_auto_txn             FALSE
_ds_enable_auto_txn                      FALSE
_sql_analyze_parse_model                 2
_ds_parse_model                          2
_kes_parse_model                         2
_ds_iocount_iosize                       6553664
_ds_xt_split_count                       1
_ds_progressive_no_matches_min_sample_si 50
ze

_ds_progressive_initial_samples          2
_ds_sampling_method                      PROGRESSIVE
_ds_enable_view_sampling                 TRUE
_mv_refsched_timeincr                    300000
_spr_push_pred_refspr                    TRUE
_optimizer_block_size                    8192
_spr_max_rules                           10000
_idxrb_rowincr                           100000000
_hj_bit_filter_threshold                 50
_optimizer_save_stats                    TRUE
_optimizer_cost_filter_pred              FALSE
_optimizer_correct_sq_selectivity        TRUE
_allow_commutativity                     TRUE
_mv_refresh_rebuild_percentage           10
_qa_control                              0
_qa_lrg_type                             0
_mv_refresh_force_parallel_query         0
_enable_fast_ref_after_mv_tbs            FALSE
_optim_dict_stats_at_db_cr_upg           TRUE
_utlmmig_table_stats_gathering           TRUE
_remove_exf_component                    TRUE
_optimizer_dim_subq_join_sel             TRUE
_optimizer_disable_strans_sanity_checks  0
_allow_level_without_connect_by          FALSE
optimizer_ignore_hints                   FALSE
_optimizer_random_plan                   0
_optimizer_ceil_cost                     TRUE
_delay_index_maintain                    TRUE
_query_rewrite_setopgrw_enable           TRUE
_cursor_plan_hash_version                1
_disable_function_based_index            FALSE
_optimizer_invalidation_period           18000
_px_net_msg_cost                         10000
_px_loc_msg_cost                         1000
_smm_freeable_retain                     5120
_cursor_plan_unparse_enabled             TRUE
_kill_java_threads_on_eoc                FALSE
_optimizer_join_order_control            3
_px_nss_planb                            TRUE
_bloom_filter_enabled                    TRUE
_bloom_filter_debug                      0
_bloom_filter_size                       0
_bloom_predicate_enabled                 TRUE
_bloom_predicate_offload                 TRUE
_bloom_folding_enabled                   TRUE
_bloom_folding_density                   16
_bloom_folding_min                       0
_bloom_pushing_max                       512
_bloom_max_size                          262144
_bloom_pushing_total_max                 262144
_bloom_minmax_enabled                    TRUE
_bloom_rm_filter                         FALSE
_bloom_sm_enabled                        TRUE
_bloom_serial_filter                     ON
_enable_refresh_schedule                 TRUE
_optimizer_cartesian_enabled             TRUE
_optimizer_starplan_enabled              TRUE
_optimizer_join_elimination_enabled      TRUE
_gby_hash_aggregation_enabled            TRUE
_extended_pruning_enabled                TRUE
_globalindex_pnum_filter_enabled         TRUE
_sql_model_unfold_forloops               RUN_TIME
_enable_dml_lock_escalation              TRUE
_plsql_cache_enable                      TRUE
_disable_fast_aggregation                FALSE
_disable_adaptive_shrunk_aggregation     FALSE
_plsql_minimum_cache_hit_percent         20
_plan_outline_data                       TRUE
_outline_bitmap_tree                     TRUE
_drop_table_optimization_enabled         TRUE
_drop_table_granule                      256
_xpl_trace                               0
_dm_max_shared_pool_pct                  5
_optimizer_multiple_cenv
_kql_subheap_trace                       0
_optimizer_cost_hjsmj_multimatch         TRUE
_optimizer_transitivity_retain           TRUE
optimizer_secure_view_merging            TRUE
_px_pwg_enabled                          TRUE
_sql_hash_debug                          0
_mv_rolling_inv                          FALSE
_smm_isort_cap                           102400
_optimizer_cbqt_no_size_restriction      TRUE
_windowfunc_optimization_settings        0
_truncate_optimization_enabled           TRUE
_optimizer_enhanced_filter_push          TRUE
_compilation_call_heap_extent_size       16384
_xpl_peeked_binds_log_size               8192
_rowsrc_trace_level                      0
_optimizer_rownum_pred_based_fkr         TRUE
_optimizer_better_inlist_costing         ALL
_optimizer_self_induced_cache_cost       FALSE
_optimizer_min_cache_blocks              10
_enable_exchange_validation_using_check  TRUE
_optimizer_or_expansion                  DEPTH
_optimizer_outer_to_anti_enabled         TRUE
_optimizer_order_by_elimination_enabled  TRUE
_optimizer_star_tran_in_with_clause      TRUE
_optimizer_sortmerge_join_inequality     TRUE
_selfjoin_mv_duplicates                  TRUE
_dimension_skip_null                     TRUE
_force_rewrite_enable                    FALSE
_optimizer_complex_pred_selectivity      TRUE
_build_deferred_mv_skipping_mvlog_update TRUE
_bloom_pruning_enabled                   TRUE
_query_mmvrewrite_maxpreds               10
_query_mmvrewrite_maxintervals           5
_query_mmvrewrite_maxinlists             5
_query_mmvrewrite_maxdmaps               10
_query_mmvrewrite_maxcmaps               20
_query_mmvrewrite_maxregperm             512
_row_shipping_threshold                  100
_row_shipping_explain                    FALSE
_query_mmvrewrite_maxqryinlistvals       500
_first_k_rows_dynamic_proration          TRUE
_optimizer_aw_stats_enabled              TRUE
_enable_row_shipping                     TRUE
_optimizer_skip_scan_guess               FALSE
_optimizer_distinct_elimination          TRUE
_add_col_optim_enabled                   TRUE
_optimizer_multi_level_push_pred         TRUE
ddl_lock_timeout                         0
_enable_ddl_wait_lock                    TRUE
deferred_segment_creation                TRUE
_optimizer_group_by_placement            TRUE
_optimizer_distinct_placement            TRUE
_optimizer_coalesce_subqueries           TRUE
_optimizer_enable_density_improvements   TRUE
_optimizer_rownum_bind_default           10
_enable_query_rewrite_on_remote_objs     TRUE
_enable_scn_wait_interface               TRUE
optimizer_use_pending_statistics         FALSE
_optimizer_improve_selectivity           TRUE
_optimizer_aw_join_push_enabled          TRUE
_cvw_enable_weak_checking                TRUE
optimizer_capture_sql_plan_baselines     FALSE
optimizer_use_sql_plan_baselines         TRUE
_enable_online_index_without_s_locking   TRUE
_dbop_enabled                            1
_sqlmon_threshold                        5
_sqlmon_max_plan                         20
_sqlmon_max_planlines                    1000
_sqlmon_recycle_time                     5
_sqlmon_binds_xml_format                 default
_optimizer_native_full_outer_join        FORCE
_optimizer_ansi_join_lateral_enhance     TRUE
_optimizer_multi_table_outerjoin         TRUE
_optimizer_null_accepting_semijoin       TRUE
_optimizer_ansi_rearchitecture           TRUE
_optimizer_aggr_groupby_elim             TRUE
_optimizer_enable_extended_stats         TRUE
_direct_path_insert_features             0
_optimizer_free_transformation_heap      TRUE
_pivot_implementation_method             CHOOSE
_optimizer_use_subheap                   TRUE
_optimizer_or_expansion_subheap          TRUE
_optimizer_star_trans_min_cost           0
_optimizer_star_trans_min_ratio          0
_with_subquery                           OPTIMIZER
_optimizer_reuse_cost_annotations        TRUE
_optimizer_interleave_jppd               TRUE
_optimizer_fkr_index_cost_bias           10
_px_dump_12805_source                    TRUE
parallel_min_time_threshold              AUTO
_parallel_time_unit                      10
parallel_degree_limit                    CPU
parallel_force_local                     FALSE
_parallel_scalability                    50
_parallel_syspls_obey_force              TRUE
_optimizer_nested_rollup_for_gset        100
_plan_verify_improvement_margin          150
_statistics_based_srf_enabled            TRUE
_selectivity_for_srf_enabled             FALSE
optimizer_use_invisible_indexes          FALSE
_optimizer_extended_stats_usage_control  192
_sql_plan_management_control             0
_optimizer_fast_pred_transitivity        TRUE
_optimizer_fast_access_pred_analysis     TRUE
_optimizer_multiple_cenv_report          result
_optimizer_multiple_cenv_stmt            query
_parallel_cluster_cache_pct              80
_px_granule_batch_size                   26
_optimizer_instance_count                0
_block_sample_readahead_prob_threshold   10
_mv_generalized_oj_refresh_opt           TRUE
_parallel_optimization_phase_for_local   FALSE
_enable_schema_synonyms                  FALSE
_enable_rename_user                      FALSE
_mv_refresh_enhanced_dml_detection       ON_RC
_mv_refresh_pkfk_relationship_opt        TRUE
_mv_refresh_pkfk_data_units_opt          auto
_optimizer_unnest_disjunctive_subq       TRUE
_optimizer_unnest_corr_set_subq          TRUE
_optimizer_distinct_agg_transform        TRUE
_aggregation_optimization_settings       0
_sqlexec_aggregation_settings            0
_arch_compress_checksums                 FALSE
_optimizer_eliminate_filtering_join      TRUE
dst_upgrade_insert_conv                  TRUE
_create_table_in_any_cluster             FALSE
_dsc_feature_level                       0
_parallel_statement_queuing              FALSE
_parallel_conservative_queuing           FALSE
parallel_servers_target                  20
_px_load_factor                          300
_dml_frequency_tracking                  FALSE
_dml_frequency_tracking_advance          TRUE
_dml_frequency_tracking_slots            4
_dml_frequency_tracking_slot_time        15
_px_gim_factor                           100
_add_trim_for_nlssort                    TRUE
_optimizer_connect_by_cb_whr_only        FALSE
_optimizer_join_factorization            TRUE
_optimizer_force_CBQT
_optimizer_use_cbqt_star_transformation  TRUE
_rep_base_path
_optimizer_table_expansion               TRUE
_and_pruning_enabled                     TRUE
_dml_batch_error_limit                   0
_noseg_for_unusable_index_enabled        TRUE
_slave_mapping_skew_ratio                2
_px_index_sampling_objsize               TRUE
_sql_compatibility                       0
_optimizer_use_feedback                  TRUE
_optimizer_gather_feedback               TRUE
_optimizer_feedback_control
_optimizer_try_st_before_jppd            TRUE
_parallel_blackbox_size                  16384
_parallel_blackbox_enabled               TRUE
_parallel_load_publish_threshold         10
_px_partition_scan_enabled               TRUE
_px_partition_scan_threshold             64
_parallel_heartbeat_snapshot_interval    2
_parallel_heartbeat_snapshot_max         128
_optimizer_false_filter_pred_pullup      TRUE
_px_granule_randomize                    TRUE
_optimizer_purge_stats_iteration_row_cou 10000
nt

_mv_refresh_update_analysis              TRUE
_mv_cleanup_orphaned_metadata            TRUE
_mv_refresh_insert_no_append             TRUE
_part_redef_global_index_update          TRUE
_ptn_cache_threshold                     1
_optimizer_enable_table_lookup_by_nl     TRUE
_px_max_message_pool_pct                 40
_px_chunklist_count_ratio                32
_px_hold_time                            0
_optimizer_generate_transitive_pred      TRUE
_optimizer_cube_join_enabled             TRUE
_optimizer_filter_pushdown               TRUE
max_string_size                          STANDARD
_dm_enable_legacy_dmf_output_types       FALSE
_dm_dmf_details_compatibility            12.1.0
_cdc_subscription_owner
_optimizer_outer_join_to_inner           TRUE
_optimizer_hybrid_fpwj_enabled           TRUE
_px_message_compression                  TRUE
_px_object_sampling_enabled              TRUE
_px_concurrent                           TRUE
_px_back_to_parallel                     OFF
_scalar_type_lob_storage_threshold       4000
_px_replication_enabled                  TRUE
_px_round_robin_rowcnt                   1000
_zonemap_use_enabled                     TRUE
_zonemap_staleness_tracking              1
_zonemap_control                         0
_zonemap_usage_tracking                  TRUE
_zonemap_auto_clustering_ratio           50
_zonemap_auto_candidate_table_min_size   5000
_zonemap_refresh_within_load             TRUE
_sql_plan_directive_mgmt_control         67
_optimizer_full_outer_join_to_outer      TRUE
_px_filter_parallelized                  TRUE
_px_filter_skew_handling                 TRUE
_px_groupby_pushdown                     FORCE
_partition_advisor_srs_active            true
_px_parallelize_expression               TRUE
_fast_index_maintenance                  TRUE
_optimizer_gather_stats_on_load          TRUE
_multi_transaction_optimization_enabled  TRUE
_optimizer_batch_table_access_by_rowid   TRUE
optimizer_adaptive_reporting_only        FALSE
_optimizer_ads_max_table_count           0
_optimizer_ads_time_limit                0
_optimizer_ads_use_result_cache          TRUE
_optimizer_ads_result_cache_life         3600
_optimizer_ads_use_spd_cache             TRUE
_optimizer_ads_spd_cache_owner_limit     64
_px_wif_dfo_declumping                   CHOOSE
_px_wif_extend_distribution_keys         TRUE
_px_wif_min_ndv_per_slave                2
_px_join_skew_handling                   TRUE
_px_join_skew_ratio                      10
_px_join_skew_minfreq                    30
_px_join_skew_use_histogram              TRUE
_px_join_skew_sampling_time_limit        50
_px_join_skew_sampling_percent           0
_px_adaptive_dist_method                 CHOOSE
_px_adaptive_dist_method_threshold       0
_px_adaptive_dist_bypass_enabled         TRUE
_px_adaptive_dist_bypass_optimization    1
_px_adaptive_dist_nij_enabled            ON
_parallel_fault_tolerance_enabled        FALSE
_parallel_fault_tolerance_threshold      3
_px_partial_rollup_pushdown              ADAPTIVE
_sql_diag_repo_retain
_sql_diag_repo_origin                    all
_optimizer_dsdir_usage_control           0
_px_cpu_autodop_enabled                  TRUE
_px_cpu_process_bandwidth                200
_px_cpu_operator_bandwidth
_px_single_server_enabled                TRUE
_optimizer_use_gtt_session_stats         TRUE
optimizer_adaptive_plans                 TRUE
_optimizer_adaptive_plan_control         0
_optimizer_adaptive_random_seed          0
_optimizer_strans_adaptive_pruning       TRUE
_optimizer_proc_rate_level               BASIC
_px_hybrid_TSM_HWMB_load                 TRUE
_optimizer_use_histograms                TRUE
_disable_directory_link_check            FALSE
_add_nullable_column_with_default_optim  TRUE
_emx_max_sessions                        128
_emx_session_timeout                     3600
_emx_control                             0
_parallel_blackbox_sga                   TRUE
_rowsets_enabled                         TRUE
_rowsets_target_maxsize                  524288
_rowsets_max_rows                        256
_rowsets_use_encoding                    TRUE
_rowsets_max_enc_rows                    64
_px_load_monitor_threshold               10000
_px_numa_support_enabled                 FALSE
_px_numa_stealing_enabled                TRUE
_px_adaptive_offload_threshold           10
_px_adaptive_offload_percentage          30
_modify_column_index_unusable            FALSE
_adaptive_window_consolidator_enabled    TRUE
_sql_hvshare_threshold                   0
_px_tq_rowhvs                            TRUE
_sql_hvshare_debug                       1
_sql_show_expreval                       FALSE
_parallel_ctas_enabled                   TRUE
_optimizer_performance_feedback          OFF
_optimizer_proc_rate_source              DEFAULT
_hashops_prefetch_size                   4
_stat_aggs_one_pass_algorithm            FALSE
_px_onepass_slave_acquisition            TRUE
_online_ctas_diag                        0
_upddel_dba_hash_mask_bits               0
_px_pwmr_enabled                         TRUE
_px_cdb_view_enabled                     TRUE
_optimizer_cluster_by_rowid              TRUE
_optimizer_cluster_by_rowid_control      129
_partition_cdb_view_enabled              TRUE
_common_data_view_enabled                TRUE
_optimizer_cbqt_or_expansion             ON
_pred_push_cdb_view_enabled              TRUE
_rowsets_cdb_view_enabled                TRUE
_distinct_agg_optimization_gsets         CHOOSE
_array_cdb_view_enabled                  TRUE
_mv_refresh_pipe_timeout                 600
_mv_refresh_truncate_log                 FALSE
_rc_sys_obj_enabled                      TRUE
_px_scalable_invdist                     TRUE
_indexable_con_id                        TRUE
_optimizer_reduce_groupby_key            TRUE
_optimizer_cluster_by_rowid_batched      TRUE
_optimizer_cluster_by_rowid_batch_size   100
_object_link_fixed_enabled               TRUE
_optimizer_synopsis_min_size             2
_merge_monitor_threshold                 10000
optimizer_inmemory_aware                 TRUE
_optimizer_inmemory_table_expansion      TRUE
_optimizer_inmemory_gen_pushable_preds   TRUE
_optimizer_inmemory_autodop              TRUE
_optimizer_inmemory_access_path          TRUE
_optimizer_inmemory_quotient             0
_optimizer_inmemory_pruning_ratio_rows   100
_parallel_inmemory_min_time_threshold    AUTO
_parallel_inmemory_time_unit             1
_px_external_table_default_stats         TRUE
_optimizer_nlj_hj_adaptive_join          TRUE
_px_autodop_pq_overhead                  TRUE
_px_overhead_init_slavealloc             1000
_px_overhead_init_endpoints              4
_px_overhead_exec_ctrlmesg               4
_px_overhead_teardown                    600
_grant_read_instead_of_select            FALSE
_optimizer_inmemory_bloom_filter         TRUE
_optimizer_inmemory_cluster_aware_dop    TRUE
_optimizer_inmemory_minmax_pruning       TRUE
_cdb_cross_container                     65535
_cdb_view_parallel_degree                65535
_optimizer_hll_entry                     4096
_cross_con_row_count                     FALSE
_cdb_view_prefetch_batch_size            200
_cdb_view_rc_shelflife                   30
_approx_cnt_distinct_gby_pushdown        choose
_approx_cnt_distinct_optimization        0
_px_cdb_view_join_enabled                TRUE
_external_table_smart_scan               HADOOP_ONLY
_optimizer_db_blocks_buffers             0
_composite_interval_partition_creation_o TRUE
pt_enabled

_optimizer_bushy_join                    off
_optimizer_bushy_fact_dim_ratio          20
_optimizer_bushy_fact_min_size           100000
_optimizer_bushy_cost_factor             100
_query_rewrite_use_on_query_computation  TRUE
_mv_access_compute_fresh_data            ON
_px_min_ndv_per_slave_perc_func          2
_px_scalable_invdist_mcol                TRUE
_rmt_for_table_redef_enabled             TRUE
_query_execution_time_limit              0
_optimizer_ads_use_partial_results       TRUE
_optimizer_eliminate_subquery            TRUE
cursor_invalidation                      IMMEDIATE
_sqlexec_hash_based_distagg_enabled      TRUE
_sqlexec_disable_hash_based_distagg_tiv  FALSE
_sqlexec_hash_based_distagg_ser_civ_enab TRUE
led

_sqlexec_hash_based_distagg_ssf_enabled  TRUE
_sqlexec_distagg_optimization_settings   0
approx_for_aggregation                   FALSE
approx_for_count_distinct                FALSE
_optimizer_union_all_gsets               TRUE
_optimizer_enhanced_join_elimination     TRUE
_optimizer_multicol_join_elimination     TRUE
_optimizer_enable_plsql_stats            TRUE
_recursive_with_parallel                 TRUE
_recursive_with_using_temp_table         FALSE
_recursive_with_branch_iterations        7
_recursive_with_control                  0
_partition_read_only                     TRUE
_px_dist_agg_partial_rollup_pushdown     ADAPTIVE
_mv_refresh_shrink_log                   TRUE
_pwise_distinct_enabled                  TRUE
_approx_perc_sampling_err_rate           2
_vector_encoding_mode                    MANUAL
_optimizer_use_table_scanrate            HADOOP_ONLY
_optimizer_use_xt_rowid                  TRUE
_xt_sampling_scan_granules               ON
_xt_sampling_scan_granules_min_granules  1
_xt_def_compression_ratio                4
_xt_legacy_debug_flags                   0
_xt_enable_columnar_fetch                TRUE
_sqlexec_use_rwo_aware_expr_analysis     TRUE
_monitor_workload_interval               24
_optimizer_band_join_aware               TRUE
_optimizer_vector_transformation         TRUE
_optimizer_vector_fact_dim_ratio         10
_optimizer_vector_min_fact_rows          10000000
_optimizer_key_vector_aggr_factor        75
_optimizer_vector_cost_adj               100
_optimizer_key_vector_pruning_enabled    TRUE
_optimizer_vector_base_dim_fact_factor   200
approx_for_percentile                    NONE
_approx_percentile_optimization          0
_optimizer_adaptive_plans_continuous     FALSE
_optimizer_adaptive_plans_iterative      FALSE
_optimizer_generate_ptf_implied_preds    TRUE
_optimizer_inmemory_capture_stored_stats TRUE
_optimizer_inmemory_use_stored_stats     AUTO
_shard_sql_use_chunk_ids                 0
_expression_tracking_latch_count         16
_expression_tracking_elem_per_bucket     30
_bloom_filter_ratio                      35
_optimizer_control_shard_qry_processing  65472
_optimizer_interleave_or_expansion       TRUE
_px_partition_load_dist_threshold        64
optimizer_adaptive_statistics            FALSE
_optimizer_use_feedback_for_join         FALSE
_optimizer_ads_for_pq                    FALSE
_px_slave_parse_first_with_outline_hints TRUE
_px_join_skewed_values_count             0
_bloom_max_wait_time                     50
_bloom_wait_on_rac                       FALSE
_bloom_extent_size                       0
_read_optimized_table_lookup             TRUE
_optimizer_key_vector_payload            TRUE
_optimizer_vector_fact_payload_ratio     20
_bloom_pruning_setops_enabled            TRUE
_bloom_filter_setops_enabled             TRUE
_px_pwise_wif_enabled                    TRUE
_sqlexec_reorder_wif_enabled             TRUE
_px_partition_skew_threshold             80
_sqlexec_pwiseops_with_sqlfuncs_enabled  TRUE
_sqlexec_pwiseops_with_binds_enabled     TRUE
optimizer_ignore_parallel_hints          FALSE
_px_shared_hash_join                     FALSE
_px_reuse_server_groups                  MULTI
_px_join_skew_null_handling              TRUE
_px_tq_memcpy_threshold                  100
_bloom_use_shared_pool                   FALSE
_enable_parallel_dml                     FALSE
_px_nlj_bcast_rr_threshold               10
parallel_min_degree                      1
_sqlexec_use_kgghash3                    TRUE
_optimizer_gather_stats_on_load_all      FALSE
_optimizer_gather_stats_on_load_hist     FALSE
_px_granule_alignment                    1024
_optimizer_allow_all_access_paths        TRUE
_lob_use_locator_varying_width           FALSE
_optimizer_answering_query_using_stats   FALSE
_cell_offload_vector_groupby_fact_key    TRUE
_px_scalable_gby_invdist                 TRUE
_xt_preproc_timeout                      100
_px_dynamic_granules                     TRUE
_px_dynamic_granules_adjust              10
_px_hybrid_partition_execution_enabled   TRUE
_px_hybrid_partition_skew_threshold      10
_optimizer_key_vector_use_max_size       1048576
_optimizer_non_blocking_hard_parse       TRUE
_optimizer_track_hint_usage              TRUE
_optimizer_compare_plans_control         0
_optimizer_key_vector_payload_dim_aggs   TRUE
optimizer_capture_sql_quarantine         FALSE
optimizer_use_sql_quarantine             TRUE
_optimizer_use_auto_indexes              AUTO
_optimizer_gather_stats_on_load_index    TRUE
_optimizer_stats_on_conventional_dml_sam 100
ple_rate

_optimizer_gather_stats_on_conventional_ FALSE
dml

_optimizer_use_stats_on_conventional_dml FALSE
_optimizer_use_stats_on_conventional_con 0
fig

_optimizer_gather_stats_on_conventional_ 0
config

_sqlexec_use_delayed_unpacking           TRUE
_px_parallelize_non_native_datatype      TRUE
optimizer_session_type                   NORMAL
_autosts_short_interval                  300
_autosts_long_interval                   0
_autosts_retention_interval              31
_optimizer_use_stats_models              FALSE
_optimizer_exists_to_any_rewrite         TRUE
_autosts_capture_control                 3
optimizer_cross_shard_resiliency         FALSE
optimizer_real_time_statistics           FALSE
_cell_offload_vector_groupby_external    TRUE
_dbopen_breakpoint                       none
_optimizer_wc_filter_pushdown            TRUE
_bigdata_offload_flag                    FALSE
_mv_master_lock_timeout                  3
_optimizer_nested_loop_join              on
_auto_mv_enabled                         FALSE
_px_extended_join_skew_handling          TRUE
_mv_logical_partition_tracking_enabled   FALSE
_mv_logical_partition_rewrite_enabled    FALSE
_sqlexec_hash_rollup_enabled             TRUE
_sqlexec_hash_based_set_operation_enable TRUE
d

_optimizer_unnest_update_set_subq        on
_object_activity_tracking                TRUE
_object_activity_control                 0
_object_activity_disable                 0
_non_blocking_hard_parse_min_extend_time 2
_dmm_ipp_cutoff                          0
_dmm_nobin_threshold                     200
_dmm_force_treetop_merge                 0
_dmm_cnt_arr_size_threshold              500000
_dmm_sample_lower_threshold              10000
_dmm_sample_upper_threshold              500000
_dmm_auto_max_features                   500
_dmm_max_memory_size                     1000000
_dmm_memory_size                         64000000
_dmsqr_qr_chunk_rows                     10000
_dm_max_chunk_size                       2000
_dm_inmemory_threshold                   1000000
_bigram_dependency_percentage            5
_dmm_inc_cholesky_rows                   50000
_dmm_kmean_dense_threshold               500
_dmm_blas_library
_dmm_ts_lapack                           1
_dmm_reduction_rate                      4
_dmm_pga_load_threshold                  3
_dmm_details_filter_weight               1
_dmm_xgboost_max_memory                  1000000000
_dmm_ser_test                            0
_utlfile_dirpath                         FALSE
_alter_upgrade_signature_only            FALSE
_enable_bug_29838374                     0
sec_protocol_error_trace_action          TRACE
sec_protocol_error_further_action        (DROP,3)
_spadr                                   YES
allow_deprecated_rpcs                    YES
sec_max_failed_login_attempts            3
sec_return_server_release_banner         FALSE
_sec_enable_test_rpcs                    FALSE
_failover_svrcsum                        FALSE
_use_zero_copy_io                        TRUE
enable_ddl_logging                       FALSE
_tstz_localtime_bypass                   FALSE
_client_tstz_error_check                 TRUE
client_result_cache_size                 0
client_result_cache_lag                  3000
_client_result_cache_bypass              FALSE
_client_result_cache_ramthreshold
_client_result_set_threshold
_emon_regular_ntfn_slaves                4
_emon_outbound_connect_timeout           7200000
_emon_send_timeout                       7200000
_emon_max_active_connections             256
_client_ntfn_pingtimeout                 30000
_client_ntfn_pinginterval                75
_client_ntfn_pingretries                 6
_client_enable_auto_unregister           FALSE
_srvntfn_q_msgcount                      50
_srvntfn_q_msgcount_inc                  100
_srvntfn_jobsubmit_interval              3
_srvntfn_max_concurrent_jobs             20
_srvntfn_job_deq_timeout                 60
_client_ntfn_cleanup_interval            2400
_max_clients_per_emon                    8
_emon_pool_inc                           4
_emon_pool_min                           4
_emon_pool_max                           16
_tsm_connect_string
_sscr_dir
_sscr_osdir
_tsm_disable_auto_cleanup                1
_ttc_annotations_level                   0
_enable_nativenet_tcpip                  FALSE
_client_features_tracking_enable         TRUE
outbound_dblink_protocols                ALL
allow_global_dblinks                     FALSE
_async_scn_sync                          OFF
_share_drcp_proxy_sessions               TRUE
drcp_dedicated_opt                       NO
enable_per_pdb_drcp                      FALSE
drcp_connection_limit                    0
max_auth_servers                         25
min_auth_servers                         1
_request_boundaries                      3
_spfoc                                   OFF
_spfdc                                   OFF
_spfei
client_statistics_level                  TYPICAL
_close_deq_by_cond_curs                  FALSE
_deq_maxwait_time                        0
_deq_max_fetch_count                     10
_deq_execute_reset_time                  30
_aq_streaming_threshold                  10485760
_aq_dly_bkt                              2
_aq_retry_timeouts                       0
_aq_scrambled_deqlog                     1
_aq_dqblocks_in_cache                    0
_aq_uncached_stats                       0
_aq_free_list_pools                      10
aq_tm_processes                          1
_aq_tm_statistics_duration               0
_orph_cln_interval                       1200
_aq_max_scan_delay                       1500
_aq_tm_scanlimit                         0
_aq_tm_deqcountinterval                  0
_aq_tm_processes_dump_interval           12
_disable_gvaq_cache                      FALSE
_rule_max_dnfp_cnt                       1024
_re_fast_sql_operator                    all
_re_result_cache_keysiz                  20
_re_result_cache_size                    20
_re_independent_expression_cache_size    20
_enable_iee_stats                        TRUE
_re_num_complex_operator                 1000
_re_num_rowcache_load                    2
_prop_old_enabled                        FALSE
_bufq_stop_flow_control                  FALSE
_capture_publisher_flow_control_threshol 0
d

_buffered_publisher_flow_control_thresho 0
ld

_buffered_message_spill_age              300
_deq_log_array_size                      10000
_deq_ht_max_elements                     100000
_deq_ht_child_latches                    8
_deq_large_txn_size                      25000
_aqsharded_cache_limit                   0
_aqsharded_cached_hint                   0
_aqsharded_lowmem_timeout                1000
_aqsharded_enq_fresh_ptn_reload          TRUE
_aqsharded_reload_tune                   0
_aq_Txn_ht_sz                            1024
_aq_shard_bitmap_child_latches           32
_aq_shard_retry_child_latches            32
_aq_shard_txn_child_latches              128
_aq_shard_sub_child_latches              512
_aq_shard_sub_child_Elem_latches         1024
_aq_shard_child_latches                  512
_aq_shard_prty_latches                   16
_aq_init_shards                          5
_aq_x_mode                               1
_aq_latency_relative_threshold           100
_aq_latency_absolute_threshold           300
_aq_max_pdb_close_msg                    1
_aq_lb_subht_bkt_ltch                    32
_aq_lb_subht_elm_ltch                    128
_aq_lb_garbage_col_interval              600
_aq_queue_global_service
_aq_x_msg_size                           32768
_aq_stop_backgrounds                     FALSE
_aq_lb_cycle                             120
_aq_lb_stats_collect_cycle               45
_aq_pt_processes                         10
_aq_subshard_Size                        20000
_aq_subshards_per_qpartition             1
_aq_subshards_per_dqpartition            1
_aq_lookback_size                        60
_aq_qt_prefetch_Size                     5
_aq_dq_prefetch_Siz                      5
_aq_pt_statistics_window                 60
_aq_pt_shrink_frequency                  1450
_aq_addpt_batch_size                     1
_aq_truncpt_batch_size                   1
_aq_droppt_batch_size                    5
_shrd_que_tm_processes                   1
_shrd_que_tm_statistics_duration         0
_aq_ipc_max_slave                        10
_aq_opt_stat_window                      21600
_aq_opt_stop_stat                        FALSE
_aq_opt_enabled                          TRUE
_aq_opt_background_enabled               TRUE
_aq_opt_fudge_factor                     500
_aq_opt_prefetch_horizon                 60
_aq_opt_min_evict_memory                 0
_aq_opt_prefetch_dop                     3
_aq_opt_preevict_dop                     3
hs_autoregister                          TRUE
_ctx_doc_policy_stems                    FALSE
_nonce_history_buffer_size               0
xml_db_events                            enable
dg_broker_start                          FALSE
_dgb_dgpdb_appst
dg_broker_config_file1                   /oracle/app/oracle/homes/OraDB
                                         21Home1/dbs/dr1ORA21C.dat

dg_broker_config_file2                   /oracle/app/oracle/homes/OraDB
                                         21Home1/dbs/dr2ORA21C.dat

_dg_broker_trace_level
_block_change_tracking_file
_olapi_history_retention                 FALSE
_olapi_session_history                   300
_olapi_session_history_retention         FALSE
_olapi_iface_object_history              1000
_olapi_iface_object_history_retention    FALSE
_olapi_interface_operation_history       1000
_olapi_iface_operation_history_retention FALSE
_olapi_memory_operation_history          1000
_olapi_memory_operation_history_retentio FALSE
n

_olapi_memory_operation_history_pause_at 0
_seqno

olap_page_pool_size                      0
_olap_continuous_trace_file              false
_olap_table_function_statistics          FALSE
_olap_parallel_update_threshold          1000
_olap_parallel_update_small_threshold    1000
_olap_parallel_update_server_num         0
_olap_aggregate_buffer_size              1048576
_olap_aggregate_min_buffer_size          1024
_olap_aggregate_work_per_thread          1024
_olap_aggregate_min_thread_status        64
_olap_aggregate_statlen_thresh           1024
_olap_aggregate_worklist_max             5000
_olap_aggregate_max_thread_tuples        5000
_olap_aggregate_function_cache_enabled   TRUE
_olap_aggregate_multipath_hier           FALSE
_olap_aggregate_flags                    0
_olap_allocate_errorlog_header           Dim      Source   Basis
                                         %-8d %-8s %-8b Description
                                         -------- -------- -------- ---
                                         --------

_olap_allocate_errorlog_format           %8p %8y %8z %e (%n)
_olap_dbgoutfile_echo_to_eventlog        FALSE
_olap_eif_export_lob_size                2147483647
_olap_sort_buffer_size                   262144
_olap_sort_buffer_pct                    10
_olap_sesscache_enabled                  TRUE
_olap_object_hash_class                  3
_olap_dimension_corehash_size            30
_olap_dimension_corehash_pressure        90
_olap_dimension_corehash_large           50000
_olap_dimension_corehash_force           FALSE
_olap_page_pool_low                      262144
_olap_page_pool_hi                       50
_olap_page_pool_expand_rate              20
_olap_page_pool_shrink_rate              50
_olap_page_pool_hit_target               100
_olap_page_pool_pressure                 90
_olap_statbool_threshold                 8100
_olap_statbool_corebits                  20000000
_olap_lmgen_dim_size                     100
_olap_lmgen_meas_size                    1000
_olap_wrap_errors                        FALSE
_olap_analyze_max                        10000
_olap_adv_comp_stats_max_rows            100000
_olap_adv_comp_stats_cc_precomp          20
_olap_row_load_time_precision            DEFAULT
_olap_disable_loop_optimized             FALSE
_xsolapi_fetch_type                      PARTIAL
_xsolapi_dimension_group_creation        OVERFETCH
_xsolapi_sql_auto_measure_hints          TRUE
_xsolapi_sql_auto_dimension_hints        FALSE
_xsolapi_sql_hints
_xsolapi_sql_measure_hints
_xsolapi_sql_dimension_hints
_xsolapi_sql_top_measure_hints
_xsolapi_sql_top_dimension_hints
_xsolapi_sql_all_non_base_hints
_xsolapi_sql_all_multi_join_non_base_hin
ts

_xsolapi_densify_cubes                   TABULAR
_xsolapi_sql_optimize                    TRUE
_xsolapi_sql_remove_columns              TRUE
_xsolapi_sql_symmetric_predicate         TRUE
_xsolapi_sql_use_bind_variables          TRUE
_xsolapi_sql_prepare_stmt_cache_size     16
_xsolapi_sql_result_set_cache_size       32
_xsolapi_sql_minus_threshold             1000
_xsolapi_debug_output                    SUPPRESS
_xsolapi_materialize_sources             TRUE
_xsolapi_load_at_process_start           NEVER
_xsolapi_fix_vptrs                       TRUE
_xsolapi_auto_materialization_type       PRED_AND_RC
_xsolapi_auto_materialization_bound      20
_xsolapi_materialization_rowcache_min_ro 1
ws_for_use

_xsolapi_source_trace                    FALSE
_xsolapi_dml_trace
_xsolapi_build_trace                     FALSE
_xsolapi_metadata_reader_mode            DEFAULT
_xsolapi_odbo_mode                       FALSE
_xsolapi_set_nls                         TRUE
_xsolapi_stringify_order_levels          FALSE
_xsolapi_suppression_chunk_size          4000
_xsolapi_suppression_aw_mask_threshold   1000
_xsolapi_share_executors                 TRUE
_xsolapi_hierarchy_value_type            unique
_xsolapi_use_models                      TRUE
_xsolapi_use_olap_dml                    TRUE
_xsolapi_use_olap_dml_for_rank           TRUE
_xsolapi_remove_columns_for_materializat TRUE
ion

_xsolapi_precompute_subquery             TRUE
_xsolapi_optimize_suppression            TRUE
_xsolapi_generate_with_clause            FALSE
_xsolapi_sql_enable_aw_join              TRUE
_xsolapi_sql_enable_aw_qdr_merge         TRUE
_xsolapi_opt_aw_position                 TRUE
_xsolapi_support_mtm                     FALSE
_asm_runtime_capability_volume_support   FALSE
_asm_disable_multiple_instance_check     FALSE
_asm_disable_amdu_dump                   FALSE
_asmsid                                  asm
_asm_global_dump_level                   267
_remote_asm
_ios_root_directory                      IOS
_apx_root_directory                      APX
_asm_node_site_guid
_asm_node_number
_asm_reloc_cic                           FALSE
_asm_oda_type
_asm_access                              auto
_asm_max_kfsg_free_heap_size             524288000
_asm_max_kfsg_free_heap_perc             10
_asm_showpdb_asmtbl                      FALSE
_asm_allow_system_alias_rename           FALSE
_asm_instlock_quota                      0
_asm_relocation_trace                    FALSE
asm_diskstring
_asm_disk_repair_time                    14400
asm_preferred_read_failure_groups
_asm_disable_profilediscovery            FALSE
_asm_relocation_ignore_hard_failure      0
_asm_max_parallelios                     256
_asm_auto_online_interval
_asm_offline_wait_timeout                300
_asm_frag_threshold                      50
_asm_min_occupied                        50
_asm_max_occupied                        90
_asm_imbalance_tolerance                 3
_asm_shadow_cycle                        3
_asm_primary_load_cycles                 TRUE
_asm_primary_load                        1
_asm_secondary_load_cycles               FALSE
_asm_secondary_load                      10000
_kffmop_chunks                           42
_kffmop_list_check                       FALSE
_kffmap_hash_size                        1024
_kffmop_hash_size                        2048
_kffmlk_hash_size                        512
_kffmspw_hash_size                       128
_kffmof_size                             1048576
_kffmof_fprate                           1
asm_diskgroups
_asm_diskgroups2
_asm_diskgroups3
_asm_diskgroups4
asm_power_limit                          1
_asm_zero_power_limit
_disable_rebalance_space_check           FALSE
_asm_log_scale_rebalance                 FALSE
_asm_sync_rebalance                      FALSE
_diag_arb_before_kill                    FALSE
_asm_ausize                              1048576
_asm_blksize                             4096
_asm_acd_chunks                          1
_asm_partner_target_disk_part            8
_asm_partner_target_fg_rel               4
_asm_automatic_rezone                    TRUE
_asm_rebalance_plan_size                 120
_asm_rebalance_space_errors              1000
_asm_relocation_scheme                   alloc_p2 alloc_s3 reb_p2 reb_s
                                         1 bal_p2 bal_s3 prep_p2 prep_s
                                         3

_asm_disable_dangerous_failgroup_checkin FALSE
g

_asm_rebalance_estimates_process         TRUE
_asm_disable_failgroup_size_checking     FALSE
_asm_disable_failgroup_count_checking    FALSE
_asm_allow_foreign_siteguids
_asm_allow_dgname_special_chars          FALSE
_asm_enable_vfreloc_on_rm                FALSE
_asm_libraries                           ufs
_asm_maxio                               1048576
_asm_allow_only_raw_disks                TRUE
_asm_disable_vtoc_check                  FALSE
_asm_fob_tac_frequency                   9
_asm_emulate_nfs_disk                    FALSE
_asm_allow_lvm_resilvering               TRUE
_asm_lsod_bucket_size                    67
_asm_iostat_latch_count                  31
_asm_diskerr_traces                      2
_asm_procs_trace_diskerr                 5
_asm_trace_limit_timeout                 30000
_asm_fd_cln_on_fg                        TRUE
_asm_fd_cln_idle_sess_twait              60000000
_asm_skip_dbfile_ios                     FALSE
_asm_offload_all                         FALSE
_asm_hard_check                          TRUE
_asm_read_cancel                         AUTO
_asm_read_cancel_back_out                5000
_asm_write_cancel                        AUTO
_asm_cancel_delta                        75000
_asm_cancel_alert_time                   600
_asm_enable_kfks                         FALSE
_asm_write_cancel_timeout_percentage     30
_kfm_disable_set_fence                   FALSE
_asm_disable_smr_creation                FALSE
_afd_disable_fence                       FALSE
_asm_network_timeout                     1
_asm_wait_time                           18
_asm_skip_diskval_check                  FALSE
_asm_skip_resize_check                   FALSE
_asm_skip_rename_check                   FALSE
_asm_direct_con_expire_time              120
_asm_check_for_misbehaving_cf_clients    FALSE
_asm_diag_dead_clients                   FALSE
_asm_disable_ufg_dump                    FALSE
_asm_reserve_slaves                      TRUE
_asm_kill_unresponsive_clients           TRUE
_asm_disable_async_msgs                  FALSE
_asm_remote_client_timeout               300
_asm_allow_unsafe_reconnect              TRUE
_asm_disable_ufgmemberkill               FALSE
_asm_disable_proact_client_cleanup       FALSE
_asm_nodekill_escalate_time              180
_asm_healthcheck_timeout                 180
_asm_cclient_cleanup_timeout             300
_asm_allow_older_clients                 FALSE
_asm_enable_multiple_asmb                TRUE
_asm_disable_vxn_map_messages            FALSE
_asm_asmb_rcvto                          10
_asm_asmb_max_wait_timeout               6
_asm_tcp_user_timeout                    1
_asm_ufg_nw_wait_timeout                 10
_asm_ownerid_trace_timeout               600
_asm_shared_pool_latch_timeout           30
_asm_diskgroup_renew_timeout             20
_asm_resyncCkpt                          1024
_asm_relocation_async_lock_count         128
_asm_stripewidth                         8
_asm_stripesize                          131072
_disable_fastopen                        FALSE
_asm_random_zone                         FALSE
_asm_serialize_volume_rebalance          FALSE
_asm_force_quiesce                       FALSE
_asm_dba_threshold                       0
_asm_dba_batch                           500000
_asm_force_paritycheck_rebalance         FALSE
_asm_dba_spcchk_thld                     100000
_asm_usd_batch                           64
_asm_fail_random_rx                      FALSE
_relocation_commit_batch_size            8
_asm_dump_split_pw                       10
_asm_max_redo_buffer_size                2097152
_asm_max_cod_strides                     10
_asm_max_aux_cods                        5
_asm_evenread                            2
_asm_evenread_alpha                      0
_asm_evenread_alpha2                     0
_asm_evenread_faststart                  0
_asm_noevenread_diskgroups
_asm_disable_request_tracer              TRUE
_asm_buffer_overlap_tracer               FALSE
_asm_force_parity_extent_check           FALSE
_asm_enable_kfios                        FALSE
_asm_enable_map_share                    TRUE
_asm_networks
_asm_access_assume_local                 FALSE
_asm_iosconnect_timeout                  0
_asm_iosfailover_timeout                 5
_asm_iosfailover_freq                    3
_asm_br_listener_port                    51521
_asm_ios_network_domains                 0
_asm_ios_network_processes               0
_asm_netp_factor                         0
_asm_idn_processes                       0
_asm_iowp_max_async                      0
asm_io_processes                         20
_asm_max_clients                         1000
_asm_netp_iosize                         0
_asm_brfuzz_ios_lsnrport                 0
_asm_dbmsdg_nohdrchk                     FALSE
_asm_root_directory                      ASM
_asm_odapremchk                          TRUE
_asm_pstonpartners                       TRUE
_asm_allowdegeneratemounts               FALSE
_asm_hbeatiowait                         120
_asm_hbeatwaitquantum                    2
_asm_repairquantum                       60
_asm_emulmax                             10000
_asm_emultimeout                         0
_asm_kfdpevent                           0
_asm_storagemaysplit                     FALSE
_asm_avoid_pst_scans                     TRUE
_asm_pst_rsinfo                          0
_disable_storage_type                    FALSE
_asm_min_compatibility                   11.2.0.2
_asm_compatibility                       11.2.0.2
_rdbms_compatibility                     10.1
_kfi_version_patchmap
_kfi_software_patchmap
_asm_disable_patch_compat                FALSE
_asm_proxy_startwait                     60
_asm_allow_dangerous_unprotected_volumes FALSE
_asm_proxy_online_restart                0
_allow_cell_smart_scan_attr              TRUE
_asm_admin_with_sysdba                   FALSE
_asm_allow_appliance_dropdisk_noforce    FALSE
_asm_allow_appliance_offlineonline       FALSE
_disable_appliance_check                 FALSE
_disable_appliance_partnering            FALSE
_asm_appliance_config_file
_asm_appliance_ignore_oak                FALSE
_dirty_appliance_mode                    FALSE
_asm_appliance_slot_from_path            FALSE
_asm_appliance_disable_fg_check          FALSE
_asm_write_badfdata_in_contentcheck      FALSE
_asm_scrub_disable_cod                   FALSE
_asm_scrub_strict                        FALSE
_asm_scrub_async                         TRUE
_asm_scrub_limit                         AUTO
_asm_scrub_unmatched_dba                 1024
_asm_enable_parity_scrub                 FALSE
_asm_async_scrub_reap_wait               100000
_asm_enable_batch_scrub                  FALSE
_asm_enable_lostwrite_scrub              FALSE
_asm_enable_repair_lostwrite_scrub       FALSE
_asm_scrub_max_cod_wait                  5
_memory_max_tgt_inc_cnt                  0
_asm_enable_xrov                         FALSE
_asm_xrov_single                         FALSE
_asm_xrov_rsnmod                         2
_asm_xrov_cachelgio                      1
_asm_xrov_nvios                          24
_asm_xrov_nstats                         0
_skip_acfs_checks                        FALSE
_asm_force_vam                           FALSE
_usd_recent_read                         TRUE
_usd_preload_blks                        4
_asm_dependency_under_cfenqueue          TRUE
_asm_max_connected_clients               3
__asm_max_connected_clients              3
_asm_enable_parityfile_creation          TRUE
_enable_multiple_fgprepares              FALSE
_enable_single_dgprepare                 FALSE
_asm_allow_prepare_split                 TRUE
_enable_ios_spm                          FALSE
_nusa_data_containers
_nusa_metadata_store
control_management_pack_access           DIAGNOSTIC+TUNING
_alert_expiration                        604800
_alert_message_cleanup                   1
_alert_message_purge                     1
_alert_post_background                   1
_swrf_test_action                        0
_sysaux_test_param                       1
_swrf_mmon_flush                         TRUE
_remote_awr_enabled                      FALSE
_awr_corrupt_mode                        FALSE
_awr_restrict_mode                       FALSE
_swrf_mmon_metrics                       TRUE
_swrf_metric_frequent_mode               FALSE
_awr_flush_threshold_metrics             TRUE
_awr_flush_workload_metrics              FALSE
_awr_disabled_flush_tables
_awr_disabled_purge_tables
_awr_snapshot_level                      BESTFIT
_swrf_on_disk_enabled                    TRUE
_awr_pdb_registration_enabled            FALSE
_swrf_mmon_dbfus                         TRUE
_awr_mmon_cpuusage                       TRUE
_swrf_test_dbfus                         FALSE
_adr_migrate_runonce                     TRUE
_awr_sql_child_limit                     200
_awr_enable_pdb_snapshots                TRUE
awr_pdb_autoflush_enabled                FALSE
awr_pdb_max_parallel_slaves              10
_awr_incremental_flush_enabled           TRUE
_awr_data_masking                        FALSE
_awr_warehouse_enabled                   TRUE
awr_snapshot_time_offset                 0
_awr_mmon_deep_purge_interval            7
_awr_mmon_deep_purge_extent              7
_awr_mmon_deep_purge_numrows             5000
_awr_mmon_deep_purge_all_expired         FALSE
_awr_cdbperf_threshold                   21
_awr_partition_interval                  0
_incremental_purge_size                  200
_awr_metrics_use_mmnl                    FALSE
sqltune_category                         DEFAULT
_sqltune_category_parsed                 DEFAULT
_ash_sampling_interval                   1000
_ash_size                                1048618
_ash_enable                              TRUE
_ash_disk_write_enable                   TRUE
_ash_disk_filter_ratio                   10
_ash_eflush_trigger                      66
_ash_sample_all                          FALSE
_ash_dummy_test_param                    0
_ash_min_mmnl_dump                       90
_ash_compression_enable                  FALSE
_ash_progressive_flush_interval          300
_kebm_nstrikes                           3
_kebm_suspension_time                    104400
_kebm_sanity_check_enabled               FALSE
_kebm_max_parallel_autotasks             AUTO
_kebm_autotask_nstrikes                  3
_kebm_preshut_act_enabled                FALSE
_timemodel_collection                    TRUE
_disable_metrics_group                   0
_kewm_simulate_oer4031                   0
_enable_metrics_allpdb                   TRUE
_enable_metrics_pdb                      FALSE
_validate_metric_groups                  FALSE
_track_metrics_memory                    TRUE
_kewm_trace_sga                          FALSE
_threshold_alerts_enable                 1
_enable_default_undo_threshold           TRUE
_enable_default_temp_threshold           TRUE
_addm_auto_enable                        TRUE
_addm_version_check                      TRUE
_addm_skiprules
_addm_auto_actions_enabled               TRUE
_automatic_maintenance_test              0
_autotask_min_window                     15
_autotask_max_window                     480
_enable_automatic_maintenance            1
_autotask_test_name                      N/A
autotask_max_active_pdbs                 2
enable_automatic_maintenance_pdb         TRUE
_autotask_test_action                    0
_bsln_adaptive_thresholds_enabled        TRUE
_wcr_control                             0
_dbreplay_feature_control
_db_replay_security_config
_dbreplay_mpk_key
_capture_buffer_size                     65536
_wcr_seq_cache_size                      65535
_wcr_grv_cache_size                      65535
_wcr_test_action                         0
_max_queued_report_requests              300
_report_capture_cycle_time               60
_report_capture_dbtime_percent_cutoff    50
_report_capture_timeband_length          1
_report_capture_recharge_window          10
_max_report_flushes_percycle             5
_report_request_ageout_minutes           60
_kecap_cache_size                        10240
_rtaddm_trigger_enabled                  TRUE
_rtaddm_trigger_args
_mwin_schedule                           TRUE
_umf_remote_target_dblink
_umf_remote_enabled                      FALSE
_dbmsumf$$nn
_dbmsumf$$p
_dbmsumf$$1x
_dbmsumf$$2x
_dbmsumf$$3x
_umf_test_action                         0
_iut_enable                              TRUE
_iut_max_entries                         30000
_iut_stat_collection_type                SAMPLED
_sqlset_hash_max_size                    100000
_component_timing
_swat_ver_mv_knob                        0
spatial_vector_acceleration              TRUE
_diag_verbose_error_on_init              0
_diag_hm_rc_enabled                      TRUE
_diag_hm_tc_enabled                      FALSE
diagnostic_dest                          /oracle/app/oracle
_diag_adr_enabled                        TRUE
_diag_adr_auto_purge                     TRUE
_diag_backward_compat                    TRUE
_diag_adr_test_param                     0
_diag_adr_trace_dest                     /oracle/app/oracle/diag/rdbms/
                                         ora21c/ORA21C/trace

_diag_pdb_purge_threshold                97
_diag_pdb_purge_target                   90
_diag_pdb_control                        0
_dra_enable_offline_dictionary           FALSE
_dra_bmr_number_threshold                1000
_dra_bmr_percent_threshold               10
_diag_conf_cap_enabled                   TRUE
_diag_patch_cap_enabled                  TRUE
_log_segment_dump_parameter              TRUE
_log_segment_dump_patch                  TRUE
_alert_segment_size                      10
_alert_segments_max                      0
_alert_segment_textfile                  FALSE
_diag_adl_dyn_alloc                      TRUE
_diag_cdb_logging                        short
_diag_alert_root_annotate                FALSE
_dde_flood_control_init                  TRUE
_diag_dde_fc_enabled                     TRUE
_diag_dde_fc_implicit_time               0
_diag_dde_fc_macro_time                  0
_diag_cc_enabled                         TRUE
_diag_dde_inc_proc_delay                 1
_diag_dde_async_msgs                     50
_diag_dde_async_msg_capacity             1024
_diag_dde_async_slaves                   5
_diag_dde_async_mode                     1
_diag_dde_async_age_limit                300
_diag_dde_async_process_rate             5
_diag_dde_async_runtime_limit            900
_diag_dde_async_cputime_limit            300
_diag_dde_enabled                        TRUE
tracefile_identifier
_trace_files_public                      FALSE
max_dump_file_size                       unlimited
_max_incident_file_size
_uts_trace_segment_size                  0
_uts_trace_segments                      5
_uts_first_segment_size                  0
_uts_first_segment_retain                TRUE
_diag_uts_control                        0
_uts_trace_disk_threshold                0
_diag_test_seg_reinc_mode                FALSE
_uts_trace_files_nopurge                 FALSE
_uts_trace_buffer_size                   0
_uts_inc_inmem_trace                     0
_uts_enable_alltrc_stats                 FALSE
_uts_disable_client_ip_trace             FALSE
_trace_suppress
_trace_suppress_disable                  FALSE
_uts_force_seclabel_prefix               FALSE
_trace_pool_size
trace_enabled                            TRUE
_evt_system_event_propagation            TRUE
_diag_enable_startup_events              FALSE
diagnostics_control                      IGNORE
_diag_attn_log_format_standard
_diag_attn_log_format_error
_auto_manage_exadata_disks               TRUE
_auto_manage_ioctl_bufsz                 8192
_auto_manage_num_tries                   2
_auto_manage_enable_offline_check        TRUE
_auto_manage_max_online_tries            3
_auto_manage_online_tries_expire_time    86400
_auto_manage_num_pipe_msgs               1000
_auto_manage_enable_smart_rebalance      TRUE
_auto_manage_smart_rebalance_grace_perio 0
d_in_min

_auto_manage_smart_rebalance_space_thres 0
hold

_auto_manage_infreq_tout                 0
cell_offloadgroup_name
_kxdbio_ctx_init_count                   32
_kxdbio_offena_timeout                   7200000
_kxdbio_disable_offload_opcode           0
_kxdbio_enable_ds_opcode                 0
_enable_offloaded_writes                 FALSE
_block_level_offload_high_lat_thresh     40000
_kxdbio_hca_loadavg_thresh               74
_kxdbio_ut_ctl                           0
_cell_offload_backup_compression         TRUE
_kcfis_spawn_debugger                    FALSE
_kcfis_trace_bucket_size                 131072
_kcfis_fault_control                     0
_kcfis_caching_enabled                   TRUE
_kcfis_large_payload_enabled             FALSE
_kcfis_automem_level                     1
_kcfis_cell_passthru_enabled             FALSE
_kcfis_cell_passthru_dataonly            TRUE
_kcfis_dump_corrupt_block                TRUE
_kcfis_kept_in_cellfc_enabled            TRUE
_kcfis_nonkept_in_cellfc_enabled         FALSE
_kcfis_rdbms_blockio_enabled             FALSE
_kcfis_fast_response_enabled             TRUE
_kcfis_fast_response_threshold           1048576
_kcfis_fast_response_initiosize          2
_kcfis_fast_response_iosizemult          4
_kcfis_max_out_translations              5000
_kcfis_max_cached_sessions               10
_kcfis_storageidx_disabled               FALSE
_kcfis_disable_platform_decryption       FALSE
_kcfis_storageidx_diag_mode              0
_kcfis_storageidx_set_membership_disable FALSE
d

_kcfis_byteswap_opt_disabled             FALSE
_kcfis_cellcache_disabled                FALSE
_kcfis_test_control1                     0
_kcfis_stats_level                       0
_kcfis_io_prefetch_size                  8
_kcfis_block_dump_level                  0
_kcfis_ioreqs_throttle_enabled           TRUE
_kcfis_qm_prioritize_sys_plan            TRUE
_kcfis_qm_user_plan_name
_kcfis_control1                          0
_kcfis_control2                          0
_kcfis_control3                          0
_kcfis_control4                          0
_kcfis_control5                          0
_kcfis_control6                          0
_kcfis_oss_io_size                       0
_kcfis_read_buffer_limit                 0
_cell_file_format_chunk_size             0
_cell_offload_capabilities_enabled       1
_kcfis_cell_passthru_fromcpu_enabled     TRUE
_kcfis_celloflsrv_usage_enabled          TRUE
_kcfis_celloflsrv_passthru_enabled       FALSE
_kcfis_fastfileinit_disabled             FALSE
_kcfis_xtgran_prefetch_count             1
_kcfis_storageidx_xtss_disabled          FALSE
_kcfis_pmem_enabled                      TRUE
_enable_pluggable_database               TRUE
enable_pluggable_database                TRUE
_oracle_script                           FALSE
_pdb_first_script                        FALSE
_rsrc_cpu_count                          0
_aux_storage_size                        0
_pdb_hybrid_read_only                    FALSE
_discard_cmn_ddl_in_pdb_err              FALSE
pdb_os_credential
pdb_file_name_convert
_pluggable_database_debug                0
_pdb_failure_testing                     0
noncdb_compatible                        FALSE
_cdb_compatible                          TRUE
_deferred_seg_in_seed                    TRUE
common_user_prefix                       C##
_common_user_prefix                      C##
_relocate_pdb                            FALSE
_set_container_service                   DEFAULT
_multiple_char_set_cdb                   TRUE
_pdb_char_set_intconv                    FALSE
_cdb_spfile_inherit                      FALSE
_enable_pdb_close_abort                  TRUE
_enable_pdb_close_noarchivelog           FALSE
target_pdbs                              4
max_pdbs                                 254
_pdb_cluster_database                    TRUE
_enable_pdb_isolation                    FALSE
_auto_dismount_on_pdb_close              FALSE
_pdb_mask_cdb_info                       FALSE
_split_file_copy                         TRUE
_test_offload_pdb_sga_init               FALSE
cdb_cluster                              FALSE
cdb_cluster_name
_save_afns_on_subset_pdb_creation        FALSE
_multiple_name_convert_patterns          FALSE
standby_pdb_source_file_directory
standby_pdb_source_file_dblink
_pdb_hash_table_size                     255
_pdb_hash_table_latches                  16
_pdb_lrg_auto_undots_create              FALSE
_pdb_auto_undots_create_off              FALSE
remote_recovery_file_dest
disable_pdb_feature                      0
_proxy_connect_after_set_container       TRUE
_pdb_seed_mcsc                           FALSE
_pdb_strict_plugin_compat                FALSE
_enable_pdb_process_limit                TRUE
_pdb_inherit_cfd                         FALSE
auto_start_pdb_services                  FALSE
_seed_root_undo_ratio                    30
_cdb_disable_pdb_limit                   FALSE
_slow_kill_on_pdb_close_immediate        FALSE
_edition_enable_oracle_users
_pdb_name_case_sensitive                 FALSE
_optimize_dvconfig_cloudpdb              FALSE
_default_service                         TRUE
_pdb_refresh_use_dblink_to_catalog       FALSE
_pdb_refresh_use_local_logs              TRUE
_skip_sequence_cache_close_immediate     FALSE
_pdb_oper_trace_threshold                600
_pdb_oper_trace_threshold_softassert     FALSE
_pdb_ktg_buffer_size                     16
_profile_sensitive_users
_disable_pdb_space_check                 FALSE
_restrict_local_user_dml                 TRUE
_pdb_max_diag_size                       0
_pdb_max_audit_size                      0
_reuse_dropped_pdbid_time                180
_pdb_auto_save_state                     FALSE
_next_pdbid                              3
_cloud_service_type
_pdb_ignore_table_clauses                TRUE
_no_catalog
_pdb_max_size_discount                   10
_create_pdb_flashback_barrier            FALSE
_create_pdb_disable_mirror_reads         FALSE
_pdb_clone_preserve_guid                 FALSE
_path_prefix_create_dir                  TRUE
_keep_relocated_source_pdb               FALSE
_cdb_init_batch_size                     100
_pdb_file_copy_affinitize                FALSE
_pdb_create_use_sysoper_conn             FALSE
_pdb_read_only_refresh                   FALSE
_pdb_file_copy_buffers                   8
container_data                           ALL
_non_app_ignore_errors                   TRUE
_app_ignore_errors                       TRUE
_app_default_containers                  FALSE
_exclude_seed_cdb_view                   TRUE
_disable_cdb_view_rc_invalidation        FALSE
_object_linked_remote                    FALSE
_cdb_rac_affinity                        TRUE
_cdb_view_recursive_px_enabled           TRUE
_cdb_view_no_skip_migrate                FALSE
_cdb_special_old_xplan                   TRUE
containers_parallel_degree               65535
_disable_con_recurse_queuing             TRUE
_disable_dblink_optim                    TRUE
_cdb_view_no_skip_restricted             FALSE
_intra_cdb_dblink                        FALSE
_partition_by_con_name                   FALSE
_error_row_predicate_evaluation          AUTO
_cross_con_collection                    FALSE
_predicate_validity_execution            FALSE
_cross_con_remove_pushed_preds           FALSE
_containers_multiple_ptn_key             TRUE
_ignore_svc_name_conv_mismatch           FALSE
_pdb_datapatch_violation_restricted      TRUE
_enable_view_pdb                         TRUE
_enable_guid_endpoint_service            TRUE
_enable_proxy_distr_txn                  TRUE
_enable_tenant_id_check                  FALSE
_enable_tenant_id_transfer               FALSE
_allow_privileged_session_dblink_conn    FALSE
_disable_foreign_scn_adjust              FALSE
_federation_max_root_clones              4000
_application_purge_enabled               TRUE
_federation_script                       FALSE
_application_script                      FALSE
default_sharing                          METADATA
_enable_partial_sync                     FALSE
_enable_drop_clone                       FALSE
_disable_destructive_patch_operation     TRUE
_upgrade_optim                           TRUE
_upgrade_capture_noops                   TRUE
_app_replay_silent_errors                FALSE
_capture_pgadep                          0
_sync_app_pdb_first_open                 FALSE
_disable_ptl_replay                      FALSE
_enable_module_match                     TRUE
_lrgdbcz6_ignore_restrictions            FALSE
_enable_system_app                       2
_modify_other_app_object                 FALSE
_enable_cdb_upgrade_capture              FALSE
_skip_app_object_check                   FALSE
_session_aware_replay                    TRUE
_strict_dml_data_link                    FALSE
_skip_app_unconverted_check              FALSE
_upgrade_pdb_on_open                     TRUE
_app_container_debug                     0
_enable_pmo_outside_begin_end            TRUE
_record_module_name                      TRUE
_no_snapshot_root_clone                  FALSE
_root_clone_state_from_root              TRUE
_apppdb_multi_slave_sync                 FALSE
_enable_replay_upgrade_diag              TRUE
_max_stmt_tries_sync                     2
_suppress_migration_errors               TRUE
_root_clone_skip_trigger                 TRUE
_enable_ignorable_error_capture          FALSE
_disable_marking_noops                   FALSE
_sync_error_handler
_fixup_app_pdb_status_in_root
_fixup_cdb_apps                          FALSE
_enable_cdb_all_sync                     FALSE
_oracle_script_counter                   0
_enable_load_from_clone                  TRUE
_fixup_all_apps                          FALSE
pdb_lockdown
_pdb_ldp_cascade                         0
_pdb_lockdown_bypass_sr                  0
_default_pct_free                        0
_default_ini_trans_table                 0
_default_ini_trans_index                 0
_pdb_lockdown_ddl_clauses                0
_enable_containers_subquery              TRUE
_force_containers_subquery               FALSE
_cdb_fleet_sync_timeout                  10
pdb_template
_cdb_port                                0
_cdb_svlt_use_tcps                       FALSE
_allow_xdb_anonymous_logon               FALSE
_http_port                               0
_remote_http_port                        0
_pdb_isolation_class                     NONE
_con_map_sql_enforcement                 TRUE
_uniq_cons_sql_enforcement               TRUE
_ref_cons_sql_enforcement                TRUE
_xt_http_wscl                            FALSE
_strict_utl_http_smtp                    TRUE
_psdclog_enable                          FALSE
_psdclog_threshold                       10
_disable_sensitive_internal              FALSE
_restrict_pdb_gv                         FALSE
_enable_sensitive_trace                  FALSE
_sensitive_common_as_local               FALSE
_sensitive_common_users
_bypass_sensitive_context                FALSE
_link_ts_name
_link_ts_force_online                    TRUE
_gsm
shrd_dupl_table_refresh_rate             60
_gsm_region_list
_cloud_name
_gwm_lagtype
_dbpool_name
_region_name
_db_num_gsm                              0
_gsm_config_vers                         0
_gsm_max_instances_per_db                8
_gsm_max_num_regions                     10
_gsm_drv_interval                        30
_gsm_srlat_thresh                        20
_gsm_cpu_thresh                          75
_gsm_thresh_zone                         10
_gsm_thresh_respct                       50
_gsm_svcrgnmax                           100
_gsm_srvctl_timeout                      0
_gsm_srvctl_diag_time                    0
_gwm_use_srvctl                          0
_gwm_sys_ddl                             0
_gds_chunk_num                           0
_gds_max_chunk_num                       0
_gds_allow_nullkey                       0
_skip_pset_col_chk                       0
_gds_lddlid                              0
_shardgroup_name
_gwm_db_unique_name
_gds_shardgroup_id                       0
_shardspace_name
_shd_reptype                             0
_gws_deployed                            0
_gws_encddl                              0
_gws_catalog_wallet                      0
_gws_sharding_method                     0
_gws_cache_version                       0
_gwm_database_flags
_user_defined_sharding                   0
_dupt_noupdate                           0
_shd_atomic_move                         0
multishard_query_data_consistency        strong
multishard_query_partial_results         not allowed
_oracle_special_license_1_granted        FALSE
_gwm_int_dbnum                           0
_gwm_autoons_ha_subscription
_gwm_autoons_rlb_subscription
_shard_ddl_policy                        ASYNC
shard_queries_restricted_by_key          FALSE
_gwm_disable_ra                          FALSE
_allow_cross_version_chunk_move          FALSE
_gwm_spare1
_gwm_spare2                              0
_gwm_spare3                              0
_rq_shm_max_size                         1024
_hcs_enable_all_distinct                 FALSE
_hcs_disable_exists_distinct             FALSE
_hcs_disable_filter_hierarchies          FALSE
_hcs_disable_hier_join_map_nonnull       FALSE
_hcs_disable_inline                      FALSE
_hcs_disable_level_ord                   FALSE
_hcs_disable_level_prune                 FALSE
_hcs_disable_level_prune_hier_join       FALSE
_hcs_disable_level_prune_hier_qry        FALSE
_hcs_disable_level_prune_hierarchize     FALSE
_hcs_disable_level_prune_in_qry          FALSE
_hcs_disable_level_prune_mbr_lookup      FALSE
_hcs_disable_level_prune_calc_data_joins FALSE
_hcs_disable_materialize                 FALSE
_hcs_disable_opt_estimate                FALSE
_hcs_enable_parallel_hint                FALSE
_hcs_disable_result_cache_hint           FALSE
_hcs_disable_smooth_descendants          FALSE
_hcs_disable_smooth_noop_descendants     FALSE
_hcs_disable_smooth_drill_all            FALSE
_hcs_disable_smooth_hierarchize          FALSE
_hcs_disable_smooth_remove_all           FALSE
_hcs_disable_vis_totals                  FALSE
_hcs_query_hint
_hcs_disable_bd_agg_opt                  FALSE
_hcs_disable_av_jback_opt                FALSE
_hcs_disable_all_prune                   FALSE
_hcs_disable_mv_rewrite_check            FALSE
_hcs_disable_opt_cell_qry                FALSE
_hcs_disable_cell_qry_lvl_prune_opt      FALSE
_hcs_disable_cell_qry_no_calc_nav_opt    FALSE
_hcs_disable_cell_qry_mv_cache_opt       FALSE
_hcs_disable_col_prune_optz              FALSE
_hcs_disable_rm_unused_withs_optz        FALSE
_hcs_disable_rm_like_withs_optz          FALSE
_hcs_enable_auto_av_cache                FALSE
_hcs_disable_mdx_cache_hint              FALSE
_hcs_enable_mdx_cache_name_col           FALSE
_hcs_stats_max_card                      2000000
_hcs_disable_cell_qry_no_out_data_opt    FALSE
_hcs_disable_inline_tmpl_opt             FALSE
_hcs_disable_cell_qry_atr_prune_opt      FALSE
_hcs_disable_calc_dtm_to_out_opt         FALSE
_hcs_disable_fltr_hier_star_opt          FALSE
_hcs_disable_fltr_fact_opt               FALSE
_hcs_enable_aggr_opt_estimate            FALSE
_hcs_disable_no_bdfltrd_opt              FALSE
_hcs_disable_dup_src_tbl_opt             FALSE
_hcs_enable_in_mem_cdt_hint              FALSE
_hcs_disable_dup_nav_calc_opt            FALSE
_hcs_disable_calc_opt                    FALSE
_hcs_disable_obj_cache_name              FALSE
_hcs_disable_fltr_below_fltr_star_opt    FALSE
_hcs_disable_vector_transform            FALSE
_hcs_enable_no_expand                    FALSE
_hcs_disable_unnest                      FALSE
_hcs_enable_mdx_mv_gen                   FALSE
_hcs_enable_code_trc                     FALSE
_hcs_disable_view_merge                  FALSE
_hcs_disable_all_qry_optz                FALSE
_hcs_disable_merge_fltr_star_opt         FALSE
_hcs_disable_use_cache_star_opt          FALSE
_hcs_disable_calc_union_opt              FALSE
_hcs_disable_av_sql_hint                 FALSE
_hcs_disable_audit_opt                   FALSE
_hcs_logging                             SUMMARY
_hcs_enable_unsupported_calcs            FALSE
_hcs_enable_expose_with_expr             FALSE
_hcs_disable_latest_compat_check         FALSE
_hcs_enable_parse_auto_av_cache          FALSE
_hcs_enable_mdx_sleep_after_pin          FALSE
_hcs_enable_pred_push                    TRUE
_hcs_max_mdx_cursors                     100
_hcs_mdx_sim_sga_alloc_err               NONE
_hcs_mdx_sleep_loc                       NONE
_hcs_mdx_sim_so_fail                     FALSE
_hcs_disable_xform_gby                   FALSE
_hcs_disable_prune_unslvd_star_opt       FALSE
_hcs_disable_dt_opt_cell_qry             FALSE
_hcs_enable_adw                          FALSE
_hcs_enable_cube_join                    FALSE
_hcs_log_segment_size                    10
_hcs_log_max_segments                    1000
_hcs_sim_sqlopt_err                      FALSE
_hcs_disable_sql_plan_baselines          FALSE
_hcs_enable_fact_rows                    FALSE
_hcs_enable_basetbl_transform            FALSE
_hcs_enable_av_auto_cache                FALSE
_reg_cache_status                        FALSE
_consensus_leader_heartbeat_interval     6000
_consensus_follower_election_timeout     12000
_consensus_leader_maximum_heartbeats
_consensus_queue_maximum_elements        10
_consensus_slaves_maximum_count          5
_ndb_enable                              FALSE
_ddlapply_enable                         FALSE
native_blockchain_features
_blockchainHeapSize                      0
_blockchainTracing                       0
_blockchain_forced_off                   NOT_SET
blockchain_table_max_no_drop
_enable_fsdirect_odmlib                  TRUE
_enable_fsdirect_pin                     TRUE
_pmemfs_shrink_level                     0
_pmemfs_enable_spacetracking             FALSE
_pmemfs_alloc_dataptrs                   1
_pmemfs_smallfile_threshold              1024
pmem_filestore
_enable_fsdirect_rac                     FALSE
_mle_enable_compilation                  FALSE
_mle_compile_immediately                 FALSE
_mle_compilation_errors_are_fatal        FALSE
_enable_mle                              TRUE

5997 rows selected.

Elapsed: 00:00:00.08

https://blogs.oracle.com/database/introducing-oracle-database-21c

소리소문 없이 2020년 12월 8일 Oracle 21c 버전이 릴리즈 되었다. 이전에 Preview버전으로 나왔었지만 아마도 20c 버전은 건너뛰는 듯 하다.

현재 발표된 21c의 Patching End Date 는 2023년 6월30일 까지 이다.

(21c는 Innovation Release 로 나왔기 때문에 통상적으로 지원기간이 2년정도밖에 되지 않기에 이점을 유의해야 한다.(마치 이전의 18c버전처럼) 안정적인 지원을 받기 위해서는 Long Term Release 버전인 19c를 사용해야만 한다. 19c는 Extended Supoort 기간이 2027년 4월30일 까지이다.)

해당 URL에서 New Features 및 Enhancement 등에 대한 정보를 확인할수 있다.

현재는 클라우드 상에서만 이용가능하며 On-Premise 버전은 2021년 내로 나온다고 한다.