首页 » ORACLE [C]系列, ORACLE 9i-23c » Oracle 18.3 hidden undocumented parameter list

Oracle 18.3 hidden undocumented parameter list

here is all of the Oracle 18c 18.3 on-premises hidden undocumented parameters:

SQL> select n.ksppinm p_name, c.ksppstvl p_value
2 from sys.x$ksppi n, sys.x$ksppcv c
3 where n.indx=c.indx
4 and lower(n.ksppinm) like lower(‘\_%’) escape ‘\’;

P_NAME                                             P_VALUE
-------------------------------------------------- --------------------------------------------------
_appqos_qt                                         10
_appqos_po_multiplier                              1000
_appqos_cdb_setting                                0
_ior_serialize_fault                               0
_shutdown_completion_timeout_mins                  60
_inject_startup_fault                              0
_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                                        2000
_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
__wait_test_param                                  0
__latch_test_param                                 0
_latch_pause_mode                                  static
_latch_pause_count                                 0
_min_sys_process                                   2
_session_idle_bit_latches                          0
_ksu_diag_kill_time                                5
_ksuitm_dont_kill_dumper                           FALSE
_disable_image_check                               FALSE
_num_longop_child_latches                          2
_longops_enabled                                   TRUE
_test_ksusigskip                                   5
_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                        2
_suspended_session_timeout                         300
_wait_for_busy_session                             10
_process_allocation_slots                          100
_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
_rman_roundrobin_placement
_process_heartbeat_range                           3
_max_shutdown_abort_secs                           10
_single_process                                    FALSE
_disable_cpu_check                                 FALSE
_available_core_count                              0
_cpu_eff_thread_multiplier
_dbg_proc_startup                                  FALSE
_enqueue_deadlock_time_sec                         5
_enqueue_sync_retry_attempts                       15
_enqueue_sync_sim_mem_error                        FALSE
_number_cached_attributes                          10
_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                                         FALSE
_kss_callstack_type
_oradebug_force                                    FALSE
_ksdxdocmd_default_timeout_ms                      30000
_ksdxdocmd_enabled                                 TRUE
_ksdx_charset_ratio                                0
_oradebug_cmds_at_startup
_disable_oradebug_commands                         none
_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
_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
_max_largepage_alloc_time_secs                     10
_use_hugetlbfs_for_SGA                             FALSE
_hugetlbfs_mount_point_for_sga
_dump_10261_level                                  0
_numa_shift_enabled                                TRUE
_numa_shift_value                                  0
_freeze_kgh_timestamp                              FALSE
_use_ism                                           TRUE
_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
_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
_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                        67108864
_defer_sga_min_spsz_at_startup                     53687091200
_defer_sga_test_alloc_intv                         0
_sga_alloc_slaves_term_timeout_secs                120
_ksmlsaf                                           0
_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                       15
_pga_limit_use_immediate_kill                      TRUE
_pga_limit_dump_summary                            FALSE
_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
_pga_detail_combine_auto                           FALSE
_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
__sga_current_size                                 0
__shared_pool_size                                 230686720
__large_pool_size                                  8388608
__java_pool_size                                   4194304
__streams_pool_size                                0
_large_pool_min_alloc                              65536
_shared_pool_reserved_pct                          5
_shared_pool_reserved_min_alloc                    4400
_kghdsidx_count                                    1
_pga_limit_tracing                                 0
_force_java_pool_zero                              FALSE
_pga_aggregate_xmem_limit                          0
_test_param_1                                      25
_test_param_2
_test_param_3
_test_param_4
_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_startup
_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_STARTUP
_test_param_12                                     0
_disable_instance_params_check                     FALSE
_parameter_table_block_size                        2048
_high_priority_processes                           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
_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                                0
_kse_snap_ring_record_stack                        FALSE
_kse_snap_ring_suppress                            942 1403
_kse_snap_ring_disable                             FALSE
_kse_trace_int_msg_clear                           FALSE
_system_api_interception_debug                     FALSE
_kse_ssnt                                          FALSE
_kse_alt_stack_sig_syms                            10
_messages                                          600
_enqueue_locks                                     5620
_enqueue_resources                                 2296
_enqueue_hash                                      979
_enqueue_debug_multi_instance                      FALSE
_enqueue_hash_chain_latches                        2
_enqueue_deadlock_scan_secs                        0
_enqueue_deadlock_detect_all_global_locks          FALSE
_enqueue_paranoia_mode_enabled                     FALSE
_ksi_trace
_ksi_trace_bucket                                  PRIVATE
_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
_nchar_imp_cnv                                     TRUE
_nls_parameter_sync_enabled                        TRUE
_ioslave_issue_count                               500
_ioslave_batch_count                               1
_io_slaves_disabled                                FALSE
_lgwr_io_slaves                                    0
_arch_io_slaves                                    0
_backup_disk_io_slaves                             0
_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
_enable_list_io                                    FALSE
_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
_io_outlier_threshold                              500
_io_internal_test                                  0
_lgwr_io_outlier                                   0
_asm_access                                        auto
_io_osd_param                                      1
_fob_dgaalloc                                      TRUE
_fob_ospshare                                      TRUE
_ksfd_fob_pct                                      0
_disksize_binary_search                            FALSE
_instant_file_create                               FALSE
_db_file_direct_io_count                           1048576
_cell_fast_file_create                             TRUE
_cell_fast_file_restore                            TRUE
_file_size_increase_increment                      67108864
_ofs_write_buffer_size                             1048576
_reset_maxcap_history                              10
_use_dynamic_shares                                1
_dynamic_share_range_factor                        2
_cpu_util_adj_force                                0
_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_plan
_vkrm_schedule_interval                            10
_dbrm_dynamic_threshold                            989922280
_resource_manager_always_off                       FALSE
_io_resource_manager_always_on                     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
_rm_force_caging                                   FALSE
_min_sys_percentage
_min_autotask_percentage
_db_cache_max_sz                                   0
_shared_pool_max_sz                                0
_rm_exadata_pdb_cpu_cnt                            FALSE
_rm_exadata_partition_fc                           FALSE
_rm_exadata_pdb_cpu_cnt_mult                       2
_pqq_debug_txn_act                                 FALSE
_ksr_unit_test_processes                           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
_first_spare_parameter
_second_spare_parameter
_third_spare_parameter
_fourth_spare_parameter
_fifth_spare_parameter
_sixth_spare_parameter
_seventh_spare_parameter
_eighth_spare_parameter
_ninth_spare_parameter
_tenth_spare_parameter
_eleventh_spare_parameter
_twelfth_spare_parameter
_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
_eighty-first_spare_parameter
_eighty-second_spare_parameter
_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_parameter
_one-hundred-and-twelfth_spare_parameter
_one-hundred-and-thirteenth_spare_parameter
_one-hundred-and-fourteenth_spare_parameter
_one-hundred-and-fifteenth_spare_parameter
_one-hundred-and-sixteenth_spare_parameter
_one-hundred-and-seventeenth_spare_parameter
_one-hundred-and-eighteenth_spare_parameter
_one-hundred-and-nineteenth_spare_parameter
_one-hundred-and-twentieth_spare_parameter
_one-hundred-and-twenty-first_spare_parameter
_one-hundred-and-twenty-second_spare_parameter
_one-hundred-and-twenty-third_spare_parameter
_one-hundred-and-twenty-fourth_spare_parameter
_one-hundred-and-twenty-fifth_spare_parameter
_one-hundred-and-twenty-sixth_spare_parameter
_one-hundred-and-twenty-seventh_spare_parameter
_one-hundred-and-twenty-eighth_spare_parameter
_one-hundred-and-twenty-ninth_spare_parameter
_one-hundred-and-thirtieth_spare_parameter
_one-hundred-and-thirty-first_spare_parameter
_one-hundred-and-thirty-second_spare_parameter
_one-hundred-and-thirty-third_spare_parameter
_one-hundred-and-thirty-fourth_spare_parameter
_one-hundred-and-thirty-fifth_spare_parameter
_one-hundred-and-thirty-sixth_spare_parameter
_one-hundred-and-thirty-seventh_spare_parameter
_one-hundred-and-thirty-eighth_spare_parameter
_one-hundred-and-thirty-ninth_spare_parameter
_one-hundred-and-fortieth_spare_parameter
_one-hundred-and-forty-first_spare_parameter       FALSE
_one-hundred-and-forty-second_spare_parameter      FALSE
_one-hundred-and-forty-third_spare_parameter       FALSE
_one-hundred-and-forty-fourth_spare_parameter      FALSE
_one-hundred-and-forty-fifth_spare_parameter       FALSE
_one-hundred-and-forty-sixth_spare_parameter       FALSE
_one-hundred-and-forty-seventh_spare_parameter     FALSE
_one-hundred-and-forty-eighth_spare_parameter      FALSE
_one-hundred-and-forty-ninth_spare_parameter       FALSE
_one-hundred-and-fiftieth_spare_parameter          FALSE
_one-hundred-and-fifty-first_spare_parameter       FALSE
_one-hundred-and-fifty-second_spare_parameter      FALSE
_one-hundred-and-fifty-third_spare_parameter       FALSE
_one-hundred-and-fifty-fourth_spare_parameter      FALSE
_one-hundred-and-fifty-fifth_spare_parameter       FALSE
_one-hundred-and-fifty-sixth_spare_parameter       FALSE
_one-hundred-and-fifty-seventh_spare_parameter     FALSE
_one-hundred-and-fifty-eighth_spare_parameter      FALSE
_one-hundred-and-fifty-ninth_spare_parameter       FALSE
_one-hundred-and-sixtieth_spare_parameter          FALSE
_one-hundred-and-sixty-first_spare_parameter       FALSE
_one-hundred-and-sixty-second_spare_parameter      FALSE
_one-hundred-and-sixty-third_spare_parameter       FALSE
_one-hundred-and-sixty-fourth_spare_parameter      FALSE
_one-hundred-and-sixty-fifth_spare_parameter       FALSE
_one-hundred-and-sixty-sixth_spare_parameter       FALSE
_one-hundred-and-sixty-seventh_spare_parameter     FALSE
_one-hundred-and-sixty-eighth_spare_parameter      FALSE
_one-hundred-and-sixty-ninth_spare_parameter       FALSE
_one-hundred-and-seventieth_spare_parameter        FALSE
_one-hundred-and-seventy-first_spare_parameter     FALSE
_one-hundred-and-seventy-second_spare_parameter    FALSE
_one-hundred-and-seventy-third_spare_parameter     FALSE
_one-hundred-and-seventy-fourth_spare_parameter    FALSE
_one-hundred-and-seventy-fifth_spare_parameter     FALSE
_one-hundred-and-seventy-sixth_spare_parameter     FALSE
_one-hundred-and-seventy-seventh_spare_parameter   FALSE
_one-hundred-and-seventy-eighth_spare_parameter    FALSE
_one-hundred-and-seventy-ninth_spare_parameter     FALSE
_one-hundred-and-eightieth_spare_parameter         FALSE
_one-hundred-and-eighty-first_spare_parameter      FALSE
_one-hundred-and-eighty-second_spare_parameter     FALSE
_one-hundred-and-eighty-third_spare_parameter      FALSE
_one-hundred-and-eighty-fourth_spare_parameter     FALSE
_one-hundred-and-eighty-fifth_spare_parameter      FALSE
_one-hundred-and-eighty-sixth_spare_parameter      FALSE
_one-hundred-and-eighty-seventh_spare_parameter    FALSE
_one-hundred-and-eighty-eighth_spare_parameter     FALSE
_one-hundred-and-eighty-ninth_spare_parameter      FALSE
_one-hundred-and-ninetieth_spare_parameter         FALSE
_one-hundred-and-ninety-first_spare_parameter      FALSE
_one-hundred-and-ninety-second_spare_parameter     FALSE
_one-hundred-and-ninety-third_spare_parameter      FALSE
_one-hundred-and-ninety-fourth_spare_parameter     FALSE
_one-hundred-and-ninety-fifth_spare_parameter      FALSE
_one-hundred-and-ninety-sixth_spare_parameter      FALSE
_one-hundred-and-ninety-seventh_spare_parameter    FALSE
_one-hundred-and-ninety-eighth_spare_parameter     FALSE
_one-hundred-and-ninety-ninth_spare_parameter      FALSE
_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_parameter          FALSE
_two-hundred-and-twelfth_spare_parameter           FALSE
_two-hundred-and-thirteenth_spare_parameter        FALSE
_two-hundred-and-fourteenth_spare_parameter        FALSE
_two-hundred-and-fifteenth_spare_parameter         FALSE
_two-hundred-and-sixteenth_spare_parameter         FALSE
_two-hundred-and-seventeenth_spare_parameter       FALSE
_two-hundred-and-eighteenth_spare_parameter        FALSE
_two-hundred-and-nineteenth_spare_parameter        FALSE
_two-hundred-and-twentieth_spare_parameter         FALSE
_ksipc_mode                                        0
_inet_cluster_interconnects
_ksipc_loopback_ips
_ksipc_service_level
_ksipc_window_size
_ksipc_common_sl
_ksipc_service_mask                                1
_ksipc_heap_extent                                 1048576
_ksipc_mga_segment_size                            268435456
_ksipc_group_sz                                    1024
_ksipcsnsrv
_ksipc_trace_bucket                                PRIVATE
_ksipc_trace_bucket_size                           IPC0:1048576-REST:8192
_ksipc_libipc_path
_ksipc_wait_flags                                  0
_ksipc_spare_param1                                0
_ksipc_spare_param2
_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
_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
_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_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_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
_ksipc_efchecks                                    3
_ksxp_save_sockets                                 0
_ksxp_save_sockets_pattern                         *
_ksxp_ipclw_ptswinsz                               16
_ksmd_protect_mode                                 off
_ksmd_trace                                        0
_ksmg_granule_size                                 4194304
_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
_datapump_gather_stats_on_load                     FALSE
__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
_kswsas_drain_kill_batch_size                      5
_disable_health_check                              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
_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_secs         60
_deadlock_resolution_signal_process_thresh_secs    60
_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
_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
_pmon_idle_scan_interval                           60
_cleanup_timeout                                   150
_cleanup_timeout_flags                             0
_pmon_min_slaves                                   0
_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
_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
_maxrpop_files_inst                                4
_maxrpop_instances                                 8
_use_large_pages_for_mga                           FALSE
_use_fallocate_for_mga                             FALSE
_mga_large_page_path
_ksrma_enabled                                     off
_ksrma_gsm_base_addr
_gsm_pool_size                                     134217728
_force_cloud_on                                    FALSE
_cloud_service_sim                                 0
_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
_capability_simulate
_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_enabled        TRUE
_hang_cross_cluster_hang_detection_enabled         TRUE
_hang_asm_hang_resolution_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_hang_blocked_session_delta_percent_threshold 20
_hang_blocked_session_percent_threshold            10
_hang_resolution_scope                             OFF
_hang_allow_resolution_on_single_nonrac            FALSE
_hang_resolution_policy                            HIGH
_hang_resolution_confidence_promotion              FALSE
_hang_resolution_global_hang_confidence_promotion  FALSE
_hang_resolution_allow_archiving_issue_termination TRUE
_hang_resolution_promote_process_termination       TRUE
_hang_promote_process_termination_interval         70
_hang_resolution_percent_hung_sessions_threshold   300
_hang_signature_list_match_output_frequency        10
_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_intersecting_chains_scanning_enabled         TRUE
_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_monitor_archiving_related_hang_interval      300
_hang_hiload_promoted_ignored_hang_count           2
_hang_delay_resolution_for_libcache                TRUE
_hang_terminate_session_replay_enabled             TRUE
_hang_long_wait_time_threshold                     0
_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_bool_spare1                                  TRUE
_hang_bool_spare2                                  TRUE
_hang_int_spare1                                   0
_hang_int_spare2                                   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_hash_control                                   1
_lm_lms                                            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_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_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

