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;