Hidden Init Parameters

See Also: Init-Parameters

name sesvalue value
_4031_dump_bitvec 67194879 67194879
_4031_dump_interval 300 300
_4031_max_dumps 100 100
_4031_sga_dump_interval 3600 3600
_4031_sga_max_dumps 10 10
_NUMA_instance_mapping Not specified Not specified
_NUMA_pool_size Not specified Not specified
_PX_use_large_pool FALSE FALSE
__db_cache_size 20971520 20971520
__dg_broker_service_names orcl10_XPT orcl10_XPT
__java_pool_size 4194304 4194304
__large_pool_size 4194304 4194304
__shared_pool_size 50331648 50331648
__streams_pool_size 0 0
_abort_recovery_on_join FALSE FALSE
_accept_versions
_active_standby_fast_reconfiguration TRUE TRUE
_adaptive_direct_read TRUE TRUE
_adaptive_fetch_enabled TRUE TRUE
_add_stale_mv_to_dependency_list TRUE TRUE
_addm_auto_enable TRUE TRUE
_addm_skiprules
_addm_version_check TRUE TRUE
_adjust_literal_replacement FALSE FALSE
_affinity_on TRUE TRUE
_aiowait_timeouts 100 100
_alert_expiration 604800 604800
_alert_message_cleanup 1 1
_alert_message_purge 1 1
_alert_post_background 1 1
_all_shared_dblinks
_allocate_creation_order FALSE FALSE
_allocation_update_interval 3 3
_allow_commutativity TRUE TRUE
_allow_error_simulation FALSE FALSE
_allow_level_without_connect_by FALSE FALSE
_allow_read_only_corruption FALSE FALSE
_allow_resetlogs_corruption FALSE FALSE
_allow_terminal_recovery_corruption FALSE FALSE
_alternate_iot_leaf_block_split_points TRUE TRUE
_always_anti_join CHOOSE CHOOSE
_always_semi_join CHOOSE CHOOSE
_always_star_transformation FALSE FALSE
_app_ctx_vers FALSE FALSE
_aq_tm_scanlimit 0 0
_arch_io_slaves 0 0
_array_update_vector_read_enabled FALSE FALSE
_ash_disk_filter_ratio 10 10
_ash_disk_write_enable TRUE TRUE
_ash_dummy_test_param 0 0
_ash_eflush_trigger 66 66
_ash_enable TRUE TRUE
_ash_sample_all FALSE FALSE
_ash_sampling_interval 1000 1000
_ash_size 1048618 1048618
_asm_acd_chunks 1 1
_asm_allow_only_raw_disks TRUE TRUE
_asm_allow_resilver_corruption FALSE FALSE
_asm_ausize 1048576 1048576
_asm_blksize 4096 4096
_asm_disk_repair_time 14400 14400
_asm_droptimeout 60 60
_asm_emulmax 10000 10000
_asm_emultimeout 0 0
_asm_kfdpevent 0 0
_asm_libraries ufs ufs
_asm_maxio 1048576 1048576
_asm_stripesize 131072 131072
_asm_stripewidth 8 8
_asm_wait_time 18 18
_asmlib_test 0 0
_asmsid asm asm
_assm_default TRUE TRUE
_async_object_flush TRUE TRUE
_async_recovery_claims TRUE TRUE
_async_recovery_reads TRUE TRUE
_avoid_prepare TRUE TRUE
_awr_corrupt_mode FALSE FALSE
_awr_disabled_flush_tables
_awr_flush_threshold_metrics FALSE FALSE
_awr_flush_workload_metrics FALSE FALSE
_awr_mmon_cpuusage TRUE TRUE
_awr_restrict_mode FALSE FALSE
_awr_sql_child_limit 200 200
_b_tree_bitmap_plans TRUE TRUE
_backup_disk_io_slaves 0 0
_backup_io_pool_size 1048576 1048576
_backup_kgc_bufsz 0 0
_backup_kgc_niters 0 0
_backup_kgc_type 0 0
_backup_ksfq_bufcnt 0 0
_backup_ksfq_bufsz 0 0
_backup_max_gap_size 4294967294 4294967294
_bct_bitmaps_per_file 8 8
_bct_buffer_allocation_max 104857600 104857600
_bct_buffer_allocation_min_extents 1 1
_bct_buffer_allocation_size 2097152 2097152
_bct_chunk_size 0 0
_bct_crash_reserve_size 262144 262144
_bct_file_block_size 0 0
_bct_file_extent_size 0 0
_bct_fixtab_file
_bct_initial_private_dba_buffer_size 0 0
_bct_public_dba_buffer_size 0 0
_bitmap_or_improvement_enabled TRUE TRUE
_block_change_tracking TRUE TRUE
_blocks_per_cache_server 128 128
_bloom_filter_debug 0 0
_bloom_filter_enabled TRUE TRUE
_bt_mmv_query_rewrite_enabled TRUE TRUE
_buffer_busy_wait_timeout 100 100
_bufq_flow_control_thrsh 0 0
_bufq_max_msg_sz 0 0
_bufq_stop_flow_control FALSE FALSE
_build_deferred_mv_skipping_mvlog_update FALSE FALSE
_bump_highwater_mark_count 0 0
_bwr_for_flushed_pi TRUE TRUE
_cache_stats_monitor FALSE FALSE
_cgs_reconfig_timeout 120 120
_cgs_send_timeout 300 300
_check_block_after_checksum TRUE TRUE
_check_ts_threshold 0 0
_cleanup_rollback_entries 100 100
_close_cached_open_cursors FALSE FALSE
_cluster_library clss clss
_collapse_wait_history FALSE FALSE
_collect_undo_stats TRUE TRUE
_column_compression_factor 0 0
_column_elimination_off FALSE FALSE
_column_tracking_level 1 1
_compilation_call_heap_extent_size 16384 16384
_complex_view_merging TRUE TRUE
_controlfile_block_size 0 0
_controlfile_enqueue_dump FALSE FALSE
_controlfile_enqueue_timeout 900 900
_controlfile_section_init_size
_controlfile_section_max_expand
_controlfile_update_check OFF OFF
_convert_set_to_join FALSE FALSE
_coord_message_buffer 0 0
_corrupted_rollback_segments
_cost_equality_semi_join TRUE TRUE
_cpu_to_io 0 0
_cr_grant_global_role TRUE TRUE
_cr_grant_local_role AUTO AUTO
_cr_server_log_flush TRUE TRUE
_ctas_hwm_brokered_loads TRUE TRUE
_cursor_bind_capture_area_size 400 400
_cursor_bind_capture_interval 900 900
_cursor_cache_frame_bind_memory FALSE FALSE
_cursor_db_buffers_pinned 47 47
_cursor_features_enabled 2 2
_cursor_plan_enabled TRUE TRUE
_cursor_plan_hash_version 1 1
_cursor_plan_unparse_enabled TRUE TRUE
_cursor_stats_bucket 15 15
_cursor_stats_heap 4 4
_db_aging_cool_count 1 1
_db_aging_freeze_cr FALSE FALSE
_db_aging_hot_criteria 2 2
_db_aging_stay_count 0 0
_db_aging_touch_time 3 3
_db_always_check_system_ts TRUE TRUE
_db_block_adjcheck TRUE TRUE
_db_block_adjchk_level 77472512 77472512
_db_block_align_direct_read TRUE TRUE
_db_block_buffers 2495 2495
_db_block_cache_clone FALSE FALSE
_db_block_cache_history 0 0
_db_block_cache_history_level 2 2
_db_block_cache_num_umap 0 0
_db_block_cache_protect FALSE FALSE
_db_block_cache_protect_internal 0 0
_db_block_check_for_debug FALSE FALSE
_db_block_check_objtyp TRUE TRUE
_db_block_do_full_mbreads FALSE FALSE
_db_block_hash_buckets 8192 8192
_db_block_hash_latches 1024 1024
_db_block_hi_priority_batch_size 0 0
_db_block_known_clean_pct 2 2
_db_block_lru_latches 8 8
_db_block_max_cr_dba 6 6
_db_block_max_scan_pct 40 40
_db_block_med_priority_batch_size 0 0
_db_block_numa 1 1
_db_block_prefetch_limit 0 0
_db_block_prefetch_quota 10 10
_db_block_table_scan_buffer_size 4194304 4194304
_db_block_temp_redo FALSE FALSE
_db_block_trace_protect FALSE FALSE
_db_blocks_per_hash_latch
_db_cache_advice_batch_size 128 128
_db_cache_advice_sample_factor 4 4
_db_cache_crx_check FALSE FALSE
_db_cache_pre_warm TRUE TRUE
_db_cache_process_cr_pin_max
_db_change_notification_enable TRUE TRUE
_db_fast_obj_check FALSE FALSE
_db_fast_obj_ckpt TRUE TRUE
_db_fast_obj_truncate TRUE TRUE
_db_file_direct_io_count 1048576 1048576
_db_file_exec_read_count 16 16
_db_file_format_io_buffers 4 4
_db_file_noncontig_mblock_read_count 11 11
_db_file_optimizer_read_count 16 16
_db_handles 250 250
_db_handles_cached 5 5
_db_hot_block_tracking FALSE FALSE
_db_index_block_checking TRUE TRUE
_db_large_dirty_queue 25 25
_db_lost_write_checking FALSE FALSE
_db_mttr_advice ON ON
_db_mttr_partitions 0 0
_db_mttr_sample_factor 64 64
_db_mttr_sim_target
_db_mttr_sim_trace_size 256 256
_db_mttr_trace_to_alert FALSE FALSE
_db_obj_ckpt_ordered FALSE FALSE
_db_obj_enable_ksr TRUE TRUE
_db_percent_hot_default 50 50
_db_percent_hot_keep 0 0
_db_percent_hot_recycle 0 0
_db_percpu_create_cachesize 2 2
_db_recovery_temporal_file_dest
_db_row_overlap_checking TRUE TRUE
_db_todefer_cache_create TRUE TRUE
_db_writer_chunk_writes 0 0
_db_writer_coalesce_area_size 196608 196608
_db_writer_coalesce_write_limit 131072 131072
_db_writer_flush_imu TRUE TRUE
_db_writer_histogram_statistics FALSE FALSE
_db_writer_max_writes 0 0
_db_writer_verify_writes FALSE FALSE
_dbg_proc_startup FALSE FALSE
_dbwr_async_io TRUE TRUE
_dbwr_scan_interval 300 300
_dbwr_tracing 0 0
_dead_process_scan_interval 10 10
_debug_enable FALSE FALSE
_dedicated_server_poll_count 10 10
_dedicated_server_post_wait FALSE FALSE
_dedicated_server_post_wait_call FALSE FALSE
_default_encrypt_alg 0 0
_default_non_equality_sel_check TRUE TRUE
_delay_index_maintain TRUE TRUE
_diag_daemon TRUE TRUE
_diag_diagnostics TRUE TRUE
_diag_dump_timeout 30 30
_dimension_skip_null TRUE TRUE
_disable_adaptive_shrunk_aggregation FALSE FALSE
_disable_datalayer_sampling FALSE FALSE
_disable_duplex_link FALSE FALSE
_disable_fast_aggregation FALSE FALSE
_disable_file_locks FALSE FALSE
_disable_function_based_index FALSE FALSE
_disable_health_check FALSE FALSE
_disable_image_check FALSE FALSE
_disable_incremental_checkpoints FALSE FALSE
_disable_incremental_recovery_ckpt FALSE FALSE
_disable_instance_params_check FALSE FALSE
_disable_interface_checking FALSE FALSE
_disable_kcbhxor_osd FALSE FALSE
_disable_latch_free_SCN_writes_via_32cas FALSE FALSE
_disable_latch_free_SCN_writes_via_64cas FALSE FALSE
_disable_logging FALSE FALSE
_disable_multiple_block_sizes FALSE FALSE
_disable_ntlog_events FALSE FALSE
_disable_odm FALSE FALSE
_disable_recoverable_recovery FALSE FALSE
_disable_recovery_read_skip FALSE FALSE
_disable_sample_io_optim FALSE FALSE
_disable_savepoint_reset FALSE FALSE
_disable_selftune_checkpointing FALSE FALSE
_disable_streams_pool_auto_tuning FALSE FALSE
_disable_system_state 4294967294 4294967294
_disable_txn_alert 0 0
_discrete_transactions_enabled FALSE FALSE
_dispatcher_rate_scale
_dispatcher_rate_ttl
_distinct_view_unnesting FALSE FALSE
_distributed_recovery_connection_hold_time 200 200
_dlm_send_timeout 30000 30000
_dlmtrace
_dm_max_shared_pool_pct 1 1
_dml_monitoring_enabled TRUE TRUE
_domain_index_batch_size 2000 2000
_domain_index_dml_batch_size 200 200
_drop_table_granule 256 256
_drop_table_optimization_enabled TRUE TRUE
_ds_iocount_iosize 6553664 6553664
_dss_cache_flush FALSE FALSE
_dtree_area_size 131072 131072
_dtree_binning_enabled TRUE TRUE
_dtree_bintest_id 0 0
_dtree_compressbmp_enabled TRUE TRUE
_dtree_max_surrogates 1 1
_dtree_pruning_enabled TRUE TRUE
_dummy_instance FALSE FALSE
_dump_common_subexpressions FALSE FALSE
_dump_connect_by_loop_data FALSE FALSE
_dump_cursor_heap_sizes FALSE FALSE
_dump_interval_limit 120 120
_dump_max_limit 5 5
_dump_qbc_tree 0 0
_dump_rcvr_ipc TRUE TRUE
_dump_system_state_scope local local
_dump_trace_scope global global
_dynamic_rls_policies TRUE TRUE
_dynamic_stats_threshold 30 30
_eliminate_common_subexpr TRUE TRUE
_enable_NUMA_optimization TRUE TRUE
_enable_block_level_transaction_recovery TRUE TRUE
_enable_cscn_caching FALSE FALSE
_enable_default_affinity 0 0
_enable_dml_lock_escalation TRUE TRUE
_enable_exchange_validation_using_check TRUE TRUE
_enable_fast_ref_after_mv_tbs FALSE FALSE
_enable_hash_overflow FALSE FALSE
_enable_hwm_sync TRUE TRUE
_enable_list_io FALSE FALSE
_enable_nativenet_tcpip FALSE FALSE
_enable_refresh_schedule TRUE TRUE
_enable_reliable_latch_waits TRUE TRUE
_enable_rlb TRUE TRUE
_enable_row_shipping FALSE FALSE
_enable_shared_pool_durations TRUE TRUE
_enable_tablespace_alerts TRUE TRUE
_enable_type_dep_selectivity TRUE TRUE
_enqueue_deadlock_time_sec 5 5
_enqueue_debug_multi_instance FALSE FALSE
_enqueue_hash 155 155
_enqueue_hash_chain_latches 1 1
_enqueue_locks 960 960
_enqueue_resources 484 484
_expand_aggregates TRUE TRUE
_explain_rewrite_mode FALSE FALSE
_extended_pruning_enabled TRUE TRUE
_fair_remote_cvt FALSE FALSE
_fairness_threshold 4 4
_fast_dual_enabled TRUE TRUE
_fast_full_scan_enabled TRUE TRUE
_fast_start_instance_recovery_target 0 0
_fic_algorithm_set automatic automatic
_fic_area_size 131072 131072
_fic_max_length 20 20
_fic_min_bmsize 1024 1024
_fic_outofmem_candidates FALSE FALSE
_fifth_spare_parameter
_filemap_dir
_first_k_rows_dynamic_proration TRUE TRUE
_first_spare_parameter
_fix_control
_flashback_allow_noarchivelog FALSE FALSE
_flashback_barrier_interval 1800 1800
_flashback_copy_latches 10 10
_flashback_fuzzy_barrier TRUE TRUE
_flashback_generation_buffer_size 4194304 4194304
_flashback_hint_barrier_percent 20 20
_flashback_log_io_error_behavior 0 0
_flashback_log_min_size 100 100
_flashback_log_size 1000 1000
_flashback_logfile_enqueue_timeout 600 600
_flashback_max_log_size 0 0
_flashback_max_n_log_per_thread 2048 2048
_flashback_n_log_per_thread 128 128
_flashback_standby_barrier_interval 1800 1800
_flashback_verbose_info FALSE FALSE
_flashback_write_size_qm 4 4
_force_datefold_trunc FALSE FALSE
_force_rewrite_enable FALSE FALSE
_force_temptables_for_gsets FALSE FALSE
_fourth_spare_parameter
_full_pwise_join_enabled TRUE TRUE
_gby_hash_aggregation_enabled TRUE TRUE
_gby_onekey_enabled TRUE TRUE
_gc_affinity_limit 50 50
_gc_affinity_minimum 6000 6000
_gc_affinity_time 10 10
_gc_async_memcpy FALSE FALSE
_gc_check_bscn TRUE TRUE
_gc_coalesce_recovery_reads TRUE TRUE
_gc_defer_time 3 3
_gc_dissolve_undo_affinity FALSE FALSE
_gc_dynamic_affinity_locks TRUE TRUE
_gc_element_percent 103 103
_gc_global_lru AUTO AUTO
_gc_initiate_undo_affinity TRUE TRUE
_gc_integrity_checks 1 1
_gc_keep_recovery_buffers TRUE TRUE
_gc_latches 8 8
_gc_maximum_bids 0 0
_gc_statistics TRUE TRUE
_gc_undo_affinity TRUE TRUE
_gc_undo_affinity_locks TRUE TRUE
_gc_use_cr TRUE TRUE
_gc_vector_read TRUE TRUE
_gcs_fast_reconfig TRUE TRUE
_gcs_latches 0 0
_gcs_process_in_recovery TRUE TRUE
_gcs_resources
_gcs_shadow_locks
_gcs_testing 0 0
_generalized_pruning_enabled TRUE TRUE
_ges_dd_debug 1 1
_ges_diagnostics TRUE TRUE
_ges_health_check 1 1
_globalindex_pnum_filter_enabled TRUE TRUE
_groupby_nopushdown_cut_ratio 3 3
_groupby_orderby_combine 5000 5000
_gs_anti_semi_join_allowed TRUE TRUE
_hang_analysis_num_call_stacks 3 3
_hang_detection 0 0
_hard_protection FALSE FALSE
_hash_join_enabled TRUE TRUE
_hash_multiblock_io_count 0 0
_high_priority_processes LMS* LMS*
_high_server_threshold 0 0
_hj_bit_filter_threshold 50 50
_hwm_sync_threshold 10 10
_idl_conventional_index_maintenance TRUE TRUE
_idxrb_rowincr 100000000 100000000
_ignore_desc_in_index FALSE FALSE
_immediate_commit_propagation TRUE TRUE
_improved_outerjoin_card TRUE TRUE
_improved_row_length_enabled TRUE TRUE
_imr_active TRUE TRUE
_imr_disk_voting_interval 3 3
_imr_max_reconfig_delay 300 300
_imr_splitbrain_res_wait 600 600
_imr_systemload_check TRUE TRUE
_imu_pools 3 3
_in_memory_undo TRUE TRUE
_incremental_recovery_ckpt_min_batch 30 30
_index_join_enabled TRUE TRUE
_index_prefetch_factor 100 100
_init_granule_interval 10 10
_init_sql_file %ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ %ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ
_inject_startup_fault 0 0
_inline_sql_in_plsql FALSE FALSE
_insert_enable_hwm_brokered TRUE TRUE
_inst_locking_period 5 5
_interconnect_checksum TRUE TRUE
_intrapart_pdml_enabled TRUE TRUE
_intrapart_pdml_randomlocal_enabled TRUE TRUE
_io_shared_pool_size 4194304 4194304
_io_slaves_disabled FALSE FALSE
_ior_serialize_fault 0 0
_ioslave_batch_count 1 1
_ioslave_issue_count 500 500
_job_queue_interval 5 5
_kcl_commit TRUE TRUE
_kcl_conservative_log_flush FALSE FALSE
_kcl_debug TRUE TRUE
_kcl_index_split TRUE TRUE
_kcl_undo_grouping 32 32
_kcl_undo_locks 128 128
_kdbl_enable_post_allocation FALSE FALSE
_keep_remote_column_size FALSE FALSE
_kernel_message_network_driver FALSE FALSE
_kffmap_hash_size 1024 1024
_kffmop_hash_size 2048 2048
_kghdsidx_count 1 1
_kgl_bucket_count 9 9
_kgl_fixed_extents TRUE TRUE
_kgl_hash_collision FALSE FALSE
_kgl_heap_size 1024 1024
_kgl_keep_cache_pct 30 30
_kgl_keep_cache_retain_pct 20 20
_kgl_large_heap_warning_threshold 52428800 52428800
_kgl_latch_count 0 0
_kgl_multi_instance_invalidation TRUE TRUE
_kgl_multi_instance_lock TRUE TRUE
_kgl_multi_instance_pin TRUE TRUE
_kgl_session_cached_objects 10 10
_kgl_time_to_wait_for_locks 15 15
_kglsim_maxmem_percent 5 5
_kgx_latches 512 512
_kill_controlfile_enqueue_blocker TRUE TRUE
_kill_enqueue_blocker 1 1
_kill_java_threads_on_eoc FALSE FALSE
_kkfi_trace FALSE FALSE
_kks_free_cursor_stat_pct 10 10
_kks_use_mutex_pin TRUE TRUE
_kolfuseslf FALSE FALSE
_kql_subheap_trace 0 0
_ksb_disable_diagpid FALSE FALSE
_ksd_test_param 999 999
_ksdxdocmd_default_timeout_ms 30000 30000
_ksdxw_cini_flg 0 0
_ksdxw_nbufs 1000 1000
_ksdxw_num_pgw 10 10
_ksdxw_num_sgw 10 10
_ksdxw_stack_depth 4 4
_kse_die_timeout 60000 60000
_kse_pc_table_size 256 256
_ksfd_verify_write FALSE FALSE
_ksi_trace
_ksmg_granule_locking_status 1 1
_ksmg_granule_size 4194304 4194304
_ksmg_lock_check_interval
_ksmg_lock_reacquire_count 5 5
_ksu_diag_kill_time 5 5
_ksuitm_dont_kill_dumper FALSE FALSE
_ksxp_diagmode OFF OFF
_ksxp_reporting_process LMD0 LMD0
_ksxp_send_timeout 300 300
_ktc_debug 0 0
_ktc_latches 0 0
_ktu_latches 0 0
_ku_trace none none
_large_pool_min_alloc 16000 16000
_last_allocation_period 5 5
_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
_latch_miss_stat_sid 0 0
_latch_recovery_alignment 998 998
_ldr_io_size 262144 262144
_left_nested_loops_random TRUE TRUE
_lgwr_async_broadcasts TRUE TRUE
_lgwr_async_io FALSE FALSE
_lgwr_delay_write FALSE FALSE
_lgwr_io_slaves 0 0
_lgwr_max_ns_wt 1 1
_lgwr_ns_nl_max 1000 1000
_lgwr_ns_nl_min 500 500
_lgwr_ns_sim_err 0 0
_lgwr_ta_sim_err 0 0
_library_cache_advice TRUE TRUE
_lightweight_hdrs TRUE TRUE
_like_with_bind_as_equality FALSE FALSE
_lm_activate_lms_threshold 100 100
_lm_cache_lvl0_cleanup 0 0
_lm_cache_res_cleanup 25 25
_lm_cache_res_type TMHWDI TMHWDI
_lm_checksum_batch_msg FALSE FALSE
_lm_contiguous_res_count 128 128
_lm_dd_interval 60 60
_lm_dd_scan_interval 5 5
_lm_drm_max_requests 100 100
_lm_drm_window 0 0
_lm_drm_xlatch 0 0
_lm_dynamic_lms FALSE FALSE
_lm_dynamic_load TRUE TRUE
_lm_dynamic_remastering FALSE FALSE
_lm_enq_lock_freelist
_lm_enq_rcfg TRUE TRUE
_lm_enqueue_freelist 3 3
_lm_file_affinity
_lm_global_posts TRUE TRUE
_lm_lmd_waittime 8 8
_lm_lms 0 0
_lm_lms_waittime 8 8
_lm_locks 12000 12000
_lm_master_weight 1 1
_lm_max_lms 0 0
_lm_min_lms 0 0
_lm_msg_batch_size 0 0
_lm_msg_cache_thresholds
_lm_msg_cleanup_interval 3000 3000
_lm_node_join_opt FALSE FALSE
_lm_non_fault_tolerant FALSE FALSE
_lm_num_pcmhv_latches 0 0
_lm_num_pt_buckets 4096 4096
_lm_num_pt_latches 128 128
_lm_proc_freeze_timeout 300 300
_lm_process_batching TRUE TRUE
_lm_procs 320 320
_lm_rcfg_timeout 180000 180000
_lm_rcv_buffer_size 32768 32768
_lm_res_hash_bucket 0 0
_lm_res_part 128 128
_lm_ress 6000 6000
_lm_send_buffers 10000 10000
_lm_send_mode auto auto
_lm_send_queue_batching TRUE TRUE
_lm_send_queue_length 5000 5000
_lm_sendproxy_reserve 25 25
_lm_share_lock_opt FALSE FALSE
_lm_sq_batch_factor 2 2
_lm_sq_batch_type auto auto
_lm_sq_batch_waittick 3 3
_lm_sync_timeout
_lm_ticket_active_sendback
_lm_tickets 1000 1000
_lm_tx_delta 16 16
_lm_validate_resource_type FALSE FALSE
_lm_xids 352 352
_load_without_compile none none
_local_communication_costing_enabled TRUE TRUE
_local_communication_ratio 50 50
_lock_sga_areas 0 0
_log_archive_avoid_memcpy TRUE TRUE
_log_archive_buffer_size 2048 2048
_log_archive_buffers 4 4
_log_archive_callout
_log_archive_compress_enable FALSE FALSE
_log_archive_delta_sync_wait 0 0
_log_archive_net_timeout 0 0
_log_archive_network_redo_size 10 10
_log_archive_prot_auto_demote FALSE FALSE
_log_archive_security_enabled TRUE TRUE
_log_blocks_during_backup TRUE TRUE
_log_buffers_corrupt FALSE FALSE
_log_buffers_debug FALSE FALSE
_log_checkpoint_recovery_check 0 0
_log_committime_block_cleanout FALSE FALSE
_log_debug_multi_instance FALSE FALSE
_log_deletion_policy mandatory mandatory
_log_event_queues 0 0
_log_io_size 0 0
_log_parallelism 1 1
_log_parallelism_dynamic TRUE TRUE
_log_parallelism_max 1 1
_log_private_mul 5 5
_log_private_parallelism FALSE FALSE
_log_private_parallelism_mul 10 10
_log_simultaneous_copies 2 2
_log_space_errors TRUE TRUE
_log_switch_timeout 0 0
_logout_storm_rate 0 0
_logout_storm_retrycnt 600 600
_logout_storm_timeout 5 5
_longops_enabled TRUE TRUE
_low_server_threshold 0 0
_master_direct_sends 31 31
_mav_refresh_consistent_read TRUE TRUE
_mav_refresh_double_count_prevented FALSE FALSE
_mav_refresh_opt 0 0
_mav_refresh_unionall_tables 3 3
_max_arch_lns_wait 120 120
_max_exponential_sleep 0 0
_max_lns_shutdown_archival_time 30 30
_max_protocol_support 10000 10000
_max_rfs_connections 0 0
_max_shrink_obj_stats 0 0
_max_sleep_holding_latch 4 4
_media_recovery_read_batch 128 128
_media_recovery_reap_time 3 3
_mem_annotation_pr_lev 0 0
_mem_annotation_scale 1 1
_mem_annotation_sh_lev 0 0
_mem_annotation_store FALSE FALSE
_mem_std_extent_size 4096 4096
_memory_broker_log_stat_entries 5 5
_memory_broker_marginal_utility_bc 10 10
_memory_broker_marginal_utility_sp 4 4
_memory_broker_shrink_heaps 15 15
_memory_broker_shrink_java_heaps 900 900
_memory_broker_shrink_streams_pool 900 900
_memory_broker_shrink_timeout 60000000 60000000
_memory_broker_stat_interval 30 30
_memory_management_tracing 0 0
_memory_sanity_check 0 0
_messages 100 100
_minfree_plus 0 0
_minimal_stats_aggregation TRUE TRUE
_minimum_blocks_to_shrink 0 0
_minimum_extents_to_shrink 1 1
_minimum_giga_scn 0 0
_mirror_redo_buffers FALSE FALSE
_mmv_query_rewrite_enabled TRUE TRUE
_multi_join_key_table_lookup TRUE TRUE
_multiple_instance_recovery FALSE FALSE
_mv_refresh_ana 0 0
_mv_refresh_costing rule rule
_mv_refresh_delta_fraction 10 10
_mv_refresh_eut TRUE TRUE
_mv_refresh_force_parallel_query 0 0
_mv_refresh_new_setup_disabled FALSE FALSE
_mv_refresh_rebuild_percentage 10 10
_mv_refresh_selections TRUE TRUE
_mv_refresh_use_stats FALSE FALSE
_mv_refsched_timeincr 300000 300000
_mv_rolling_inv FALSE FALSE
_mwin_schedule TRUE TRUE
_nchar_imp_cnv TRUE TRUE
_nchar_imp_conv TRUE TRUE
_ncmb_readahead_enabled 0 0
_ncmb_readahead_tracing 0 0
_nested_loop_fudge 100 100
_nested_mav_fast_oncommit_enabled TRUE TRUE
_new_initial_join_orders TRUE TRUE
_new_sort_cost_estimate TRUE TRUE
_newsort_enabled TRUE TRUE
_newsort_ordered_pct 63 63
_newsort_type 0 0
_no_objects FALSE FALSE
_no_or_expansion FALSE FALSE
_no_recovery_through_resetlogs FALSE FALSE
_notify_crs FALSE FALSE
_ns_max_flush_wt 1 1
_ns_max_send_delay 15 15
_num_longop_child_latches 1 1
_number_cached_attributes 10 10
_object_statistics TRUE TRUE
_offline_rollback_segments
_ogms_home
_olap_aggregate_buffer_size 1048576 1048576
_olap_aggregate_flags 0 0
_olap_aggregate_function_cache_enabled TRUE TRUE
_olap_aggregate_function_merge_threshold 529 529
_olap_aggregate_max_thread_tuples 5000 5000
_olap_aggregate_min_buffer_size 1024 1024
_olap_aggregate_min_thread_status 64 64
_olap_aggregate_multipath_hier FALSE FALSE
_olap_aggregate_statlen_thresh 1024 1024
_olap_aggregate_store_probability 100 100
_olap_aggregate_work_per_thread 1024 1024
_olap_aggregate_worklist_max 5000 5000
_olap_allocate_errorlog_format %8p %8y %8z %e (%n) %8p %8y %8z %e (%n)
_olap_allocate_errorlog_header Dim Source Basis %-8d %-8s %-8b Description -- -- -- - -—- Dim Source Basis
_olap_continuous_trace_file FALSE FALSE
_olap_dbgoutfile_echo_to_eventlog FALSE FALSE
_olap_dimension_corehash_class 1 1
_olap_dimension_corehash_max 10000 10000
_olap_eif_export_lob_size 2147483647 2147483647
_olap_lmgen_dim_size 100 100
_olap_lmgen_meas_size 1000 1000
_olap_object_hash_class 2 2
_olap_page_pool_expand_rate 20 20
_olap_page_pool_hi 50 50
_olap_page_pool_hit_target 100 100
_olap_page_pool_low 262144 262144
_olap_page_pool_pressure 90 90
_olap_page_pool_shrink_rate 50 50
_olap_parallel_update_small_group 400 400
_olap_parallel_update_small_threshold 1000 1000
_olap_parallel_update_threshold 1000 1000
_olap_poutlog_echo_to_eventlog FALSE FALSE
_olap_sesscache_enabled TRUE TRUE
_olap_sort_buffer_size 262144 262144
_olap_statbool_corebits 20000000 20000000
_olap_statbool_threshold 8100 8100
_olap_table_function_statistics FALSE FALSE
_olap_wrap_errors FALSE FALSE
_olapi_history_retention FALSE FALSE
_olapi_iface_object_history 1000 1000
_olapi_iface_object_history_retention FALSE FALSE
_olapi_iface_operation_history_retention FALSE FALSE
_olapi_interface_operation_history 1000 1000
_olapi_memory_operation_history 1000 1000
_olapi_memory_operation_history_pause_at_seqno 0 0
_olapi_memory_operation_history_retention FALSE FALSE
_olapi_session_history 300 300
_olapi_session_history_retention FALSE FALSE
_old_connect_by_enabled FALSE FALSE
_ols_cleanup_task TRUE TRUE
_omf enabled enabled
_oneside_colstat_for_equijoins TRUE TRUE
_optim_adjust_for_part_skews TRUE TRUE
_optim_dict_stats_at_db_cr_upg TRUE TRUE
_optim_enhance_nnull_detection TRUE TRUE
_optim_new_default_join_sel TRUE TRUE
_optim_peek_user_binds TRUE TRUE
_optimizer_adjust_for_nulls TRUE TRUE
_optimizer_autostats_job TRUE TRUE
_optimizer_better_inlist_costing ALL ALL
_optimizer_block_size 8192 8192
_optimizer_cache_stats FALSE FALSE
_optimizer_cartesian_enabled TRUE TRUE
_optimizer_cbqt_factor 50 50
_optimizer_cbqt_no_size_restriction TRUE TRUE
_optimizer_ceil_cost TRUE TRUE
_optimizer_choose_permutation 0 0
_optimizer_complex_pred_selectivity TRUE TRUE
_optimizer_compute_index_stats TRUE TRUE
_optimizer_connect_by_cost_based TRUE TRUE
_optimizer_correct_sq_selectivity TRUE TRUE
_optimizer_cost_based_transformation LINEAR LINEAR
_optimizer_cost_filter_pred FALSE FALSE
_optimizer_cost_hjsmj_multimatch TRUE TRUE
_optimizer_cost_model CHOOSE CHOOSE
_optimizer_degree 0 0
_optimizer_dim_subq_join_sel TRUE TRUE
_optimizer_disable_strans_sanity_checks 0 0
_optimizer_dyn_smp_blks 32 32
_optimizer_enhanced_filter_push TRUE TRUE
_optimizer_extended_cursor_sharing UDO UDO
_optimizer_filter_pred_pullup TRUE TRUE
_optimizer_ignore_hints FALSE FALSE
_optimizer_invalidation_period 18000 18000
_optimizer_join_elimination_enabled TRUE TRUE
_optimizer_join_order_control 3 3
_optimizer_join_sel_sanity_check TRUE TRUE
_optimizer_max_permutations 2000 2000
_optimizer_min_cache_blocks 10 10
_optimizer_mjc_enabled TRUE TRUE
_optimizer_mode_force TRUE TRUE
_optimizer_multiple_cenv
_optimizer_native_full_outer_join off off
_optimizer_new_join_card_computation TRUE TRUE
_optimizer_or_expansion DEPTH DEPTH
_optimizer_order_by_elimination_enabled TRUE TRUE
_optimizer_outer_to_anti_enabled TRUE TRUE
_optimizer_percent_parallel 101 101
_optimizer_push_down_distinct 0 0
_optimizer_push_pred_cost_based TRUE TRUE
_optimizer_random_plan 0 0
_optimizer_rownum_bind_default 10 10
_optimizer_rownum_pred_based_fkr TRUE TRUE
_optimizer_save_stats TRUE TRUE
_optimizer_search_limit 5 5
_optimizer_self_induced_cache_cost FALSE FALSE
_optimizer_skip_scan_enabled TRUE TRUE
_optimizer_skip_scan_guess FALSE FALSE
_optimizer_sortmerge_join_enabled TRUE TRUE
_optimizer_squ_bottomup TRUE TRUE
_optimizer_star_tran_in_with_clause TRUE TRUE
_optimizer_starplan_enabled TRUE TRUE
_optimizer_system_stats_usage TRUE TRUE
_optimizer_trace none none
_optimizer_transitivity_retain TRUE TRUE
_optimizer_undo_changes FALSE FALSE
_optimizer_undo_cost_change 10.2.0.3 10.2.0.3
_or_expand_nvl_predicate TRUE TRUE
_oradebug_force FALSE FALSE
_ordered_nested_loop TRUE TRUE
_ordered_semijoin TRUE TRUE
_os_sched_high_priority 1 1
_other_wait_event_exclusion
_other_wait_threshold 0 0
_outline_bitmap_tree TRUE TRUE
_parallel_adaptive_max_users 2 2
_parallel_broadcast_enabled TRUE TRUE
_parallel_default_max_instances 1 1
_parallel_execution_message_align FALSE FALSE
_parallel_fake_class_pct 0 0
_parallel_fixwrite_bucket 1000 1000
_parallel_load_bal_unit 0 0
_parallel_load_balancing TRUE TRUE
_parallel_min_message_pool 206208 206208
_parallel_recovery_stopat 32767 32767
_parallel_replay_msg_limit 4000 4000
_parallel_server_idle_time 30000 30000
_parallel_server_sleep_time 10 10
_parallel_slave_acquisition_wait 1 1
_parallel_txn_global FALSE FALSE
_parallelism_cost_fudge_factor 350 350
_parameter_table_block_size 1024 1024
_partial_pwise_join_enabled TRUE TRUE
_partition_view_enabled TRUE TRUE
_passwordfile_enqueue_timeout 900 900
_pct_refresh_double_count_prevented TRUE TRUE
_pdml_gim_sampling 5000 5000
_pdml_gim_staggered FALSE FALSE
_pdml_slaves_diff_part TRUE TRUE
_percent_flashback_buf_partial_full 50 50
_pga_large_extent_size 1048576 1048576
_pga_max_size 209715200 209715200
_ping_level 3 3
_pkt_enable FALSE FALSE
_pkt_pmon_interval 50 50
_pkt_start FALSE FALSE
_plan_outline_data TRUE TRUE
_plsql_anon_block_code_type INTERPRETED INTERPRETED
_plsql_cache_enable TRUE TRUE
_plsql_dump_buffer_events
_plsql_minimum_cache_hit_percent 20 20
_plsql_nvl_optimize FALSE FALSE
_pmon_load_constants 300,192,64,3,10,10,0,0 300,192,64,3,10,10,0,0
_pre_rewrite_push_pred TRUE TRUE
_precompute_gid_values TRUE TRUE
_pred_move_around TRUE TRUE
_predicate_elimination_enabled TRUE TRUE
_prescomm FALSE FALSE
_print_refresh_schedule FALSE FALSE
_private_memory_address
_project_view_columns TRUE TRUE
_projection_pushdown TRUE TRUE
_projection_pushdown_debug 0 0
_push_join_predicate TRUE TRUE
_push_join_union_view TRUE TRUE
_push_join_union_view2 TRUE TRUE
_px_async_getgranule FALSE FALSE
_px_broadcast_fudge_factor 100 100
_px_buffer_ttl 30 30
_px_compilation_debug 0 0
_px_compilation_trace 0 0
_px_dynamic_opt TRUE TRUE
_px_dynamic_sample_size 50 50
_px_granule_size 100000 100000
_px_index_sampling 200 200
_px_kxib_tracing 0 0
_px_load_publish_interval 200 200
_px_loc_msg_cost 1000 1000
_px_max_granules_per_slave 100 100
_px_min_granules_per_slave 13 13
_px_minus_intersect TRUE TRUE
_px_net_msg_cost 10000 10000
_px_no_granule_sort FALSE FALSE
_px_no_stealing FALSE FALSE
_px_nss_planb TRUE TRUE
_px_proc_constrain TRUE TRUE
_px_pwg_enabled TRUE TRUE
_px_rownum_pd TRUE TRUE
_px_send_timeout 300 300
_px_slaves_share_cursors 0 0
_px_trace none none
_px_xtgranule_size 10000 10000
_qa_control 0 0
_qa_lrg_type 0 0
_query_cost_rewrite TRUE TRUE
_query_execution_cache_max_size 65536 65536
_query_rewrite_1 TRUE TRUE
_query_rewrite_2 TRUE TRUE
_query_rewrite_drj TRUE TRUE
_query_rewrite_expression TRUE TRUE
_query_rewrite_fpc TRUE TRUE
_query_rewrite_fudge 90 90
_query_rewrite_jgmigrate TRUE TRUE
_query_rewrite_maxdisjunct 257 257
_query_rewrite_or_error FALSE FALSE
_query_rewrite_setopgrw_enable TRUE TRUE
_query_rewrite_vop_cleanup TRUE TRUE
_rcfg_parallel_fixwrite TRUE TRUE
_rcfg_parallel_replay TRUE TRUE
_rcfg_parallel_verify TRUE TRUE
_real_time_apply_arch_delay 0 0
_real_time_apply_sim 0 0
_realfree_heap_max_size 32768 32768
_realfree_heap_mode 0 0
_realfree_heap_pagesize_hint 65536 65536
_recoverable_recovery_batch_percent 50 50
_recovery_asserts FALSE FALSE
_recovery_percentage 50 50
_recovery_verify_writes FALSE FALSE
_recursive_imu_transactions FALSE FALSE
_redo_compatibility_check FALSE FALSE
_release_insert_threshold 5 5
_reliable_block_sends FALSE FALSE
_remove_aggr_subquery TRUE TRUE
_resource_manager_always_on TRUE TRUE
_restore_spfile
_reuse_index_loop 5 5
_right_outer_hash_enable TRUE TRUE
_rman_io_priority 3 3
_rollback_segment_count 0 0
_rollback_segment_initial 1 1
_rollback_stopat 0 0
_row_cache_cursors 20 20
_row_cr TRUE TRUE
_row_locking always always
_row_shipping_explain FALSE FALSE
_row_shipping_threshold 80 80
_rowsource_execution_statistics FALSE FALSE
_rowsource_statistics_sampfreq 128 128
_rowsrc_trace_level 0 0
_sample_rows_per_block 4 4
_second_spare_parameter
_selfjoin_mv_duplicates TRUE TRUE
_selftune_checkpoint_write_pct 3 3
_selftune_checkpointing_lag 300 300
_send_ast_to_foreground TRUE TRUE
_send_close_with_block TRUE TRUE
_send_requests_to_pi TRUE TRUE
_serial_direct_read FALSE FALSE
_serial_recovery FALSE FALSE
_serializable FALSE FALSE
_session_cached_instantiations 60 60
_session_context_size 10000 10000
_session_idle_bit_latches 0 0
_session_idle_check_interval 60 60
_session_kept_cursor_pins 0 0
_session_wait_history 10 10
_seventh_spare_parameter
_shared_pool_max_size 0 0
_shared_pool_minsize_on FALSE FALSE
_shared_pool_reserved_min_alloc 4400 4400
_shared_pool_reserved_pct 5 5
_shared_server_spare_param1
_shared_server_spare_param2
_shared_server_spare_param3
_short_stack_timeout_ms 30000 30000
_shrunk_aggs_disable_threshold 60 60
_shrunk_aggs_enabled TRUE TRUE
_side_channel_batch_size 200 200
_side_channel_batch_timeout 6 6
_simple_view_merging TRUE TRUE
_simulator_bucket_mindelta 8192 8192
_simulator_internal_bound 10 10
_simulator_lru_rebalance_sizthr 2 2
_simulator_lru_rebalance_thresh 10240 10240
_simulator_lru_scan_count 8 8
_simulator_pin_inval_maxcnt 16 16
_simulator_reserved_heap_count 4096 4096
_simulator_reserved_obj_count 1024 1024
_simulator_sampling_factor 2 2
_simulator_upper_bound_multiple 2 2
_single_process FALSE FALSE
_sixth_spare_parameter
_skgxp_reaping 1000 1000
_skgxp_udp_ach_reaping_time 0 0
_skgxp_udp_hiwat_warn 1000 1000
_skgxp_udp_interface_detection_time_secs 60 60
_skgxp_udp_keep_alive_ping_timer_secs 300 300
_skgxp_udp_timed_wait_buffering 1024 1024
_skgxp_udp_timed_wait_seconds 5 5
_skip_assume_msg TRUE TRUE
_slave_mapping_enabled TRUE TRUE
_slave_mapping_group_size 0 0
_small_table_threshold 49 49
_smm_advice_enabled TRUE TRUE
_smm_advice_log_size 0 0
_smm_auto_cost_enabled TRUE TRUE
_smm_auto_max_io_size 248 248
_smm_auto_min_io_size 56 56
_smm_bound 0 0
_smm_control 0 0
_smm_freeable_retain 5120 5120
_smm_isort_cap 102400 102400
_smm_max_size 3276 3276
_smm_min_size 128 128
_smm_px_max_size 8192 8192
_smm_retain_size 0 0
_smm_trace 0 0
_smon_internal_errlimit 100 100
_smu_debug_mode 0 0
_smu_error_simulation_site 0 0
_smu_error_simulation_type 0 0
_smu_timeouts
_sort_elimination_cost_ratio 0 0
_sort_multiblock_read_count 2 2
_spin_count 1 1
_spr_max_rules 10000 10000
_spr_push_pred_refspr TRUE TRUE
_spr_use_AW_AS TRUE TRUE
_spr_use_hash_table FALSE FALSE
_sql_connect_capability_override 0 0
_sql_connect_capability_table
_sql_hash_debug 0 0
_sql_model_unfold_forloops RUN_TIME RUN_TIME
_sqlexec_progression_cost 1000 1000
_sqltune_category_parsed DEFAULT DEFAULT
_sta_control 0 0
_stack_guard_level 0 0
_static_backgrounds
_stn_trace 0 0
_streams_pool_max_size 0 0
_subquery_pruning_cost_factor 20 20
_subquery_pruning_enabled TRUE TRUE
_subquery_pruning_mv_enabled FALSE FALSE
_subquery_pruning_reduction 50 50
_swrf_metric_frequent_mode FALSE FALSE
_swrf_mmon_dbfus TRUE TRUE
_swrf_mmon_flush TRUE TRUE
_swrf_mmon_metrics TRUE TRUE
_swrf_on_disk_enabled TRUE TRUE
_swrf_test_action 0 0
_swrf_test_dbfus FALSE FALSE
_synonym_repoint_tracing FALSE FALSE
_sysaux_test_param 1 1
_system_index_caching 0 0
_system_trig_enabled TRUE TRUE
_ta_lns_wait_for_arch_log 20 20
_table_lookup_prefetch_size 40 40
_table_lookup_prefetch_thresh 2 2
_table_scan_cost_plus_one TRUE TRUE
_target_rba_max_lag_percentage 90 90
_tdb_debug_mode 16 16
_temp_tran_block_threshold 100 100
_temp_tran_cache TRUE TRUE
_test_ksusigskip 5 5
_test_param_1 25 25
_test_param_2
_test_param_3
_test_param_4
_test_param_5 25 25
_test_param_6 0 0
_third_spare_parameter
_threshold_alerts_enable 1 1
_total_large_extent_memory 0 0
_tq_dump_period 0 0
_trace_archive FALSE FALSE
_trace_buffer_flushes FALSE FALSE
_trace_buffer_gets FALSE FALSE
_trace_buffer_wait_timeouts 0 0
_trace_buffer_wrap_timestamp TRUE TRUE
_trace_buffers ALL:256 ALL:256
_trace_cr_buffer_creates FALSE FALSE
_trace_events
_trace_file_size 65536 65536
_trace_files_public FALSE FALSE
_trace_flush_processes ALL ALL
_trace_multi_block_reads FALSE FALSE
_trace_navigation_scope global global
_trace_options text,multiple text,multiple
_trace_pin_time 0 0
_trace_processes ALL ALL
_transaction_auditing TRUE TRUE
_transaction_recovery_servers 0 0
_truncate_optimization_enabled TRUE TRUE
_tsm_connect_string
_tsm_disable_auto_cleanup 1 1
_tts_allow_charset_mismatch FALSE FALSE
_two_pass TRUE TRUE
_two_pass_reverse_polish_enabled TRUE TRUE
_uga_cga_large_extent_size 262144 262144
_ultrafast_latch_statistics TRUE TRUE
_undo_autotune TRUE TRUE
_undo_debug_mode 0 0
_undo_debug_usage 0 0
_union_rewrite_for_gs YES_GSET_MVS YES_GSET_MVS
_unnest_subquery TRUE TRUE
_unused_block_compression TRUE TRUE
_use_column_stats_for_function TRUE TRUE
_use_ism TRUE TRUE
_use_ism_for_pga TRUE TRUE
_use_nosegment_indexes FALSE FALSE
_use_realfree_heap TRUE TRUE
_use_seq_process_cache TRUE TRUE
_use_vector_post TRUE TRUE
_validate_flashback_database FALSE FALSE
_vendor_lib_loc
_verify_flashback_redo TRUE TRUE
_verify_undo_quota FALSE FALSE
_very_large_partitioned_table 1024 1024
_wait_for_sync TRUE TRUE
_walk_insert_threshold 0 0
_watchpoint_on FALSE FALSE
_windowfunc_optimization_settings 0 0
_write_clones 3 3
_xpl_peeked_binds_log_size 8192 8192
_xpl_trace 0 0
_xsolapi_auto_materialization_bound 20 20
_xsolapi_auto_materialization_type PRED_AND_RC PRED_AND_RC
_xsolapi_debug_output
_xsolapi_densify_cubes TABULAR TABULAR
_xsolapi_dimension_group_creation OVERFETCH OVERFETCH
_xsolapi_fetch_type PARTIAL PARTIAL
_xsolapi_generate_with_clause FALSE FALSE
_xsolapi_hierarchy_value_type unique unique
_xsolapi_load_at_process_start NEVER NEVER
_xsolapi_materialization_rowcache_min_rows_for_use 1 1
_xsolapi_materialize_sources TRUE TRUE
_xsolapi_metadata_reader_mode ALL ALL
_xsolapi_odbo_mode FALSE FALSE
_xsolapi_optimize_suppression TRUE TRUE
_xsolapi_precompute_subquery TRUE TRUE
_xsolapi_remove_columns_for_materialization TRUE TRUE
_xsolapi_set_nls TRUE TRUE
_xsolapi_share_executors TRUE TRUE
_xsolapi_source_trace FALSE FALSE
_xsolapi_sql_all_multi_join_non_base_hints
_xsolapi_sql_all_non_base_hints
_xsolapi_sql_auto_dimension_hints FALSE FALSE
_xsolapi_sql_auto_measure_hints TRUE TRUE
_xsolapi_sql_dimension_hints
_xsolapi_sql_enable_aw_join TRUE TRUE
_xsolapi_sql_enable_aw_qdr_merge TRUE TRUE
_xsolapi_sql_hints
_xsolapi_sql_measure_hints
_xsolapi_sql_minus_threshold 1000 1000
_xsolapi_sql_optimize TRUE TRUE
_xsolapi_sql_prepare_stmt_cache_size 16 16
_xsolapi_sql_remove_columns TRUE TRUE
_xsolapi_sql_result_set_cache_size 32 32
_xsolapi_sql_symmetric_predicate TRUE TRUE
_xsolapi_sql_top_dimension_hints
_xsolapi_sql_top_measure_hints
_xsolapi_sql_use_bind_variables TRUE TRUE
_xsolapi_stringify_order_levels FALSE FALSE
_xsolapi_suppression_aw_mask_threshold 1000 1000
_xsolapi_suppression_chunk_size 4000 4000
_xsolapi_use_models TRUE TRUE
_xsolapi_use_olap_dml TRUE TRUE
_xsolapi_use_olap_dml_for_rank FALSE FALSE
_xt_coverage none none
_xt_trace none none
_xtbuffer_size 0 0
_xtts_allow_pre10 FALSE FALSE
_xtts_set_platform_info FALSE FALSE
_yield_check_interval 100000 100000 
SQL> column name format a50
SQL> column sesvalue format a30
SQL> column value format a30
SQL> select a.ksppinm  "name", b.ksppstvl "sesvalue", c.ksppstvl "value"
  2    from x$ksppi a, x$ksppcv b, x$ksppsv c
  3   where a.indx = b.indx and a.indx = c.indx
  4     and substr(ksppinm,1,1)='_'
  5  order by a.ksppinm;