P_NAME                                             P_VALUE
-------------------------------------------------- --------------------------------------------------
_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                                  4000
_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                       FALSE
_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
_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                         13
_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
_adg_distributed_lockmaster                        FALSE
_ges_mseq_demo                                     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
_dlm_stats_collect                                 1
_dlm_stats_collect_mode                            4
_dlm_stats_collect_slot_interval                   60
_dlm_stats_collect_du_limit                        3000
_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_callout         TRUE
_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_kill_fg_on_timeout                             TRUE
_lm_idle_connection_max_ignore_kill_count          2
_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_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                   1000
_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_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_loop_threshold                    15
_lm_comm_rcv_msg_history_slots                     50
_lm_tkt_leak_check_count                           5
_lm_tkt_leak_check_seconds                         300
_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
_delta_push_share_blockers                         0
_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:1048576-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
_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
_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_shadow_locks
_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                           1
_gcs_disable_imc_preallocation                     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
_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
_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_pthreadno                 0
_cgs_combine_css_events                            7
_cgs_publish_netinfo_collect_event_haip            FALSE
_cgs_publish_netinfo_collect_event_chm             TRUE
_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_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
_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                          none
_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_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
_hang_statistics_collection_interval               15
_hang_statistics_collection_ma_alpha               30
_hang_statistics_high_io_percentage_threshold      25
_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                            2560
_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                          FALSE
_gcr_max_rt_procs
_gcr_enable_kill_inst_diags                        FALSE
_increase_lms_process                              0
_size_of_log_table                                 30
_size_of_status_table                              100
_gcr_dump_cpu_consumers                            FALSE
_gcr_cpu_consumer_dump_level                       0
_kjac_force_outcome_current_session                FALSE
_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
_ka_enabled                                        FALSE
_ka_mode                                           0
_ka_locks_per_sector                               4
_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_max_wait_delay                                 1000
_kjlton                                            FALSE
_kjltmaxgt                                         1000
_kjltmaxht                                         1000
_ipddb_enable                                      FALSE
_gcs_cluster_flash_cache_mode                      0
_gcs_flash_cache_mode                              0
__sga_target                                       578813952
_disable_streams_pool_auto_tuning                  FALSE
_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
_dump_scn_increment_stack
_big_scn_test_mode                                 2
_controlfile_enqueue_timeout                       900
_controlfile_enqueue_holding_time                  120
_controlfile_enqueue_holding_time_tracking_size    0
_controlfile_update_check                          OFF
_controlfile_enqueue_dump                          FALSE
_controlfile_block_size                            0
_controlfile_section_init_size
_controlfile_section_max_expand
_kill_controlfile_enqueue_blocker                  TRUE
_controlfile_backup_copy_check                     TRUE
_controlfile_cell_flash_caching                    3
_controlfile_split_brain_check                     TRUE
_controlfile_auto_convert_behaviour                AUTO_CONVERT
_controlfile_verify_on_mount                       FALSE
_db_block_buffers                                  35136
_db_block_cache_protect                            false
_db_block_cache_protect_internal                   0
_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                             702
_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                                    318767104
_db_block_numa                                     1
__shared_io_pool_size                              0
_shared_io_pool_size                               0
_db_hot_block_tracking                             FALSE
_db_block_bad_write_check                          FALSE
_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
_disable_system_tablespaces_enc_enforcement        FALSE
_cell_object_expiration_hours                      24
_db_block_lru_latches                              18
_db_percpu_create_cachesize                        2
_db_initial_cachesize_create_mb                    256
_db_num_evict_waitevents                           64
_db_todefer_cache_create                           TRUE
_db_minimum_auxsize_percent                        10
_db_imoltp_hashidx_force_nonctg                    0
_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                      3014656
_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
_enable_dbwr_auto_tracing                          0
_dbwr_nowrite_assert_interval                      7200
_dbwr_nwp_assert_interval                          1800
_remessage_dbwrs                                   0
_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
_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                       4
_db_aging_stay_count                               0
_db_aging_cool_count                               1
_db_aging_touch_time                               3
_db_aging_freeze_cr                                FALSE
_db_block_hash_buckets                             131072
_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_interval        3600
_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                        TRUE
_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                               536870912
_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                            0
_db_block_cache_history_level                      2
_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_buffer_header_history                      TRUE
_db_block_iterations_for_rm                        2000
_db_block_scandepth_for_rm                         20
_spare_test_parameter                              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                     3
_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
_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
_override_datafile_encrypt_check                   FALSE
_disable_data_block_check_after_decrypt            FALSE
_assert_encrypted_tablespace_blocks                TRUE
_verify_encrypted_tablespace_keys                  TRUE
_inject_simulated_error_period                     131072
_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_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_hours         4464
_max_reasonable_scn_rate                           32768
_external_scn_logging_threshold_seconds            86400
_external_scn_rejection_delta_threshold_minutes    0
_low_scn_headroom_warning_threshold_days           90
_high_intrinsic_scn_growth_alert                   1440
_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
_arch_sim_mode                                     0
_dg_corrupt_redo_log                               0
_local_arc_assert_on_wait                          FALSE
_defer_eor_orl_arch_for_so                         TRUE
_enable_ffw                                        TRUE
_log_archive_trace_pids
_redo_transport_sanity_check                       0
_fix_fuzzy_scn                                     FALSE
_dg_cf_check_timer                                 15
_bypass_srl_for_so_eor                             FALSE
_rta_sync_wait_timeout                             10
_log_archive_prot_auto_demote                      FALSE
_serialize_lgwr_sync_io                            FALSE
_mgd_rcv_handle_orphan_datafiles                   FALSE
_real_time_apply_sim                               0
_defer_rcv_during_sw_to_sby                        FALSE
_skip_trstamp_check                                TRUE
_show_mgd_recovery_state                           FALSE
_log_archive_buffers                               10
_redo_transport_compress_all                       TRUE
_rtc_infeasible_threshold                          25
_disable_thread_snapshot                           TRUE
_redo_log_record_life                              168
_redo_log_debug_config                             0
_redo_log_check_backup                             10
_log_archive_avoid_memcpy                          TRUE
_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_percentage      50
_redo_transport_resource_management                FALSE
_lgwr_ns_nl_min                                    500
_lgwr_ns_nl_max                                    1000
_redo_transport_stall_time                         360
_redo_transport_stall_time_long                    3600
_max_lns_shutdown_archival_time                    30
_ta_lns_wait_for_arch_log                          20
_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                                      4
_lgwr_delay_write                                  FALSE
_enable_redo_global_post                           FALSE
_cache_orl_during_open                             ALL
_image_redo_gen_delay                              0
_simulate_dax_storage                              DISABLE
_log_silicon_secured_memory                        TRUE
_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_switch_timeout                                0
_log_buffers_debug                                 FALSE
_log_buffers_corrupt                               FALSE
_log_simultaneous_copies                           4
_use_single_log_writer                             ADAPTIVE
_max_outstanding_log_writes                        2
_log_write_worker_task_prefetch                    EARLY
_log_write_worker_task_spinwait                    0
_log_write_worker_post_spinwait                    0
_adaptive_scalable_log_writer_enable_worker_thresh 200
old

_adaptive_scalable_log_writer_disable_worker_thres 50
hold

_adaptive_scalable_log_writer_sampling_count       128
_adaptive_scalable_log_writer_sampling_time        3
_adaptive_scalable_log_writer_enable_worker_aging  999900
_log_parallelism_max                               2
_log_parallelism_dynamic                           TRUE
_max_log_write_parallelism                         1
_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                          50
_fg_fast_sync_spin_usecs                           300
_log_file_sync_timeout                             10
_use_adaptive_log_file_sync                        TRUE
_adaptive_log_file_sync_use_polling_threshold      200
_adaptive_log_file_sync_use_postwait_threshold     50
_adaptive_log_file_sync_use_postwait_threshold_agi 1001
ng

_adaptive_log_file_sync_sampling_count             128
_adaptive_log_file_sync_sampling_time              3
_adaptive_log_file_sync_sched_delay_window         60
_adaptive_log_file_sync_poll_aggressiveness        0
_adaptive_log_file_sync_high_switch_freq_threshold 3
_max_pending_scn_bcasts                            9
_lgwr_posts_for_pending_bcasts                     FALSE
_long_log_write_warning_threshold                  500
_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_freq        5000
_hb_redo_interval                                  1000
_db_file_exec_read_count                           74
_db_file_optimizer_read_count                      8
_db_file_noncontig_mblock_read_count               11
_db_recovery_temporal_file_dest
_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
_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_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
_kcl_conservative_log_flush                        FALSE
_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                                    1024
_gc_fusion_compression                             1024
_gc_down_convert_after_keep                        TRUE
_gc_delta_push_objects                             0
_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                                  TRUE
_gc_temp_affinity                                  FALSE
_gc_fg_spin_time                                   0
_gc_object_queue_max_length                        0
_gc_async_send                                     TRUE
_gc_async_receive                                  FALSE
_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_max_reg_sz                                     68719476736
_gc_partial_cleanout                               FALSE
_gc_undo_rdma_read                                 FALSE
_gc_lease_time                                     500
_adaptive_direct_read                              TRUE
_adaptive_direct_write                             TRUE
_db_block_align_direct_read                        TRUE
_db_noarch_disble_optim                            FALSE
_db_disable_temp_encryption                        FALSE
_kcbl_assert_reset_slot                            TRUE
_direct_io_slots                                   0
_direct_io_skip_cur_slot_on_error                  TRUE
_direct_io_wslots                                  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
_auto_rekey_during_mrcv                            TRUE
_auto_rcv_pdb_open                                 1
_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
_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
_skip_pdb_recovery_if_keystore_not_open            FALSE
_serial_recovery                                   FALSE
_coord_message_buffer                              0
_multiple_instance_recovery                        FALSE
_backup_kgc_scheme                                 ZLIB
_backup_kgc_bufsz                                  0
_backup_kgc_type                                   0
_backup_kgc_niters                                 0
_backup_lzo_size                                   262144
_backup_kgc_perflevel                              1
_backup_kgc_windowbits                             15
_backup_kgc_memlevel                               8
_backup_kgc_blksiz                                 9
_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
_update_datafile_headers_with_space_information    FALSE
_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
_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
_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
_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

P_NAME                                             P_VALUE
-------------------------------------------------- --------------------------------------------------
_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                      1
_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
_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_module          100
_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                         104857600
_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_maxsize                     0
_bct_mrp_timeout                                   600
_krc_trace_buffer_size                             131072
_kra_trace_buffer_size                             131072
_kra_cfile_compaction                              TRUE
_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
_flashback_logfile_enqueue_timeout                 600
_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                  8388608
_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
_tdb_debug_mode                                    16
_log_read_buffers                                  8
_change_vector_buffers                             1
_change_vector_read_sample_ratio                   0
_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_disabled          FALSE
_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                                FALSE
_db_block_prefetch_skip_reading_enabled            TRUE
_db_block_prefetch_fast_longjumps_enabled          TRUE
_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
_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_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
_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_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_redirect_flags                                0
_row_locking                                       always
_serializable                                      FALSE
_scn_wait_interface_max_timeout_secs               2147483647
_scn_wait_interface_max_backoff_time_secs          600
_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
_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_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_segment_initial                          1
_offline_rollback_segments
_corrupted_rollback_segments
_rollback_segment_count                            0
_smu_timeouts
_smu_debug_mode                                    0
_undo_debug_mode                                   0
_tablespaces_per_transaction                       10
_verify_undo_quota                                 FALSE
_in_memory_tbs_search                              TRUE
_highthreshold_undoretention                       4294967294
_undo_autotune                                     TRUE
_collect_undo_stats                                TRUE
_collect_tempundo_stats                            TRUE
_indoubt_pdb_transactions_force_outcome            COMMIT
_imtxnrma_table_enable                             FALSE
_transaction_recovery_servers                      0
_parallel_recovery_stopat                          32767
_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_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_quota         20
_inmemory_private_journal_numbkts                  512
_inmemory_private_journal_numgran                  255
_inmemory_private_journal_maxexts                  5000
_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                      758
_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
_ktst_rss_min                                      100
_ktst_rss_max                                      1000
_ktst_rss_retry                                    5
_ktst_tscleanup_timeout                            1800
_force_active_temp_detection                       FALSE
_partition_large_extents                           TRUE
_index_partition_large_extents                     FALSE
_force_local_temp                                  FALSE
_prefer_local_temp                                 FALSE
_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
_inst_locking_period                               5
_allocation_update_interval                        3
_minimum_blocks_to_shrink                          0
_minimum_extents_to_shrink                         1
_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
_disable_def_seg_update                            0
_use_cached_asm_free_space                         FALSE
_ena_storage_lmt                                   DEFAULT
_kttext_warning                                    5
_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
_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
_enable_ilm_flush_stats                            TRUE
_enable_ilm_testflush_stats                        FALSE
_disable_12cbigfile                                FALSE
_enable_heatmap_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_64k_percent                              30
_inmemory_expressions_area_percent                 10
_inmemory_min_ima_defersize                        0
_inmemory_memprot                                  TRUE
__inmemory_ext_rwarea                              0
_inmemory_ext_rwarea                               0
__inmemory_ext_roarea                              0
_inmemory_ext_roarea                               0
_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
_db_row_overlap_checking                           TRUE
_db_index_block_checking                           TRUE
_kdi_avoid_block_checking                          FALSE
_disable_block_checking                            FALSE
_kd_symtab_chk                                     TRUE
_sage_block_checking                               FALSE
_suppress_identifiers_on_dupkey                    FALSE
_compression_compatibility                         18.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
_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
_index_alert_key_not_found                         FALSE
_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                                       262144
_ldr_io_size2                                      1048576
_ldr_pga_lim                                       0
_ldr_tempseg_threshold                             8388608
_lmn_invalidlkr_enabled                            TRUE
_ignore_desc_in_index                              FALSE
_kdic_segarr_sz                                    0
_keep_remote_column_size                           FALSE
_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                                TRUE
_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_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
_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
_kdlf_read_flag                                    0
_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_default_svc                              0
_inmemory_default_svcname
_inmemory_disable_selective_vircols                FALSE
_inmemory_expression_count                         20
_inmemory_max_expressions_table                    50
_inmemory_expressions_mark_unused                  FALSE
_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_servers_throttle_pgalim_percent          55
_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_multiplier       10
_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_percent         100
_inmemory_fsdw_priority_repopulation_percent       90
_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_factor      5
_inmemory_repopulate_threshold_mintime             0
_inmemory_repopulate_threshold_scans               0
_inmemory_repopulate_priority_scale_factor         100
_inmemory_repopulate_invalidate_rate_percent       0
_inmemory_repopulate_priority_threshold_row        160
_inmemory_repopulate_priority_threshold_block      320
_inmemory_repopulate_threshold_rows_percent        5
_inmemory_repopulate_threshold_blocks_percent      10
_inmemory_repopulate_disable                       2
_inmemory_check_protect                            FALSE
_inmemory_checksum                                 FALSE
_inmemory_cu_checksum                              FALSE
_inmemory_validate_fetch                           FALSE
_inmemory_journal_row_logging                      FALSE
_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                            0
_inmemory_dbg_scan                                 0
_inmemory_query_check                              0
_inmemory_test_verification                        0
_inmemory_invalidate_cursors                       TRUE
_inmemory_prepopulate_fg                           0
_inmemory_format_compatible                        12.2.0.0.0
_inmemory_prepopulate                              TRUE
_inmemory_trickle_repopulate                       TRUE
_inmemory_trickle_repopulate_threshold_dirty_ratio 0
_inmemory_trickle_repopulate_min_interval          300
_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_dynamic_scans                            AUTO
_inmemory_dynamic_scans_batch_size                 500
_inmemory_dynamic_scans_analyze_batch_size         5
_inmemory_dynamic_scan_disable_threshold           10
_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
_imado_diagtasks_log_period                        5
_imado_diagtasks_purge_period                      30
_imado_sysaux_usage_limit                          90
_imado_disable_bg                                  FALSE
_imado_mem_threshold                               98
_imado_optim_algo                                  GREEDY
_imado_optimize_period                             0
_imado_verification                                0
_imado_evict_sf                                    2
_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_value          0
_advanced_index_compression_recmp_cusz             90
_advanced_index_compression_recmp_crsz             10
_advanced_index_compression_recmp_nprg             10
_column_level_stats                                OFF
_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
_kdfip_flush_nrows                                 10
_kdfip_flush_rowsz                                 1024
_kdfip_flush_rowtm                                 60
_kdfip_cmap_nbkt                                   16
_kdfip_iga_bufsz                                   65536
_kdfip_iga_maxsz                                   52428800
_kdfip_par_flush                                   TRUE
_kdfip_trace                                       FALSE
_kdfip_debug                                       0
_kdfip_buf_nclatch                                 64
_kdfip_elem_nclatch                                64
_kdfip_bufl_nbkt                                   64
_kdfip_drain_sleeps                                60
_kqr_optimistic_reads                              TRUE
_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
_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                                 256
_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
_enable_kqf_purge                                  TRUE
_object_number_cache_size                          5
_enable_Front_End_View_Optimization                1
_max_remote_tool_requests                          10
_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
_lock_dc_users_time                                120
_enable_secure_sub_role                            FALSE
_case_sensitive_logon                              TRUE
_VIEW_DICTIONARY_ACCESSIBILITY                     FALSE
_restrict_become_user                              TRUE
_enable_http_digest_generation                     TRUE
_passwordfile_enqueue_timeout                      900
_iat_frequency_short                               FALSE
_dynamic_rls_policies                              TRUE
_virtual_column_access_control                     TRUE
_allow_insert_with_update_check                    FALSE
_session_context_size                              10000
_default_encrypt_alg                               0
_tsenc_obfuscate_key                               BOTH
_db_discard_lost_masterkey                         FALSE
_db_generate_dummy_masterkey                       FALSE
_use_fips_mode                                     FALSE
_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_SCN         TRUE
_ols_cleanup_task                                  TRUE
_sys_logon_delay                                   1
_pbkdf2_sder_count                                 3
_resource_includes_unlimited_tablespace            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
_unified_audit_policy_disabled                     FALSE
_unified_audit_flush_threshold                     85
_unified_audit_flush_interval                      3
_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
_distributed_recovery_connection_hold_time         200
_reco_sessions_max_percentage                      50
_k2q_latches                                       0
_clusterwide_global_transactions                   TRUE
_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
_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                          2
_kernel_message_network_driver                     FALSE
_dedicated_server_poll_count                       10
_dedicated_server_post_wait_call                   FALSE
_dedicated_server_post_wait                        FALSE
_mpmt_fg_enabled                                   FALSE
_bequeath_via_broker                               FALSE
_cp_num_hash_latches                               1
_connection_broker_host                            localhost
_connection_broker_handout_accept                  FALSE
__reload_lsnr                                      0
_disable_duplicate_service_warning                 FALSE
_pdb_service_on_root_listener                      FALSE
_fast_cursor_reexecute                             FALSE
_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
_dump_qbc_tree                                     0
_sql_alias_scope                                   TRUE
_plsql_dump_buffer_events
_ncomp_shared_objects_dir
_plsql_anon_block_code_type                        INTERPRETED
_inline_sql_in_plsql                               FALSE
_plsql_native_frame_threshold                      4294967294
_plsql_nvl_optimize                                FALSE
_plsql_icd_arg_dump                                FALSE
_plsql_max_stack_size                              0
_EnableShadowTypes                                 FALSE
_job_queue_interval                                5
_redef_on_statement                                FALSE

P_NAME                                             P_VALUE
-------------------------------------------------- --------------------------------------------------
_duplicated_table_complete_refresh_percent         50
_dbms_sql_security_level                           1
_parallel_default_max_instances                    1
_system_trig_enabled                               TRUE
_AllowMultInsteadofDDLTrigger                      0
_kktAllowInsteadOfDDLTriggeronDDL                  0
_EnableDDLTtriggerTracing                          FALSE
_kkfi_trace                                        FALSE
_lock_ref_constraint_count                         50
_lock_next_constraint_count                        3
_adjust_literal_replacement                        FALSE
_kolfuseslf                                        FALSE
_lock_ref_descendants_count                        50
_kkpogpi_nocpy                                     0
_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
_STFTranslateDynamicSQL                            FALSE
_bigdata_external_table                            TRUE
_external_table_hive_partition_restricted          TRUE
_qksfgi_disable_action_mask                        0
_qksfgi_disable_oct_mask                           0
_qksfgi_dynamic_partitions
_qksfgi_feature_level                              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_server_idle_time                         30000
_parallel_server_sleep_time                        1
_px_send_timeout                                   300
_dynamic_stats_threshold                           30
_px_execution_services_enabled                     TRUE
_parallel_fake_class_pct                           0
_px_load_publish_interval                          200
_px_proactive_slave_alloc_threshold                4
_px_load_balancing_policy                          UNIFORM
_px_dp_array_size                                  32767
_px_parallel_spawn_min_count                       2
_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_multiblock_io_count                          0
_cursor_db_buffers_pinned                          115
_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_compression_ratio   8
_sqlexec_join_group_aware_hj_enabled               TRUE
_sqlexec_join_group_aware_hj_unencoded_rowsets_tol 50
erated

_sqlexec_cache_aware_hash_aggr_enabled             TRUE
_in_memory_cdt                                     LIMITED
_in_memory_ts_only                                 OFF
_in_memory_memory_threshold                        40
_in_memory_cdt_maxpx                               4
_ptt_max_num                                       16
_fix_control
_sdiag_crash                                       NONE
_result_cache_block_size                           1024
_result_cache_copy_block_count                     1
_result_cache_global                               TRUE
_result_cache_per_pdb                              TRUE
_result_cache_timeout                              10
_result_cache_white_list
_result_cache_black_list
_result_cache_latch_free_reads                     ADMIN
_result_cache_auto_time_distance                   300
_result_cache_auto_dml_monitoring_slots            4
_result_cache_auto_dml_monitoring_duration         15
_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
_ptf_max_rows                                      1024
_qesma_mvob_lru_sz                                 25
_qesma_bo_lru_sz                                   25
_qesmasc_trc                                       0
_ptf_enable_objects                                FALSE
_oss_skgxp_udp_dynamic_credit_mgmt
_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
_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                          FALSE
_disable_streams_diagnostics                       0
_max_aq_persistent_queue_memory                    10
_no_objects                                        FALSE
_kokli_cache_size                                  128
_kokln_current_read                                FALSE
_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
_all_shared_dblinks
_disttxn_for_queries                               TRUE
_close_cached_open_cursors                         FALSE
_disable_savepoint_reset                           FALSE
_init_sql_file                                     ?/rdbms/admin/sql.bsq
_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_enabled         FALSE
_cell_offload_timezone                             TRUE
_direct_read_decision_statistics_driven            TRUE
_cell_offload_hybrid_processing                    TRUE
_cell_offload_complex_processing                   TRUE
_cell_offload_vector_groupby                       TRUE
_cell_offload_vector_groupby_force                 FALSE
_shrunk_aggs_disable_threshold                     60
_gby_onekey_enabled                                TRUE
_sql_connect_capability_table
_optimizer_mode_force                              TRUE
_explain_rewrite_mode                              FALSE
_query_rewrite_or_error                            FALSE
_sort_elimination_cost_ratio                       0
_grant_secure_role                                 FALSE
_sql_connect_capability_override                   0
_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
_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                        18.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
_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_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
_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_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                             21
_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                             197132288
_pga_max_size                                      209715200
_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                                      189
_smm_max_size_static                               37888
_smm_px_max_size_static                            94720
_smm_max_size                                      37888
_smm_px_max_size                                   94720
_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
_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
_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
_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
_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_size         50
_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_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                            1
_optimizer_multiple_cenv
_kql_subheap_trace                                 0
_optimizer_cost_hjsmj_multimatch                   TRUE
_optimizer_transitivity_retain                     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
_enable_ddl_wait_lock                              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_improve_selectivity                     TRUE
_optimizer_aw_join_push_enabled                    TRUE
_cvw_enable_weak_checking                          TRUE
_enable_online_index_without_s_locking             TRUE
_dbop_enabled                                      1
_sqlmon_threshold                                  5
_sqlmon_max_plan                                   40
_sqlmon_max_planlines                              300
_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_time_unit                                10
_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_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
_arch_compress_checksums                           FALSE
_optimizer_eliminate_filtering_join                TRUE
_create_table_in_any_cluster                       FALSE
_dsc_feature_level                                 0
_parallel_statement_queuing                        FALSE
_parallel_conservative_queuing                     FALSE
_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_count         10000
_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
_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
_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_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
_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_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_monitor_load                                   FALSE
_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
_part_access_version_by_number                     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_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_opt_enabled TRUE
_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
_sqlexec_hash_based_distagg_enabled                FALSE
_sqlexec_disable_hash_based_distagg_tiv            FALSE
_sqlexec_hash_based_distagg_ssf_enabled            TRUE
_sqlexec_distagg_optimization_settings             0
_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
_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_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            65528
_optimizer_interleave_or_expansion                 TRUE
_px_partition_load_dist_threshold                  64
_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
_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
_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
_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
_alter_upgrade_signature_only                      FALSE
_spadr                                             YES
_sec_enable_test_rpcs                              FALSE
_use_zero_copy_io                                  TRUE
_tstz_localtime_bypass                             FALSE
_client_tstz_error_check                           TRUE
_drain_on_ping_database                            TRUE
_client_result_cache_bypass                        FALSE
_client_result_cache_ramthreshold
_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
_enable_nativenet_tcpip                            FALSE
_async_scn_sync                                    OFF
_share_drcp_proxy_sessions                         TRUE
_request_boundaries                                1
_spfoc                                             OFF
_spfdc                                             OFF
_spfei
_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_statistics_duration                         0

P_NAME                                             P_VALUE
-------------------------------------------------- --------------------------------------------------
_orph_cln_interval                                 1200
_aq_max_scan_delay                                 1500
_aq_tm_scanlimit                                   0
_aq_tm_deqcountinterval                            0
_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_threshold          0
_buffered_publisher_flow_control_threshold         0
_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
_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_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
_ctx_doc_policy_stems                              FALSE
_nonce_history_buffer_size                         0
_dg_broker_trace_level
_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_retention          FALSE
_olapi_memory_operation_history_pause_at_seqno     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_hints
_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_rows_for_use 1
_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_materialization        TRUE
_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_reloc_cic                                     FALSE
_asm_oda_type
_asm_allow_system_alias_rename                     FALSE
_asm_instlock_quota                                0
_asm_relocation_trace                              FALSE
_asm_disk_repair_time                              14400
_asm_disable_profilediscovery                      FALSE
_asm_relocation_ignore_hard_failure                0
_asm_max_parallelios                               256
_asm_auto_online_interval
_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
_kffmap_hash_size                                  1024
_kffmop_hash_size                                  2048
_kffmlk_hash_size                                  512
_asm_diskgroups2
_asm_diskgroups3
_asm_diskgroups4
_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                        4
_asm_relocation_scheme                             alloc_p2 alloc_s3 reb_p2 reb_s1 bal_p2 bal_s3 prep
                                                   _p2 prep_s3

_asm_disable_dangerous_failgroup_checking          FALSE
_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_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_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
_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                          FALSE
_asm_disable_vxn_map_messages                      FALSE
_asm_asmb_rcvto                                    10
_asm_asmb_max_wait_timeout                         6
_asm_tcp_user_timeout                              1
_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_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_force_parity_extent_check                     FALSE
_asm_enable_kfios                                  FALSE
_asm_networks
_asm_access_assume_local                           FALSE
_asm_iosconnect_timeout                            0
_asm_ios_network_domains                           0
_asm_ios_network_processes                         0
_asm_netp_factor                                   0
_asm_idn_processes                                 0
_asm_iowp_max_async                                0
_asm_max_clients                                   1000
_asm_netp_iosize                                   0
_asm_dbmsdg_nohdrchk                               FALSE
_asm_root_directory                                ASM
_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
_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
_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                TRUE
_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
_memory_max_tgt_inc_cnt                            0
_asm_enable_xrov                                   FALSE
_asm_xrov_single                                   FALSE
_asm_xrov_rsnmod                                   1
_asm_xrov_nvios                                    8
_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_enable_parityfile_creation                    FALSE
_asm_enable_parity_datafile_creation               FALSE
_enable_multiple_fgprepares                        FALSE
_enable_single_dgprepare                           FALSE
_asm_allow_prepare_split                           TRUE
_enable_ios_spm                                    FALSE
_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_incremental_flush_enabled                     TRUE
_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_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                            TRUE
_ash_progressive_flush_interval                    300
_kebm_nstrikes                                     3
_kebm_suspension_time                              104400
_kebm_sanity_check_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
_automatic_maintenance_test                        0
_autotask_min_window                               15
_autotask_max_window                               480
_enable_automatic_maintenance                      1
_autotask_test_name                                N/A
_autotask_test_action                              0
_bsln_adaptive_thresholds_enabled                  TRUE
_wcr_control                                       0
_dbreplay_feature_control
_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
_diag_verbose_error_on_init                        0
_diag_hm_rc_enabled                                TRUE
_diag_hm_tc_enabled                                FALSE
_diag_adr_enabled                                  TRUE
_diag_adr_auto_purge                               TRUE
_diag_backward_compat                              TRUE
_diag_adr_test_param                               0
_diag_adr_trace_dest                               /oracle/diag/rdbms/ora18c/ora18c/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
_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
_trace_files_public                                FALSE
_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
_trace_pool_size
_evt_system_event_propagation                      TRUE
_diag_enable_startup_events                        FALSE
_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_infreq_tout                           0
_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
_enable_pluggable_database                         FALSE
_oracle_script                                     FALSE
_pdb_first_script                                  FALSE
_discard_cmn_ddl_in_pdb_err                        FALSE
_pluggable_database_debug                          0
_pdb_failure_testing                               0
_cdb_compatible                                    TRUE
_deferred_seg_in_seed                              TRUE
_common_user_prefix                                C##
_relocate_pdb                                      FALSE
_set_container_service                             DEFAULT
_multiple_char_set_cdb                             TRUE
_cdb_spfile_inherit                                FALSE
_enable_pdb_close_abort                            TRUE
_enable_pdb_close_noarchivelog                     FALSE
_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
_save_afns_on_subset_pdb_creation                  FALSE
_multiple_name_convert_patterns                    FALSE
_pdb_hash_table_size                               255
_pdb_hash_table_latches                            16
_pdb_lrg_auto_undots_create                        FALSE
_pdb_auto_undots_create_off                        FALSE
_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
_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
_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
_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
_enable_view_pdb                                   TRUE
_enable_guid_endpoint_service                      TRUE
_enable_proxy_adg_redirect                         FALSE
_federation_max_root_clones                        5
_application_purge_enabled                         TRUE
_federation_script                                 FALSE
_application_script                                FALSE
_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
_enable_auto_upgrade                               FALSE
_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                           TRUE
_pdb_ldp_cascade                                   0
_pdb_lockdown_bypass_sr                            FALSE
_enable_containers_subquery                        TRUE
_force_containers_subquery                         FALSE
_cdb_fleet_sync_timeout                            10
_cdb_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
_gsm
_gsm_region_list
_cloud_name
_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
_gds_chunk_num                                     0
_gds_max_chunk_num                                 0
_gds_allow_nullkey                                 0
_gds_lddlid                                        0
_shardgroup_name
_gwm_db_unique_name
_gds_shardgroup_id                                 0
_shardspace_name
_shd_reptype                                       0
_gws_deployed                                      0
_gws_sharding_method                               0
_gws_cache_version                                 0
_gwm_database_flags
_user_defined_sharding                             0
_dupt_noupdate                                     0
_shd_atomic_move                                   0
_gwm_spare1
_gwm_spare2                                        0
_gwm_spare3                                        0
_rq_shm_max_size                                   1024
_hcs_perf                                          FALSE
_hcs_all_distinct                                  FALSE
_hcs_no_exists_distinct                            FALSE
_hcs_no_filter_hierarchies                         FALSE
_hcs_no_hier_join_map_nonnull                      FALSE
_hcs_no_level_ord                                  FALSE
_hcs_no_level_prune                                FALSE
_hcs_no_level_prune_gby                            FALSE
_hcs_no_level_prune_hier_join                      FALSE
_hcs_no_level_prune_hier_qry                       FALSE
_hcs_no_level_prune_hierarchize                    FALSE
_hcs_no_level_prune_in_qry                         FALSE
_hcs_no_level_prune_mbr_lookup                     FALSE
_hcs_no_level_prune_vis_lvs                        FALSE
_hcs_logging                                       SUMMARY
_hcs_no_materialize                                FALSE
_hcs_no_opt_estimate                               FALSE
_hcs_parallel_hint                                 FALSE
_hcs_no_result_cache_hint                          FALSE
_hcs_no_smooth_descendants                         FALSE
_hcs_no_smooth_drill_all                           FALSE
_hcs_no_smooth_hierarchize                         FALSE
_hcs_no_smooth_remove_all                          FALSE
_hcs_no_sql_pred_push                              FALSE
_hcs_no_vis_totals                                 FALSE
_hcs_ignore_unsupported_calcs                      FALSE
_hcs_query_hint
_hcs_no_bd_agg_opt                                 FALSE
_hcs_no_sp_jback_opt                               FALSE
_hcs_no_av_jback_opt                               FALSE
_hcs_no_all_prune                                  FALSE
_hcs_avcache_dynamic_enabled                       FALSE
_hcs_no_hord_in_oby_prune                          FALSE
_hcs_no_jback_opt_for_hord_in_oby                  FALSE
_hcs_no_mv_rewrite_check                           FALSE
_hcs_no_cell_qry_tmpls                             FALSE
_hcs_no_opt_cell_qry                               FALSE
_hcs_no_cell_qry_meas_prune_opt                    FALSE
_hcs_no_cell_qry_lvl_prune_opt                     FALSE
_hcs_no_cell_qry_no_calc_nav_opt                   FALSE
_hcs_no_cell_qry_mv_cache_opt                      FALSE
_hcs_ignore_latest_compat_check                    FALSE
_hcs_no_col_prune_optz                             FALSE
_hcs_no_rm_unused_withs_optz                       FALSE
_hcs_no_rm_like_withs_optz                         FALSE
_hcs_use_dynamic_all_cache                         FALSE
_hcs_parse_dynamic_all_cache                       FALSE
_hcs_no_mdx_cache_hint                             FALSE
_hcs_mdx_cache_name_no_sid                         FALSE
_hcs_mdx_cache_name_col                            FALSE
_hcs_use_multi_parent_gen                          FALSE
_hcs_mdx_sleep_after_pin                           FALSE
_hcs_stats_max_card                                2000000
_hcs_no_cell_qry_no_out_data_opt                   FALSE
_hcs_no_inline_tmpl_opt                            FALSE
_hcs_no_rmv_unref_top_opt                          FALSE
_hcs_no_cell_qry_atr_prune_opt                     FALSE
_hcs_no_calc_dtm_to_out_opt                        FALSE
_hcs_no_fltr_hier_star_opt                         FALSE
_hcs_no_fltr_fact_opt                              FALSE
_hcs_gen_aggr_opt_estimate                         FALSE
_hcs_no_tgt_depths_opt                             FALSE
_hcs_in_mem_cdt_hint                               FALSE
_hcs_expose_with_expr                              FALSE
_hcs_opt_av_pred_push                              TRUE
_reg_cache_status                                  FALSE

4723 rows selected.
打赏

对不起,这篇文章暂时关闭评论。