Oracle 11g Hidden Database Parameters
=============================
[oracle@dev ~]$ sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 16 13:17:48 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL> SET PAGESIZE 60
SET LINESIZE 300
COLUMN ksppinm FORMAT A50
COLUMN ksppstvl FORMAT A50
SELECT
ksppinm,
ksppstvl
FROM
x$ksppi a,
x$ksppsv b
WHERE a.indx=b.indx AND substr(ksppinm,1,1) = '_'
ORDER BY ksppinm;
/
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_4030_dump_bitvec 4095
_4031_dump_bitvec 67194879
_4031_dump_interval 300
_4031_max_dumps 100
_4031_sga_dump_interval 3600
_4031_sga_max_dumps 10
_NUMA_instance_mapping Not specified
_NUMA_pool_size Not specified
_PX_use_large_pool FALSE
__db_cache_size 1526726656
__dg_broker_service_names
__java_pool_size 16777216
__large_pool_size 100663296
__oracle_base /u01/app/oracle
__pga_aggregate_target 2248146944
__sga_target 4194304000
__shared_io_pool_size 0
__shared_pool_size 2499805184
__streams_pool_size 0
_abort_recovery_on_join FALSE
_accept_versions
_active_instance_count
_active_session_idle_limit 5
_active_session_legacy_behavior FALSE
_active_standby_fast_reconfiguration TRUE
_adaptive_direct_read TRUE
_adaptive_direct_write TRUE
_adaptive_fetch_enabled TRUE
_adaptive_log_file_sync_high_switch_freq_threshold 3
_adaptive_log_file_sync_poll_aggressiveness 0
_adaptive_log_file_sync_sched_delay_window 60
_adaptive_log_file_sync_use_polling_threshold 200
_adaptive_log_file_sync_use_postwait_threshold 50
_add_col_optim_enabled TRUE
_add_stale_mv_to_dependency_list TRUE
_add_trim_for_nlssort TRUE
_addm_auto_enable TRUE
_addm_skiprules
_addm_version_check TRUE
_adjust_literal_replacement FALSE
_adr_migrate_runonce TRUE
_affinity_on TRUE
_aged_out_cursor_cache_time 300
_aggregation_optimization_settings 0
_aiowait_timeouts 100
_alert_expiration 604800
_alert_message_cleanup 1
_alert_message_purge 1
_alert_post_background 1
_all_shared_dblinks
_allocate_creation_order FALSE
_allocation_update_interval 3
_allow_cell_smart_scan_attr TRUE
_allow_commutativity TRUE
_allow_compatibility_adv_w_grp FALSE
_allow_drop_snapshot_standby_grsp FALSE
_allow_drop_ts_with_grp FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_allow_error_simulation FALSE
_allow_level_without_connect_by FALSE
_allow_read_only_corruption FALSE
_allow_resetlogs_corruption FALSE
_allow_terminal_recovery_corruption FALSE
_alternate_iot_leaf_block_split_points TRUE
_always_anti_join CHOOSE
_always_semi_join CHOOSE
_always_star_transformation FALSE
_and_pruning_enabled TRUE
_app_ctx_vers FALSE
_appqos_qt 10
_aq_max_scan_delay 1500
_aq_tm_deqcountinterval 0
_aq_tm_scanlimit 0
_aq_tm_statistics_duration 0
_arch_comp_dbg_scan 0
_arch_comp_dec_block_check_dump 1
_arch_compress_checksums FALSE
_arch_compression TRUE
_arch_io_slaves 0
_arch_sim_mode 0
_array_update_vector_read_enabled FALSE
_ash_compression_enable TRUE
_ash_disk_filter_ratio 10
_ash_disk_write_enable TRUE
_ash_dummy_test_param 0
_ash_eflush_trigger 66
_ash_enable TRUE
_ash_min_mmnl_dump 90
_ash_sample_all FALSE
_ash_sampling_interval 1000
_ash_size 1048618
_asm_acd_chunks 1
_asm_admin_with_sysdba FALSE
_asm_allow_appliance_dropdisk_noforce FALSE
_asm_allow_lvm_resilvering TRUE
_asm_allow_only_raw_disks TRUE
_asm_allow_system_alias_rename FALSE
_asm_appliance_config_file
_asm_ausize 1048576
_asm_automatic_rezone TRUE
_asm_avoid_pst_scans TRUE
_asm_blksize 4096
_asm_check_for_misbehaving_cf_clients FALSE
_asm_compatibility 10.1
_asm_dba_batch 500000
_asm_dba_threshold 0
_asm_dbmsdg_nohdrchk FALSE
_asm_diag_dead_clients FALSE
_asm_direct_con_expire_time 120
_asm_disable_amdu_dump FALSE
_asm_disable_async_msgs FALSE
_asm_disable_multiple_instance_check FALSE
_asm_disable_profilediscovery FALSE
_asm_disable_smr_creation FALSE
_asm_disk_repair_time 14400
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_asm_emulate_nfs_disk FALSE
_asm_emulmax 10000
_asm_emultimeout 0
_asm_evenread 0
_asm_evenread_alpha 0
_asm_evenread_alpha2 0
_asm_evenread_faststart 0
_asm_fail_random_rx FALSE
_asm_fob_tac_frequency 9
_asm_force_quiesce FALSE
_asm_hbeatiowait 15
_asm_hbeatwaitquantum 2
_asm_imbalance_tolerance 3
_asm_instlock_quota 0
_asm_iostat_latch_count 31
_asm_kfdpevent 0
_asm_kfioevent 0
_asm_kill_unresponsive_clients TRUE
_asm_libraries ufs
_asm_log_scale_rebalance FALSE
_asm_lsod_bucket_size 13
_asm_max_cod_strides 5
_asm_max_redo_buffer_size 2097152
_asm_maxio 1048576
_asm_partner_target_disk_part 8
_asm_partner_target_fg_rel 4
_asm_primary_load 1
_asm_primary_load_cycles TRUE
_asm_random_zone FALSE
_asm_rebalance_plan_size 120
_asm_rebalance_space_errors 4
_asm_repairquantum 60
_asm_reserve_slaves TRUE
_asm_root_directory ASM
_asm_runtime_capability_volume_support FALSE
_asm_secondary_load 10000
_asm_secondary_load_cycles FALSE
_asm_serialize_volume_rebalance FALSE
_asm_shadow_cycle 3
_asm_skip_rename_check FALSE
_asm_skip_resize_check FALSE
_asm_storagemaysplit FALSE
_asm_stripesize 131072
_asm_stripewidth 8
_asm_sync_rebalance FALSE
_asm_usd_batch 64
_asm_wait_time 18
_asmlib_test 0
_asmsid asm
_assm_default TRUE
_assm_force_fetchmeta FALSE
_assm_high_gsp_threshold 11024
_assm_low_gsp_threshold 10000
_async_recovery_claims TRUE
_async_recovery_reads TRUE
_async_ts_threshold 1
_auto_assign_cg_for_sessions FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_auto_bmr enabled
_auto_bmr_bg_time 3600
_auto_bmr_fc_time 60
_auto_bmr_pub_timeout 10
_auto_bmr_req_timeout 60
_auto_bmr_sess_threshold 30
_auto_bmr_sys_threshold 100
_auto_manage_enable_offline_check TRUE
_auto_manage_exadata_disks TRUE
_auto_manage_infreq_tout 0
_auto_manage_ioctl_bufsz 8192
_auto_manage_max_online_tries 3
_auto_manage_num_pipe_msgs 1000
_auto_manage_num_tries 2
_auto_manage_online_tries_expire_time 86400
_automatic_maintenance_test 0
_automemory_broker_interval 3
_autotask_max_window 480
_autotask_min_window 15
_autotune_gtx_idle_time 600
_autotune_gtx_interval 5
_autotune_gtx_threshold 60
_available_core_count 0
_avoid_prepare TRUE
_awr_corrupt_mode FALSE
_awr_disabled_flush_tables
_awr_flush_threshold_metrics TRUE
_awr_flush_workload_metrics FALSE
_awr_mmon_cpuusage TRUE
_awr_mmon_deep_purge_extent 7
_awr_mmon_deep_purge_interval 7
_awr_mmon_deep_purge_numrows 5000
_awr_restrict_mode FALSE
_awr_sql_child_limit 200
_b_tree_bitmap_plans TRUE
_backup_align_write_io TRUE
_backup_automatic_retry 10
_backup_disk_bufcnt 0
_backup_disk_bufsz 0
_backup_disk_io_slaves 0
_backup_dynamic_buffers TRUE
_backup_encrypt_opt_mode 4294967294
_backup_file_bufcnt 0
_backup_file_bufsz 0
_backup_io_pool_size 1048576
_backup_kgc_blksiz 9
_backup_kgc_bufsz 0
_backup_kgc_memlevel 8
_backup_kgc_niters 0
_backup_kgc_perflevel 1
_backup_kgc_scheme ZLIB
_backup_kgc_type 0
_backup_kgc_windowbits 15
_backup_ksfq_bufcnt 0
_backup_ksfq_bufcnt_max 64
_backup_ksfq_bufsz 0
_backup_lzo_size 262144
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_backup_max_gap_size 4294967294
_backup_seq_bufcnt 0
_backup_seq_bufsz 0
_bct_bitmaps_per_file 8
_bct_buffer_allocation_max 104857600
_bct_buffer_allocation_min_extents 1
_bct_buffer_allocation_size 2097152
_bct_chunk_size 0
_bct_crash_reserve_size 262144
_bct_file_block_size 0
_bct_file_extent_size 0
_bct_fixtab_file
_bct_health_check_interval 60
_bct_initial_private_dba_buffer_size 0
_bct_public_dba_buffer_size 0
_bitmap_or_improvement_enabled TRUE
_block_sample_readahead_prob_threshold 10
_blocking_sess_graph_cache_size
_blocks_per_cache_server 32
_bloom_filter_debug 0
_bloom_filter_enabled TRUE
_bloom_folding_density 16
_bloom_folding_enabled TRUE
_bloom_folding_min 131072
_bloom_max_size 268435456
_bloom_minmax_enabled TRUE
_bloom_predicate_enabled TRUE
_bloom_predicate_pushdown_to_storage TRUE
_bloom_pruning_enabled TRUE
_bloom_pushing_max 512
_bloom_pushing_total_max 262144
_bloom_vector_elements 0
_bmr_prefered_standby
_branch_tagging TRUE
_broadcast_scn_wait_timeout 10
_bsln_adaptive_thresholds_enabled TRUE
_bt_mmv_query_rewrite_enabled TRUE
_buffer_busy_wait_timeout 100
_buffered_message_spill_age 300
_buffered_publisher_flow_control_threshold 0
_bufq_stop_flow_control FALSE
_build_deferred_mv_skipping_mvlog_update TRUE
_bump_highwater_mark_count 0
_bwr_for_flushed_pi TRUE
_bypass_srl_for_so_eor FALSE
_bypass_xplatform_error FALSE
_cache_stats_monitor FALSE
_capture_buffer_size 65536
_capture_publisher_flow_control_threshold 0
_case_sensitive_logon TRUE
_causal_standby_wait_timeout 20
_cdc_subscription_owner
_cdmp_diagnostic_level 2
_cell_fast_file_create TRUE
_cell_fast_file_restore TRUE
_cell_file_format_chunk_size 0
_cell_index_scan_enabled TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_cell_offload_capabilities_enabled 1
_cell_offload_hybridcolumnar TRUE
_cell_offload_predicate_reordering_enabled FALSE
_cell_offload_timezone TRUE
_cell_offload_virtual_columns TRUE
_cell_range_scan_enabled TRUE
_cell_storidx_mode EVA
_cgs_allgroup_poll_time 20000
_cgs_dball_group_registration local
_cgs_dbgroup_poll_time 600
_cgs_health_check_in_reconfig TRUE
_cgs_node_kill_escalation TRUE
_cgs_node_kill_escalation_wait 0
_cgs_reconfig_extra_wait 3
_cgs_reconfig_timeout 0
_cgs_send_timeout 300
_cgs_tickets 1000
_cgs_zombie_member_kill_wait 20
_change_vector_buffers 1
_check_block_after_checksum TRUE
_check_block_new_invariant_for_flashback FALSE
_check_column_length TRUE
_check_ts_threshold 0
_cleanup_rollback_entries 100
_cleanup_timeout 150
_cleanup_timeout_flags 2
_clear_buffer_before_reuse FALSE
_client_ntfn_cleanup_interval 2400
_client_ntfn_pinginterval 75
_client_ntfn_pingretries 6
_client_ntfn_pingtimeout 30000
_client_result_cache_bypass FALSE
_client_tstz_error_check TRUE
_close_cached_open_cursors FALSE
_close_deq_by_cond_curs FALSE
_cluster_library clss
_clusterwide_global_transactions TRUE
_collapse_wait_history FALSE
_collect_undo_stats TRUE
_column_compression_factor 0
_column_elimination_off FALSE
_column_tracking_level 1
_compilation_call_heap_extent_size 16384
_complex_view_merging TRUE
_compression_above_cache 0
_compression_advisor 0
_compression_chain 90
_compression_compatibility 11.2.0.0.0
_connect_by_use_union_all TRUE
_connection_broker_host
_controlfile_autobackup_delay 300
_controlfile_backup_copy_check TRUE
_controlfile_block_size 0
_controlfile_enqueue_dump FALSE
_controlfile_enqueue_holding_time 120
_controlfile_enqueue_holding_time_tracking_size 10
_controlfile_enqueue_timeout 900
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_controlfile_section_init_size
_controlfile_section_max_expand
_controlfile_update_check OFF
_convert_set_to_join FALSE
_coord_message_buffer 0
_corrupted_rollback_segments
_cost_equality_semi_join TRUE
_cp_num_hash_latches 1
_cpu_to_io 0
_cr_grant_global_role TRUE
_cr_grant_local_role AUTO
_cr_grant_only FALSE
_cr_server_log_flush TRUE
_cr_trc_buf_size 8192
_create_table_in_any_cluster FALSE
_cursor_bind_capture_area_size 400
_cursor_bind_capture_interval 900
_cursor_cache_time 900
_cursor_db_buffers_pinned 719
_cursor_features_enabled 2
_cursor_obsolete_threshold 100
_cursor_plan_enabled TRUE
_cursor_plan_hash_version 1
_cursor_plan_unparse_enabled TRUE
_cursor_runtimeheap_memlimit 5242880
_cursor_stats_enabled TRUE
_cvw_enable_weak_checking TRUE
_datafile_cow FALSE
_datafile_write_errors_crash_instance TRUE
_db_16k_flash_cache_file
_db_16k_flash_cache_size 0
_db_2k_flash_cache_file
_db_2k_flash_cache_size 0
_db_32k_flash_cache_file
_db_32k_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_aging_cool_count 1
_db_aging_freeze_cr FALSE
_db_aging_hot_criteria 2
_db_aging_stay_count 0
_db_aging_touch_time 3
_db_always_check_system_ts TRUE
_db_block_adjcheck TRUE
_db_block_adjchk_level 0
_db_block_align_direct_read TRUE
_db_block_bad_write_check FALSE
_db_block_buffers 360693
_db_block_cache_clone FALSE
_db_block_cache_history 0
_db_block_cache_history_level 2
_db_block_cache_num_umap 0
_db_block_cache_protect FALSE
_db_block_cache_protect_internal 0
_db_block_check_for_debug FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_db_block_check_objtyp TRUE
_db_block_chunkify_ncmbr FALSE
_db_block_corruption_recovery_threshold 5
_db_block_do_full_mbreads FALSE
_db_block_hash_buckets 1048576
_db_block_hash_latches 32768
_db_block_header_guard_level 0
_db_block_hi_priority_batch_size 0
_db_block_known_clean_pct 2
_db_block_lru_latches 256
_db_block_max_cr_dba 6
_db_block_max_scan_pct 40
_db_block_med_priority_batch_size 0
_db_block_numa 1
_db_block_prefetch_fast_longjumps_enabled TRUE
_db_block_prefetch_limit 0
_db_block_prefetch_override 0
_db_block_prefetch_private_cache_enabled TRUE
_db_block_prefetch_quota 10
_db_block_prefetch_skip_reading_enabled TRUE
_db_block_table_scan_buffer_size 4194304
_db_block_temp_redo FALSE
_db_block_trace_protect FALSE
_db_block_vlm_check FALSE
_db_block_vlm_leak_threshold 3
_db_blocks_per_hash_latch
_db_cache_advice_max_size_factor 2
_db_cache_advice_sample_factor 4
_db_cache_advice_sanity_check FALSE
_db_cache_block_read_stack_trace 0
_db_cache_crx_check FALSE
_db_cache_miss_check_les FALSE
_db_cache_mman_latch_check FALSE
_db_cache_pre_warm TRUE
_db_cache_process_cr_pin_max
_db_cache_wait_debug 0
_db_change_notification_enable TRUE
_db_check_cell_hints FALSE
_db_disable_temp_encryption FALSE
_db_dump_from_disk_noefc 0
_db_fast_obj_check FALSE
_db_fast_obj_ckpt TRUE
_db_fast_obj_truncate TRUE
_db_file_direct_io_count 1048576
_db_file_exec_read_count 128
_db_file_format_io_buffers 4
_db_file_noncontig_mblock_read_count 11
_db_file_optimizer_read_count 8
_db_flash_cache_force_replenish_limit 8
_db_flash_cache_keep_limit 228716368
_db_flash_cache_write_limit 1
_db_flashback_iobuf_size 1
_db_flashback_log_min_size 16777216
_db_flashback_log_min_total_space 0
_db_flashback_num_iobuf 32
_db_handles 4000
_db_handles_cached 8
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_db_hot_block_tracking FALSE
_db_index_block_checking TRUE
_db_initial_cachesize_create_mb 256
_db_l2_tracing 0
_db_large_dirty_queue 25
_db_lost_write_checking 2
_db_lost_write_tracing FALSE
_db_mttr_advice ON
_db_mttr_partitions 0
_db_mttr_sample_factor 64
_db_mttr_sim_target
_db_mttr_sim_trace_size 256
_db_mttr_trace_to_alert FALSE
_db_noarch_disble_optim FALSE
_db_num_evict_waitevents 64
_db_obj_enable_ksr TRUE
_db_percent_hot_default 50
_db_percent_hot_keep 0
_db_percent_hot_recycle 0
_db_percpu_create_cachesize 2
_db_prefetch_histogram_statistics FALSE
_db_recovery_temporal_file_dest
_db_required_percent_fairshare_usage 10
_db_row_overlap_checking TRUE
_db_todefer_cache_create TRUE
_db_writer_chunk_writes 0
_db_writer_coalesce_area_size 4194304
_db_writer_coalesce_write_limit 131072
_db_writer_flush_imu TRUE
_db_writer_histogram_statistics FALSE
_db_writer_max_writes 0
_db_writer_nomemcopy_coalesce FALSE
_db_writer_verify_writes FALSE
_dbg_proc_startup FALSE
_dbms_sql_security_level 1
_dbrm_dynamic_threshold 16843752
_dbrm_num_runnable_list 0
_dbrm_quantum
_dbrm_runchk 0
_dbrm_short_wait_us 300
_dbwr_async_io TRUE
_dbwr_scan_interval 300
_dbwr_tracing 0
_dde_flood_control_init TRUE
_dead_process_scan_interval 60
_deadlock_diagnostic_level 2
_deadlock_resolution_incidents_always FALSE
_deadlock_resolution_incidents_enabled TRUE
_deadlock_resolution_level 1
_deadlock_resolution_min_wait_timeout_secs 60
_deadlock_resolution_signal_process_thresh_secs 60
_dedicated_server_poll_count 10
_dedicated_server_post_wait FALSE
_dedicated_server_post_wait_call FALSE
_default_encrypt_alg 0
_default_non_equality_sel_check TRUE
_defer_eor_orl_arch_for_so FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_defer_log_boundary_ckpt TRUE
_defer_log_count 2
_defer_rcv_during_sw_to_sby FALSE
_deferred_constant_folding_mode DEFAULT
_deferred_log_dest_is_valid TRUE
_delay_index_maintain TRUE
_delta_push_share_blockers 0
_deq_execute_reset_time 30
_deq_ht_child_latches 8
_deq_ht_max_elements 100000
_deq_large_txn_size 25000
_deq_log_array_size 10000
_deq_max_fetch_count 10
_deq_maxwait_time 0
_desired_readmem_rate 90
_dg_broker_trace_level
_dg_cf_check_timer 15
_dg_corrupt_redo_log 0
_diag_adr_auto_purge TRUE
_diag_adr_enabled TRUE
_diag_adr_test_param 0
_diag_arb_before_kill FALSE
_diag_backward_compat TRUE
_diag_cc_enabled TRUE
_diag_conf_cap_enabled TRUE
_diag_crashdump_level 10
_diag_daemon TRUE
_diag_dde_async_age_limit 300
_diag_dde_async_cputime_limit 300
_diag_dde_async_mode 1
_diag_dde_async_msg_capacity 1024
_diag_dde_async_msgs 50
_diag_dde_async_process_rate 5
_diag_dde_async_runtime_limit 900
_diag_dde_async_slaves 5
_diag_dde_enabled TRUE
_diag_dde_fc_enabled TRUE
_diag_dde_fc_implicit_time 0
_diag_dde_fc_macro_time 0
_diag_dde_inc_proc_delay 1
_diag_diagnostics TRUE
_diag_dump_request_debug_level 1
_diag_dump_timeout 30
_diag_enable_startup_events FALSE
_diag_hm_rc_enabled TRUE
_diag_hm_tc_enabled FALSE
_diag_proc_enabled TRUE
_diag_proc_max_time_ms 30000
_diag_proc_stack_capture_type 1
_diag_uts_control 0
_diag_verbose_error_on_init 0
_dimension_skip_null TRUE
_direct_io_skip_cur_slot_on_error TRUE
_direct_io_slots 0
_direct_io_wslots 0
_direct_path_insert_features 0
_direct_read_decision_statistics_driven TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_disable_12751 FALSE
_disable_active_influx_move FALSE
_disable_adaptive_shrunk_aggregation FALSE
_disable_appliance_check FALSE
_disable_appliance_partnering FALSE
_disable_autotune_gtx FALSE
_disable_block_checking FALSE
_disable_cell_optimized_backups FALSE
_disable_cpu_check FALSE
_disable_cursor_sharing FALSE
_disable_datalayer_sampling FALSE
_disable_duplex_link TRUE
_disable_fast_aggregation FALSE
_disable_fast_validate FALSE
_disable_fastopen FALSE
_disable_fba_qrw 0
_disable_fba_wpr 0
_disable_file_locks FALSE
_disable_flashback_archiver 0
_disable_flashback_wait_callback FALSE
_disable_function_based_index FALSE
_disable_gvaq_cache FALSE
_disable_health_check FALSE
_disable_highres_ticks FALSE
_disable_image_check FALSE
_disable_implicit_row_movement FALSE
_disable_incremental_checkpoints FALSE
_disable_incremental_recovery_ckpt FALSE
_disable_index_block_prefetching FALSE
_disable_initial_block_compression FALSE
_disable_instance_params_check FALSE
_disable_interface_checking FALSE
_disable_kcb_flashback_blocknew_opt FALSE
_disable_kcbhxor_osd FALSE
_disable_kcbl_flashback_blocknew_opt FALSE
_disable_kgghshcrc32_osd FALSE
_disable_latch_free_SCN_writes_via_32cas FALSE
_disable_latch_free_SCN_writes_via_64cas FALSE
_disable_logging FALSE
_disable_metrics_group 0
_disable_multiple_block_sizes FALSE
_disable_odm FALSE
_disable_parallel_conventional_load FALSE
_disable_primary_bitmap_switch FALSE
_disable_read_only_open_dict_check FALSE
_disable_rebalance_compact FALSE
_disable_rebalance_space_check FALSE
_disable_recovery_read_skip FALSE
_disable_sample_io_optim FALSE
_disable_savepoint_reset FALSE
_disable_selftune_checkpointing FALSE
_disable_storage_type TRUE
_disable_streams_diagnostics 0
_disable_streams_pool_auto_tuning FALSE
_disable_sun_rsm TRUE
_disable_system_state 4294967294
_disable_system_state_wait_samples FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_disable_temp_tablespace_alerts FALSE
_disable_thread_internal_disable FALSE
_disable_thread_snapshot TRUE
_disable_txn_alert 0
_disable_undo_tablespace_alerts FALSE
_disable_wait_state
_discrete_transactions_enabled FALSE
_disk_sector_size_override FALSE
_diskmon_pipe_name
_dispatcher_rate_scale
_dispatcher_rate_ttl
_distinct_view_unnesting FALSE
_distributed_recovery_connection_hold_time 200
_dlmtrace
_dm_max_shared_pool_pct 1
_dml_batch_error_limit 0
_dml_frequency_tracking FALSE
_dml_frequency_tracking_advance TRUE
_dml_frequency_tracking_slot_time 15
_dml_frequency_tracking_slots 4
_dml_monitoring_enabled TRUE
_domain_index_batch_size 2000
_domain_index_dml_batch_size 200
_dra_bmr_number_threshold 1000
_dra_bmr_percent_threshold 10
_dra_enable_offline_dictionary FALSE
_drm_parallel_freeze TRUE
_drop_flashback_logical_operations_enq FALSE
_drop_table_granule 256
_drop_table_optimization_enabled TRUE
_ds_enable_auto_txn FALSE
_ds_iocount_iosize 6553664
_ds_parse_model 2
_dsc_feature_level 0
_dskm_health_check_cnt 20
_dss_cache_flush FALSE
_dtree_area_size 131072
_dtree_binning_enabled TRUE
_dtree_bintest_id 0
_dtree_compressbmp_enabled TRUE
_dtree_max_surrogates 1
_dtree_pruning_enabled TRUE
_dummy_instance FALSE
_dump_common_subexpressions FALSE
_dump_connect_by_loop_data FALSE
_dump_cursor_heap_sizes FALSE
_dump_interval_limit 120
_dump_max_limit 5
_dump_qbc_tree 0
_dump_rcvr_ipc TRUE
_dump_system_state_scope local
_dump_trace_scope global
_dynamic_rls_policies TRUE
_dynamic_stats_threshold 30
_eighteenth_spare_parameter
_eighth_spare_parameter
_eleventh_spare_parameter
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_eliminate_common_subexpr TRUE
_emon_max_active_connections 256
_emon_outbound_connect_timeout 30000
_emon_regular_ntfn_slaves 4
_enable_Front_End_View_Optimization 1
_enable_LGPG_debug FALSE
_enable_NUMA_interleave TRUE
_enable_NUMA_optimization FALSE
_enable_NUMA_support FALSE
_enable_asyncvio FALSE
_enable_automatic_maintenance 1
_enable_automatic_sqltune TRUE
_enable_block_level_transaction_recovery TRUE
_enable_check_truncate TRUE
_enable_cscn_caching FALSE
_enable_ddl_wait_lock TRUE
_enable_default_affinity 0
_enable_default_temp_threshold TRUE
_enable_default_undo_threshold TRUE
_enable_dml_lock_escalation TRUE
_enable_editions_for_users FALSE
_enable_exchange_validation_using_check TRUE
_enable_fast_ref_after_mv_tbs FALSE
_enable_ffw TRUE
_enable_flash_logging TRUE
_enable_hash_overflow FALSE
_enable_hwm_sync TRUE
_enable_kqf_purge TRUE
_enable_list_io FALSE
_enable_midtier_affinity TRUE
_enable_minscn_cr TRUE
_enable_nativenet_tcpip FALSE
_enable_obj_queues TRUE
_enable_online_index_without_s_locking TRUE
_enable_query_rewrite_on_remote_objs TRUE
_enable_redo_global_post FALSE
_enable_refresh_schedule TRUE
_enable_reliable_latch_waits TRUE
_enable_rename_user FALSE
_enable_rlb TRUE
_enable_row_shipping TRUE
_enable_sb_detection TRUE
_enable_schema_synonyms FALSE
_enable_scn_wait_interface TRUE
_enable_separable_transactions FALSE
_enable_shared_pool_durations TRUE
_enable_shared_server_vector_io FALSE
_enable_space_preallocation 3
_enable_spacebg TRUE
_enable_tablespace_alerts TRUE
_enable_type_dep_selectivity TRUE
_endprot_chunk_comment chk 10235 dflt
_endprot_heap_comment hp 10235 dflt
_endprot_subheaps TRUE
_enqueue_deadlock_scan_secs 0
_enqueue_deadlock_time_sec 5
_enqueue_debug_multi_instance FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_enqueue_hash 1635
_enqueue_hash_chain_latches 32
_enqueue_locks 10190
_enqueue_paranoia_mode_enabled FALSE
_enqueue_resources 3740
_evolve_plan_baseline_report_level typical
_evt_system_event_propagation TRUE
_expand_aggregates TRUE
_explain_rewrite_mode FALSE
_extended_pruning_enabled TRUE
_fair_remote_cvt FALSE
_fairness_threshold 2
_fast_cursor_reexecute FALSE
_fast_dual_enabled TRUE
_fast_full_scan_enabled TRUE
_fastpin_enable 228793345
_fbda_busy_percentage 0
_fbda_debug_assert 0
_fbda_debug_mode 0
_fbda_global_bscn_lag 0
_fbda_inline_percentage 0
_fbda_rac_inactive_limit 0
_fg_iorm_slaves 1
_fg_log_checksum TRUE
_fg_sync_sleep_usecs 0
_fic_algorithm_set automatic
_fic_area_size 131072
_fic_max_length 20
_fic_min_bmsize 1024
_fic_outofmem_candidates FALSE
_fifteenth_spare_parameter
_fifth_spare_parameter
_file_size_increase_increment 67108864
_filemap_dir
_first_k_rows_dynamic_proration TRUE
_first_spare_parameter
_fix_control
_flashback_11.1_block_new_opt FALSE
_flashback_allow_noarchivelog FALSE
_flashback_archiver_partition_size 0
_flashback_barrier_interval 1800
_flashback_copy_latches 10
_flashback_database_test_only FALSE
_flashback_delete_chunk_MB 128
_flashback_dynamic_enable TRUE
_flashback_dynamic_enable_failure 0
_flashback_enable_ra TRUE
_flashback_format_chunk_mb 4
_flashback_format_chunk_mb_dwrite 16
_flashback_fuzzy_barrier TRUE
_flashback_generation_buffer_size 134217728
_flashback_hint_barrier_percent 20
_flashback_log_io_error_behavior 0
_flashback_log_min_size 100
_flashback_log_rac_balance_factor 10
_flashback_log_size 1000
_flashback_logfile_enqueue_timeout 600
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_flashback_marker_cache_enabled TRUE
_flashback_marker_cache_size 328
_flashback_max_log_size 0
_flashback_max_n_log_per_thread 2048
_flashback_max_standby_sync_span 300
_flashback_n_log_per_thread 128
_flashback_prepare_log TRUE
_flashback_size_based_on_redo TRUE
_flashback_standby_barrier_interval 1
_flashback_validate_controlfile FALSE
_flashback_verbose_info FALSE
_flashback_write_max_loop_limit 10
_flush_plan_in_awr_sql 0
_flush_redo_to_standby 0
_flush_undo_after_tx_recovery TRUE
_force_arch_compress 0
_force_datefold_trunc FALSE
_force_hash_join_spill FALSE
_force_hsc_compress FALSE
_force_oltp_compress FALSE
_force_oltp_update_opt TRUE
_force_rcv_info_ping 0
_force_rewrite_enable FALSE
_force_slave_mapping_intra_part_loads FALSE
_force_temptables_for_gsets FALSE
_force_tmp_segment_loads FALSE
_forwarded_2pc_threshold 10
_fourteenth_spare_parameter
_fourth_spare_parameter
_frame_cache_time 0
_full_pwise_join_enabled TRUE
_fusion_security FALSE
_gby_hash_aggregation_enabled TRUE
_gby_onekey_enabled TRUE
_gc_affinity_locking TRUE
_gc_affinity_locks TRUE
_gc_affinity_ratio 50
_gc_async_memcpy FALSE
_gc_bypass_readers TRUE
_gc_check_bscn TRUE
_gc_coalesce_recovery_reads TRUE
_gc_cpu_time FALSE
_gc_cr_server_read_wait TRUE
_gc_defer_ping_index_only TRUE
_gc_defer_time 1
_gc_delta_push_compression 3072
_gc_delta_push_max_level 100
_gc_delta_push_objects 0
_gc_disable_s_lock_brr_ping_check TRUE
_gc_down_convert_after_keep TRUE
_gc_element_percent 110
_gc_escalate_bid TRUE
_gc_fg_merge TRUE
_gc_flush_during_affinity TRUE
_gc_fusion_compression 1024
_gc_global_checkpoint_scn TRUE
_gc_global_cpu TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_gc_global_lru AUTO
_gc_global_lru_touch_count 5
_gc_global_lru_touch_time 60
_gc_integrity_checks 1
_gc_keep_recovery_buffers TRUE
_gc_latches 8
_gc_log_flush TRUE
_gc_long_query_threshold 0
_gc_max_downcvt 256
_gc_maximum_bids 0
_gc_no_fairness_for_clones TRUE
_gc_override_force_cr TRUE
_gc_persistent_read_mostly TRUE
_gc_policy_minimum 1500
_gc_policy_time 10
_gc_read_mostly_flush_check FALSE
_gc_read_mostly_locking TRUE
_gc_sanity_check_cr_buffers FALSE
_gc_serve_high_pi_as_current TRUE
_gc_statistics TRUE
_gc_transfer_ratio 2
_gc_tsn_undo_affinity TRUE
_gc_undo_affinity TRUE
_gc_undo_block_disk_reads TRUE
_gc_use_cr TRUE
_gc_vector_read TRUE
_gcr_enable_high_cpu_kill FALSE
_gcr_enable_high_cpu_rm FALSE
_gcr_enable_high_cpu_rt FALSE
_gcr_high_cpu_threshold 10
_gcr_use_css TRUE
_gcs_disable_remote_handles FALSE
_gcs_disable_skip_close_remastering FALSE
_gcs_fast_reconfig TRUE
_gcs_latches 0
_gcs_pkey_history 4000
_gcs_process_in_recovery TRUE
_gcs_res_per_bucket 4
_gcs_resources
_gcs_shadow_locks
_gcs_testing 0
_generalized_pruning_enabled TRUE
_ges_dd_debug 1
_ges_designated_master FALSE
_ges_diagnostics TRUE
_ges_diagnostics_asm_dump_level 11
_ges_health_check 0
_ges_num_blockers_to_kill 1
_global_hang_analysis_interval_secs 10
_globalindex_pnum_filter_enabled TRUE
_groupby_nopushdown_cut_ratio 3
_groupby_orderby_combine 5000
_gs_anti_semi_join_allowed TRUE
_hang_analysis_num_call_stacks 3
_hang_detection_enabled TRUE
_hang_detection_interval 32
_hang_hiload_promoted_ignored_hang_count 2
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_hang_hiprior_session_attribute_list
_hang_ignored_hang_count 1
_hang_ignored_hangs_interval 300
_hang_log_incidents FALSE
_hang_long_wait_time_threshold 0
_hang_lws_file_count 5
_hang_lws_file_time_limit 3600
_hang_msg_checksum_enabled TRUE
_hang_output_suspected_hangs FALSE
_hang_resolution_confidence_promotion FALSE
_hang_resolution_global_hang_confidence_promotion FALSE
_hang_resolution_policy HIGH
_hang_resolution_promote_process_termination FALSE
_hang_resolution_scope PROCESS
_hang_signature_list_match_output_frequency 10
_hang_statistics_collection_interval 15
_hang_statistics_collection_ma_alpha 30
_hang_statistics_high_io_percentage_threshold 45
_hang_verification_interval 46
_hard_protection FALSE
_hash_join_enabled TRUE
_hash_multiblock_io_count 0
_hb_redo_msg_interval 100
_heur_deadlock_resolution_secs 0
_high_priority_processes LMS*|VKTM
_high_server_threshold 0
_highres_drift_allowed_sec 1
_highthreshold_undoretention 4294967294
_hj_bit_filter_threshold 50
_hm_analysis_oradebug_node_dump_level 0
_hm_analysis_oradebug_sys_dump_level 0
_hm_analysis_output_disk FALSE
_hwm_sync_threshold 10
_idl_conventional_index_maintenance TRUE
_idle_session_kill_enabled TRUE
_idxrb_rowincr 100000000
_ignore_desc_in_index FALSE
_ignore_edition_enabled_for_EV_creation FALSE
_ignore_fg_deps
_immediate_commit_propagation TRUE
_improved_outerjoin_card TRUE
_improved_row_length_enabled TRUE
_imr_active TRUE
_imr_avoid_double_voting TRUE
_imr_controlfile_access_wait_time 10
_imr_device_type controlfile
_imr_disk_voting_interval 3
_imr_diskvote_implementation auto
_imr_evicted_member_kill TRUE
_imr_evicted_member_kill_wait 20
_imr_extra_reconfig_wait 10
_imr_highload_threshold
_imr_max_reconfig_delay 75
_imr_splitbrain_res_wait 0
_imr_systemload_check TRUE
_imu_pools 3
_in_memory_tbs_search TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_in_memory_undo TRUE
_incremental_recovery_ckpt_min_batch 500
_index_join_enabled TRUE
_index_partition_large_extents FALSE
_index_prefetch_factor 100
_index_scan_check_skip_corrupt FALSE
_index_scan_check_stopkey FALSE
_init_granule_interval 10
_init_sql_file ?/rdbms/admin/sql.bsq
_inject_startup_fault 0
_inline_sql_in_plsql FALSE
_inplace_update_retry TRUE
_inquiry_retry_interval 3
_insert_enable_hwm_brokered TRUE
_inst_locking_period 5
_interconnect_checksum TRUE
_intrapart_pdml_enabled TRUE
_intrapart_pdml_randomlocal_enabled TRUE
_io_resource_manager_always_on FALSE
_io_shared_pool_size 4194304
_io_slaves_disabled FALSE
_io_statistics TRUE
_iocalibrate_init_ios 2
_iocalibrate_max_ios 0
_ioq_fanin_multiplier 2
_ior_serialize_fault 0
_iorm_tout 1000
_ioslave_batch_count 1
_ioslave_issue_count 500
_ipc_fail_network 0
_ipc_test_failover 0
_ipc_test_mult_nets 0
_ipddb_enable FALSE
_job_queue_interval 5
_k2q_latches 0
_kcfis_block_dump_level 0
_kcfis_caching_enabled TRUE
_kcfis_cell_passthru_enabled FALSE
_kcfis_cell_passthru_fromcpu_enabled TRUE
_kcfis_control1 0
_kcfis_control2 0
_kcfis_control3 0
_kcfis_control4 0
_kcfis_control5 0
_kcfis_control6 0
_kcfis_disable_platform_decryption FALSE
_kcfis_dump_corrupt_block TRUE
_kcfis_fast_response_enabled TRUE
_kcfis_fast_response_initiosize 2
_kcfis_fast_response_iosizemult 4
_kcfis_fast_response_threshold 1048576
_kcfis_fault_control 0
_kcfis_io_prefetch_size 8
_kcfis_ioreqs_throttle_enabled TRUE
_kcfis_kept_in_cellfc_enabled TRUE
_kcfis_large_payload_enabled FALSE
_kcfis_max_cached_sessions 10
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kcfis_max_out_translations 5000
_kcfis_nonkept_in_cellfc_enabled FALSE
_kcfis_oss_io_size 0
_kcfis_rdbms_blockio_enabled FALSE
_kcfis_read_buffer_limit 0
_kcfis_spawn_debugger FALSE
_kcfis_stats_level 0
_kcfis_storageidx_diag_mode 0
_kcfis_storageidx_disabled FALSE
_kcfis_test_control1 0
_kcfis_trace_bucket_size 131072
_kcfis_trace_level 0
_kcfis_work_set_appliances 2
_kcl_commit TRUE
_kcl_conservative_log_flush FALSE
_kcl_debug TRUE
_kcl_index_split TRUE
_kd_symtab_chk TRUE
_kdbl_enable_post_allocation FALSE
_kdi_avoid_block_checking FALSE
_kdic_segarr_sz 0
_kdis_reject_level 24
_kdis_reject_limit 5
_kdis_reject_ops FALSE
_kdli_STOP_bsz 0
_kdli_STOP_dba 0
_kdli_STOP_fsz 0
_kdli_STOP_nio 0
_kdli_STOP_tsn 0
_kdli_allow_corrupt TRUE
_kdli_buffer_inject TRUE
_kdli_cache_inode TRUE
_kdli_cache_read_threshold 0
_kdli_cache_size 8
_kdli_cache_verify FALSE
_kdli_cache_write_threshold 0
_kdli_cacheable_length 0
_kdli_checkpoint_flush FALSE
_kdli_dbc none
_kdli_delay_flushes TRUE
_kdli_flush_cache_reads FALSE
_kdli_flush_injections TRUE
_kdli_force_cr TRUE
_kdli_force_cr_meta TRUE
_kdli_force_storage none
_kdli_full_readahead_threshold 0
_kdli_inject_assert 0
_kdli_inject_batch 0
_kdli_inject_crash 0
_kdli_inline_xfm TRUE
_kdli_inode_preference data
_kdli_inplace_overwrite 0
_kdli_itree_entries 0
_kdli_memory_protect FALSE
_kdli_oneblk FALSE
_kdli_preallocation_mode length
_kdli_preallocation_pct 0
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kdli_rci_lobmap_entries 255
_kdli_readahead_limit 0
_kdli_readahead_strategy contig
_kdli_recent_scn FALSE
_kdli_reshape FALSE
_kdli_safe_callbacks TRUE
_kdli_sio_async TRUE
_kdli_sio_backoff FALSE
_kdli_sio_bps 0
_kdli_sio_dop 2
_kdli_sio_fbwrite_pct 35
_kdli_sio_fgio TRUE
_kdli_sio_fileopen none
_kdli_sio_flush FALSE
_kdli_sio_free TRUE
_kdli_sio_min_read 0
_kdli_sio_min_write 0
_kdli_sio_nbufs 8
_kdli_sio_niods 8
_kdli_sio_on TRUE
_kdli_sio_pga FALSE
_kdli_sio_pga_top FALSE
_kdli_sio_strategy extent
_kdli_sio_write_pct 100
_kdli_small_cache_limit 32
_kdli_sort_dbas FALSE
_kdli_space_cache_limit 2048
_kdli_squeeze TRUE
_kdli_timer_dmp FALSE
_kdli_timer_trc FALSE
_kdli_trace 0
_kdli_vll_direct TRUE
_kdlu_max_bucket_size 4194304
_kdlu_max_bucket_size_mts 131072
_kdlu_trace_layer 0
_kdlu_trace_session 0
_kdlu_trace_system 0
_kdlw_enable_ksi_locking FALSE
_kdlw_enable_write_gathering TRUE
_kdlwp_flush_threshold 4194304
_kdlxp_cmp_subunit_size 262144
_kdlxp_dedup_flush_threshold 8388608
_kdlxp_dedup_hash_algo SHA1
_kdlxp_dedup_inl_pctfree 5
_kdlxp_dedup_prefix_threshold 1048576
_kdlxp_dedup_wapp_len 0
_kdlxp_lobcmpadp FALSE
_kdlxp_lobcmplevel 2
_kdlxp_lobcmprciver 1
_kdlxp_lobcompress FALSE
_kdlxp_lobdeduplicate FALSE
_kdlxp_lobdedupvalidate TRUE
_kdlxp_lobencrypt FALSE
_kdlxp_mincmp 20
_kdlxp_mincmplen 200
_kdlxp_minxfm_size 32768
_kdlxp_spare1 0
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kdlxp_uncmp FALSE
_kdlxp_xfmcache TRUE
_kdt_buffering TRUE
_kdtgsp_retries 1024
_kdu_array_depth 16
_kdz_hcc_flags 0
_kdz_hcc_track_upd_rids TRUE
_kebm_nstrikes 3
_kebm_suspension_time 82800
_keep_remote_column_size FALSE
_kernel_message_network_driver FALSE
_kes_parse_model 2
_kffmap_hash_size 1024
_kffmop_hash_size 2048
_kfm_disable_set_fence FALSE
_kghdsidx_count 6
_kgl_bucket_count 9
_kgl_cluster_lock TRUE
_kgl_cluster_lock_read_mostly FALSE
_kgl_cluster_pin TRUE
_kgl_debug
_kgl_fixed_extents TRUE
_kgl_hash_collision FALSE
_kgl_heap_size 4096
_kgl_hot_object_copies 0
_kgl_kqr_cap_so_stacks FALSE
_kgl_large_heap_warning_threshold 52428800
_kgl_latch_count 0
_kgl_message_locks 64
_kgl_min_cached_so_count 1
_kgl_time_to_wait_for_locks 15
_kglsim_maxmem_percent 5
_kgsb_threshold_size 16777216
_kgx_latches 1024
_kill_controlfile_enqueue_blocker TRUE
_kill_diagnostics_timeout 60
_kill_enqueue_blocker 2
_kill_java_threads_on_eoc FALSE
_kill_session_dump TRUE
_kkfi_trace FALSE
_kks_cached_parse_errors 0
_kks_free_cursor_stat_pct 10
_kokli_cache_size 128
_kokln_current_read FALSE
_kolfuseslf FALSE
_kql_subheap_trace 0
_ksb_restart_clean_time 30000
_ksb_restart_policy_times 0, 60, 120, 240
_ksd_test_param 999
_ksdx_charset_ratio 0
_ksdxdocmd_default_timeout_ms 30000
_ksdxdocmd_enabled TRUE
_ksdxw_cini_flg 0
_ksdxw_nbufs 1000
_ksdxw_num_pgw 10
_ksdxw_num_sgw 10
_ksdxw_stack_depth 4
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kse_die_timeout 60000
_kse_pc_table_size 256
_kse_signature_entries 0
_kse_signature_limit 7
_kse_snap_ring_record_stack FALSE
_kse_snap_ring_size 0
_kse_trace_int_msg_clear FALSE
_ksfd_verify_write FALSE
_ksi_clientlocks_enabled TRUE
_ksi_trace
_ksi_trace_bucket PRIVATE
_ksi_trace_bucket_size 8192
_ksm_post_sga_init_notif_delay_secs 0
_ksm_pre_sga_init_notif_delay_secs 0
_ksmb_debug 0
_ksmd_protect_mode off
_ksmg_granule_locking_status 1
_ksmg_granule_size 16777216
_ksmg_lock_check_interval
_ksmg_lock_reacquire_count 5
_kspol_tac_timeout 5
_ksr_unit_test_processes 0
_kss_callstack_type
_kss_quiet FALSE
_ksu_diag_kill_time 5
_ksuitm_addon_trccmd
_ksuitm_dont_kill_dumper FALSE
_ksv_dynamic_flags1 0
_ksv_max_spawn_fail_limit 5
_ksv_pool_hang_kill_to 0
_ksv_pool_wait_timeout 600
_ksv_spawn_control_all FALSE
_ksv_static_flags1 0
_ksvppktmode 0
_ksxp_compat_flags 0
_ksxp_control_flags 0
_ksxp_diagmode OFF
_ksxp_disable_clss 0
_ksxp_disable_dynamic_loading FALSE
_ksxp_disable_ipc_stats FALSE
_ksxp_disable_rolling_migration FALSE
_ksxp_dump_timeout 20
_ksxp_dynamic_skgxp_param
_ksxp_if_config 0
_ksxp_init_stats_bkts 0
_ksxp_lwipc_enabled FALSE
_ksxp_max_stats_bkts 0
_ksxp_ping_enable TRUE
_ksxp_ping_polling_time 0
_ksxp_reaping 20
_ksxp_reporting_process LMD0
_ksxp_send_timeout 300
_ksxp_skgxp_compat_library_path
_ksxp_skgxp_ctx_flags1 0
_ksxp_skgxp_ctx_flags1mask 0
_ksxp_skgxp_dynamic_protocol 4096
_ksxp_skgxp_library_path
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_ksxp_skgxp_rgn_ports 0
_ksxp_skgxp_spare_param1
_ksxp_skgxp_spare_param2
_ksxp_skgxp_spare_param3
_ksxp_skgxp_spare_param4
_ksxp_skgxp_spare_param5
_ksxp_skgxpg_last_parameter 26
_ksxp_stats_mem_lmt 0
_ksxp_testing 0
_ksxp_unit_test_byte_transformation FALSE
_ksxp_wait_flags 0
_ktb_debug_flags 0
_ktc_debug 0
_ktc_latches 0
_ktslj_segext_max_mb 0
_ktslj_segext_retry 5
_ktslj_segext_warning 10
_ktslj_segext_warning_mb 0
_ktspsrch_maxsc 1024
_ktspsrch_maxskip 5
_kttext_warning 5
_ktu_latches 0
_ku_trace none
_large_pool_min_alloc 65536
_last_allocation_period 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
_latch_recovery_alignment 65534
_ldr_io_size 262144
_ldr_io_size2 1048576
_ldr_pga_lim 0
_left_nested_loops_random TRUE
_lgwr_delay_write FALSE
_lgwr_io_slaves 0
_lgwr_max_ns_wt 1
_lgwr_ns_nl_max 1000
_lgwr_ns_nl_min 500
_lgwr_ns_sim_err 0
_lgwr_posts_for_pending_bcasts FALSE
_lgwr_ta_sim_err 0
_library_cache_advice TRUE
_lightweight_hdrs TRUE
_like_with_bind_as_equality FALSE
_limit_itls 20
_linux_prepage_large_pages FALSE
_lm_activate_lms_threshold 100
_lm_asm_enq_hashing TRUE
_lm_batch_compression_threshold 0
_lm_better_ddvictim TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_lm_broadcast_res disable
_lm_broadcast_resname AD
_lm_cache_allocated_res_ratio 50
_lm_cache_lvl0_cleanup 0
_lm_cache_res_cleanup 25
_lm_cache_res_cleanup_tries 10
_lm_cache_res_options 0
_lm_cache_res_skip_cleanup 20
_lm_cache_res_type TMHWHVDI
_lm_checksum_batch_msg 0
_lm_compression_scheme zlib
_lm_contiguous_res_count 128
_lm_dd_ignore_nodd FALSE
_lm_dd_interval 10
_lm_dd_max_search_time 180
_lm_dd_maxdump 50
_lm_dd_scan_interval 5
_lm_dd_search_cnt 3
_lm_deferred_msg_timeout 163
_lm_drm_batch_time 10
_lm_drm_disable 0
_lm_drm_hiload_percentage 200
_lm_drm_lowload_percentage 200
_lm_drm_max_requests 100
_lm_drm_min_interval 300
_lm_drm_object_scan TRUE
_lm_drm_window 0
_lm_drm_xlatch 0
_lm_dump_null_lock FALSE
_lm_dynamic_lms FALSE
_lm_dynamic_load TRUE
_lm_enable_aff_benefit_stats FALSE
_lm_enq_lock_freelist
_lm_enq_rcfg TRUE
_lm_enqueue_blocker_dump_timeout 120
_lm_enqueue_blocker_kill_timeout 0
_lm_enqueue_freelist 3
_lm_enqueue_timeout 360
_lm_file_affinity
_lm_file_read_mostly
_lm_free_queue_threshold 0
_lm_freeze_kill_time 30
_lm_global_posts TRUE
_lm_hb_callstack_collect_time 5
_lm_hb_disable_check_list none
_lm_high_load_sysload_percentage 90
_lm_high_load_threshold 5
_lm_idle_connection_check TRUE
_lm_idle_connection_check_interval 140
_lm_idle_connection_instance_check_callout FALSE
_lm_idle_connection_kill TRUE
_lm_kill_fg_on_timeout TRUE
_lm_lhupd_interval 5
_lm_lmd_waittime 8
_lm_lmon_nowait_latch TRUE
_lm_lms 0
_lm_lms_priority_dynamic TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_lm_lms_rt_threshold
_lm_lms_spin FALSE
_lm_lms_waittime 3
_lm_local_hp_enq TRUE
_lm_locks 12000
_lm_low_load_percentage 75
_lm_master_weight 1
_lm_max_lms 0
_lm_msg_batch_size 0
_lm_msg_cleanup_interval 3000
_lm_no_lh_check FALSE
_lm_no_sync TRUE
_lm_node_join_opt FALSE
_lm_non_fault_tolerant FALSE
_lm_num_pt_buckets 8192
_lm_num_pt_latches 128
_lm_postevent_buffer_size 256
_lm_preregister_css_restype CF
_lm_proc_freeze_timeout 70
_lm_process_batching TRUE
_lm_procs 320
_lm_psrcfg TRUE
_lm_rac_spare_dp1 0
_lm_rac_spare_dp10
_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_p1 0
_lm_rac_spare_p10
_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_rcfg_timeout 489
_lm_rcvinst TRUE
_lm_rcvr_hang_allow_time 70
_lm_rcvr_hang_cfio_kill FALSE
_lm_rcvr_hang_check_frequency 20
_lm_rcvr_hang_check_system_load TRUE
_lm_rcvr_hang_kill TRUE
_lm_rcvr_hang_systemstate_dump_level 0
_lm_res_hash_bucket 0
_lm_res_part 128
_lm_ress 6000
_lm_send_mode auto
_lm_send_queue_batching TRUE
_lm_send_queue_length 5000
_lm_sendproxy_reserve 25
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_lm_share_lock_opt FALSE
_lm_single_inst_affinity_lock TRUE
_lm_spare_threads 0
_lm_spare_undo 0
_lm_sq_batch_factor 2
_lm_sq_batch_type auto
_lm_sq_batch_waittick 3
_lm_sync_timeout 163
_lm_ticket_active_sendback
_lm_tickets 1000
_lm_tx_delta 16
_lm_use_gcr TRUE
_lm_use_new_defmsgtmo_action TRUE
_lm_use_tx_tsn TRUE
_lm_validate_pbatch FALSE
_lm_validate_resource_type FALSE
_lm_watchpoint_maximum 3
_lm_watchpoint_timeout 3600
_lm_xids 352
_lmn_compression TRUE
_load_without_compile NONE
_local_arc_assert_on_wait FALSE
_local_communication_costing_enabled TRUE
_local_communication_ratio 50
_local_hang_analysis_interval_secs 3
_lock_sga_areas 0
_log_archive_avoid_memcpy TRUE
_log_archive_buffers 10
_log_archive_callout
_log_archive_network_redo_size 10
_log_archive_prot_auto_demote FALSE
_log_archive_security_enabled TRUE
_log_archive_strong_auth TRUE
_log_archive_trace_pids
_log_blocks_during_backup TRUE
_log_buffer_coalesce FALSE
_log_buffers_corrupt FALSE
_log_buffers_debug FALSE
_log_checkpoint_recovery_check 0
_log_committime_block_cleanout FALSE
_log_deletion_policy mandatory
_log_event_queues 0
_log_file_sync_timeout 10
_log_io_size 0
_log_max_optimize_threads 128
_log_parallelism_dynamic TRUE
_log_parallelism_max 2
_log_private_mul 5
_log_private_parallelism_mul 10
_log_read_buffer_size 8
_log_read_buffers 8
_log_simultaneous_copies 64
_log_space_errors TRUE
_log_switch_timeout 0
_logout_storm_rate 0
_logout_storm_retrycnt 600
_logout_storm_timeout 5
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_long_bcast_ack_warning_threshold 500
_long_log_write_warning_threshold 500
_longops_enabled TRUE
_low_server_threshold 0
_lowres_drift_allowed_sec 5
_ltc_trace 0
_main_dead_process_scan_interval 0
_master_direct_sends 31
_mav_refresh_consistent_read TRUE
_mav_refresh_double_count_prevented FALSE
_mav_refresh_opt 0
_mav_refresh_unionall_tables 3
_max_aq_persistent_queue_memory 10
_max_async_wait_for_catch_up 20
_max_cr_rollbacks 0
_max_exponential_sleep 0
_max_filestat_tries 10
_max_fsu_segments 4096
_max_fsu_stale_time 600
_max_io_size 1048576
_max_large_io 0
_max_largepage_alloc_time_secs 10
_max_lns_shutdown_archival_time 30
_max_pending_scn_bcasts 8
_max_protocol_support 10000
_max_reasonable_scn_rate 32768
_max_rwgs_groupings 8192
_max_services 150
_max_shrink_obj_stats 0
_max_sleep_holding_latch 4
_max_small_io 0
_max_spacebg_msgs_percentage 50
_max_spacebg_slaves 10
_max_spacebg_tasks 1000
_media_recovery_read_batch 32
_mem_annotation_pr_lev 0
_mem_annotation_scale 1
_mem_annotation_sh_lev 0
_mem_annotation_store FALSE
_mem_std_extent_size 4096
_memory_broker_log_stat_entries 5
_memory_broker_marginal_utility_bc 12
_memory_broker_marginal_utility_sp 7
_memory_broker_shrink_heaps 15
_memory_broker_shrink_java_heaps 900
_memory_broker_shrink_streams_pool 900
_memory_broker_shrink_timeout 60000000
_memory_broker_stat_interval 30
_memory_checkinuse_timeintv 30
_memory_imm_mode_without_autosga TRUE
_memory_initial_sga_split_perc 60
_memory_management_tracing 0
_memory_mgmt_fail_immreq FALSE
_memory_mgmt_immreq_timeout 150
_memory_nocancel_defsgareq FALSE
_memory_sanity_check 0
_messages 1000
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_mgd_rcv_handle_orphan_datafiles FALSE
_midtier_affinity_clusterwait_threshold 100
_midtier_affinity_goodness_threshold 2000
_minfree_plus 0
_minimal_stats_aggregation TRUE
_minimum_blocks_to_shrink 0
_minimum_db_flashback_retention 60
_minimum_extents_to_shrink 1
_minimum_giga_scn 0
_mirror_redo_buffers FALSE
_mmv_query_rewrite_enabled TRUE
_module_action_old_length TRUE
_mpmt_enabled FALSE
_multi_instance_pmr TRUE
_multi_join_key_table_lookup TRUE
_multiple_instance_recovery FALSE
_mutex_spin_count 255
_mutex_wait_scheme 2
_mutex_wait_time 1
_mv_generalized_oj_refresh_opt TRUE
_mv_refresh_ana 0
_mv_refresh_costing rule
_mv_refresh_delta_fraction 10
_mv_refresh_enhanced_dml_detection ON_RC
_mv_refresh_eut TRUE
_mv_refresh_force_parallel_query 0
_mv_refresh_new_setup_disabled FALSE
_mv_refresh_no_idx_rebuild FALSE
_mv_refresh_pkfk_data_units_opt auto
_mv_refresh_pkfk_relationship_opt TRUE
_mv_refresh_rebuild_percentage 10
_mv_refresh_selections TRUE
_mv_refresh_update_analysis TRUE
_mv_refresh_use_hash_sj TRUE
_mv_refresh_use_no_merge TRUE
_mv_refresh_use_stats FALSE
_mv_refsched_timeincr 300000
_mv_rolling_inv FALSE
_mwin_schedule TRUE
_nchar_imp_cnv TRUE
_nchar_imp_conv TRUE
_ncmb_readahead_enabled 0
_ncmb_readahead_tracing 0
_ncomp_shared_objects_dir
_nested_loop_fudge 100
_nested_mv_fast_oncommit_enabled TRUE
_new_initial_join_orders TRUE
_new_sort_cost_estimate TRUE
_newsort_enabled TRUE
_newsort_ordered_pct 63
_newsort_type 0
_nineteenth_spare_parameter
_ninth_spare_parameter
_nlj_batching_ae_flag 2
_nlj_batching_enabled 1
_nlj_batching_misses_enabled 1
_nls_parameter_sync_enabled TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_no_objects FALSE
_no_or_expansion FALSE
_no_recovery_through_resetlogs FALSE
_noseg_for_unusable_index_enabled TRUE
_notify_crs FALSE
_ns_max_flush_wt 1
_ns_max_send_delay 15
_num_longop_child_latches 32
_numa_buffer_cache_stats 0
_numa_trace_level 0
_number_cached_attributes 10
_number_cached_group_memberships 32
_obj_ckpt_tracing 0
_object_number_cache_size 5
_object_reuse_bast 2
_object_statistics TRUE
_object_stats_max_entries 3072
_offline_rollback_segments
_ogms_home
_olap_adv_comp_stats_cc_precomp 20
_olap_adv_comp_stats_max_rows 100000
_olap_aggregate_buffer_size 1048576
_olap_aggregate_flags 0
_olap_aggregate_function_cache_enabled TRUE
_olap_aggregate_max_thread_tuples 5000
_olap_aggregate_min_buffer_size 1024
_olap_aggregate_min_thread_status 64
_olap_aggregate_multipath_hier FALSE
_olap_aggregate_statlen_thresh 1024
_olap_aggregate_work_per_thread 1024
_olap_aggregate_worklist_max 5000
_olap_allocate_errorlog_format %8p %8y %8z %e (%n)
_olap_allocate_errorlog_header Dim Source Basis
%-8d %-8s %-8b Description
-------- -------- -------- -----------
_olap_analyze_max 10000
_olap_continuous_trace_file false
_olap_dbgoutfile_echo_to_eventlog FALSE
_olap_dimension_corehash_force FALSE
_olap_dimension_corehash_large 50000
_olap_dimension_corehash_pressure 90
_olap_dimension_corehash_size 30
_olap_eif_export_lob_size 2147483647
_olap_lmgen_dim_size 100
_olap_lmgen_meas_size 1000
_olap_object_hash_class 3
_olap_page_pool_expand_rate 20
_olap_page_pool_hi 50
_olap_page_pool_hit_target 100
_olap_page_pool_low 262144
_olap_page_pool_pressure 90
_olap_page_pool_shrink_rate 50
_olap_parallel_update_server_num 0
_olap_parallel_update_small_threshold 1000
_olap_parallel_update_threshold 1000
_olap_sesscache_enabled TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_olap_sort_buffer_pct 10
_olap_sort_buffer_size 262144
_olap_statbool_corebits 20000000
_olap_statbool_threshold 8100
_olap_table_function_statistics FALSE
_olap_wrap_errors FALSE
_olapi_history_retention FALSE
_olapi_iface_object_history 1000
_olapi_iface_object_history_retention FALSE
_olapi_iface_operation_history_retention FALSE
_olapi_interface_operation_history 1000
_olapi_memory_operation_history 1000
_olapi_memory_operation_history_pause_at_seqno 0
_olapi_memory_operation_history_retention FALSE
_olapi_session_history 300
_olapi_session_history_retention FALSE
_old_connect_by_enabled FALSE
_ols_cleanup_task TRUE
_oltp_compression TRUE
_oltp_compression_gain 10
_omf enabled
_oneside_colstat_for_equijoins TRUE
_online_patch_disable_stack_check FALSE
_ops_per_semop
_optim_adjust_for_part_skews TRUE
_optim_dict_stats_at_db_cr_upg TRUE
_optim_enhance_nnull_detection TRUE
_optim_new_default_join_sel TRUE
_optim_peek_user_binds TRUE
_optimizer_adaptive_cursor_sharing TRUE
_optimizer_adjust_for_nulls TRUE
_optimizer_autostats_job TRUE
_optimizer_aw_join_push_enabled TRUE
_optimizer_aw_stats_enabled TRUE
_optimizer_better_inlist_costing ALL
_optimizer_block_size 8192
_optimizer_cache_stats FALSE
_optimizer_cartesian_enabled TRUE
_optimizer_cbqt_factor 50
_optimizer_cbqt_no_size_restriction TRUE
_optimizer_ceil_cost TRUE
_optimizer_coalesce_subqueries TRUE
_optimizer_complex_pred_selectivity TRUE
_optimizer_compute_index_stats TRUE
_optimizer_connect_by_cb_whr_only FALSE
_optimizer_connect_by_combine_sw TRUE
_optimizer_connect_by_cost_based TRUE
_optimizer_connect_by_elim_dups TRUE
_optimizer_correct_sq_selectivity TRUE
_optimizer_cost_based_transformation LINEAR
_optimizer_cost_filter_pred FALSE
_optimizer_cost_hjsmj_multimatch TRUE
_optimizer_cost_model CHOOSE
_optimizer_degree 0
_optimizer_dim_subq_join_sel TRUE
_optimizer_disable_strans_sanity_checks 0
_optimizer_distinct_agg_transform TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_optimizer_distinct_elimination TRUE
_optimizer_distinct_placement TRUE
_optimizer_dyn_smp_blks 32
_optimizer_eliminate_filtering_join TRUE
_optimizer_enable_density_improvements TRUE
_optimizer_enable_extended_stats TRUE
_optimizer_enable_table_lookup_by_nl TRUE
_optimizer_enhanced_filter_push TRUE
_optimizer_extend_jppd_view_types TRUE
_optimizer_extended_cursor_sharing UDO
_optimizer_extended_cursor_sharing_rel SIMPLE
_optimizer_extended_stats_usage_control 192
_optimizer_false_filter_pred_pullup TRUE
_optimizer_fast_access_pred_analysis TRUE
_optimizer_fast_pred_transitivity TRUE
_optimizer_feedback_control
_optimizer_filter_pred_pullup TRUE
_optimizer_filter_pushdown TRUE
_optimizer_fkr_index_cost_bias 10
_optimizer_force_CBQT
_optimizer_free_transformation_heap TRUE
_optimizer_full_outer_join_to_outer TRUE
_optimizer_group_by_placement TRUE
_optimizer_ignore_hints FALSE
_optimizer_improve_selectivity TRUE
_optimizer_instance_count 0
_optimizer_interleave_jppd TRUE
_optimizer_invalidation_period 18000
_optimizer_join_elimination_enabled TRUE
_optimizer_join_factorization TRUE
_optimizer_join_order_control 3
_optimizer_join_sel_sanity_check TRUE
_optimizer_max_permutations 2000
_optimizer_min_cache_blocks 10
_optimizer_mjc_enabled TRUE
_optimizer_mode_force TRUE
_optimizer_multi_level_push_pred TRUE
_optimizer_multiple_cenv
_optimizer_multiple_cenv_report result
_optimizer_multiple_cenv_stmt query
_optimizer_native_full_outer_join FORCE
_optimizer_nested_rollup_for_gset 100
_optimizer_new_join_card_computation TRUE
_optimizer_null_aware_antijoin TRUE
_optimizer_or_expansion DEPTH
_optimizer_or_expansion_subheap TRUE
_optimizer_order_by_elimination_enabled TRUE
_optimizer_outer_join_to_inner TRUE
_optimizer_outer_to_anti_enabled TRUE
_optimizer_percent_parallel 101
_optimizer_purge_stats_iteration_row_count 10000
_optimizer_push_down_distinct 0
_optimizer_push_pred_cost_based TRUE
_optimizer_random_plan 0
_optimizer_reuse_cost_annotations TRUE
_optimizer_rownum_bind_default 10
_optimizer_rownum_pred_based_fkr TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_optimizer_save_stats TRUE
_optimizer_search_limit 5
_optimizer_self_induced_cache_cost FALSE
_optimizer_skip_scan_enabled TRUE
_optimizer_skip_scan_guess FALSE
_optimizer_sortmerge_join_enabled TRUE
_optimizer_sortmerge_join_inequality TRUE
_optimizer_squ_bottomup TRUE
_optimizer_star_tran_in_with_clause TRUE
_optimizer_star_trans_min_cost 0
_optimizer_star_trans_min_ratio 0
_optimizer_starplan_enabled TRUE
_optimizer_system_stats_usage TRUE
_optimizer_table_expansion TRUE
_optimizer_trace none
_optimizer_transitivity_retain TRUE
_optimizer_try_st_before_jppd TRUE
_optimizer_undo_changes FALSE
_optimizer_undo_cost_change 11.2.0.3
_optimizer_unnest_all_subqueries TRUE
_optimizer_unnest_corr_set_subq TRUE
_optimizer_unnest_disjunctive_subq TRUE
_optimizer_use_cbqt_star_transformation TRUE
_optimizer_use_feedback TRUE
_optimizer_use_subheap TRUE
_or_expand_nvl_predicate TRUE
_oradbg_pathname
_oradebug_cmds_at_startup
_oradebug_force FALSE
_ordered_nested_loop TRUE
_ordered_semijoin TRUE
_orph_cln_interval 1200
_os_sched_high_priority 1
_oss_skgxp_udp_dynamic_credit_mgmt 1
_other_wait_event_exclusion
_other_wait_threshold 0
_outline_bitmap_tree TRUE
_parallel_adaptive_max_users 4
_parallel_blackbox_enabled TRUE
_parallel_blackbox_size 16384
_parallel_broadcast_enabled TRUE
_parallel_cluster_cache_pct 80
_parallel_cluster_cache_policy ADAPTIVE
_parallel_conservative_queuing FALSE
_parallel_default_max_instances 1
_parallel_execution_message_align FALSE
_parallel_fake_class_pct 0
_parallel_fixwrite_bucket 1000
_parallel_heartbeat_snapshot_interval 2
_parallel_heartbeat_snapshot_max 128
_parallel_load_bal_unit 0
_parallel_load_balancing TRUE
_parallel_load_publish_threshold 10
_parallel_min_message_pool 8192000
_parallel_optimization_phase_for_local FALSE
_parallel_queuing_max_waitingtime
_parallel_recovery_stopat 32767
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_parallel_replay_msg_limit 4000
_parallel_scalability 50
_parallel_server_idle_time 30000
_parallel_server_sleep_time 10
_parallel_slave_acquisition_wait 1
_parallel_statement_queuing FALSE
_parallel_syspls_obey_force TRUE
_parallel_time_unit 10
_parallel_txn_global FALSE
_parallelism_cost_fudge_factor 350
_parameter_table_block_size 2048
_partial_pwise_join_enabled TRUE
_partition_large_extents TRUE
_partition_view_enabled TRUE
_passwordfile_enqueue_timeout 900
_pct_refresh_double_count_prevented TRUE
_pdml_gim_sampling 5000
_pdml_gim_staggered FALSE
_pdml_slaves_diff_part TRUE
_percent_flashback_buf_partial_full 50
_pga_large_extent_size 1048576
_pga_max_size 449617920
_pgactx_cap_stacks FALSE
_pivot_implementation_method CHOOSE
_pkt_enable FALSE
_pkt_pmon_interval 50
_pkt_start FALSE
_plan_outline_data TRUE
_plan_verify_improvement_margin 150
_plan_verify_local_time_limit 0
_plsql_anon_block_code_type INTERPRETED
_plsql_cache_enable TRUE
_plsql_dump_buffer_events
_plsql_max_stack_size 0
_plsql_minimum_cache_hit_percent 20
_plsql_native_frame_threshold 4294967294
_plsql_nvl_optimize FALSE
_pmon_dead_blkrs_alive_chk_rate_secs 3
_pmon_dead_blkrs_max_blkrs 200
_pmon_dead_blkrs_max_cleanup_attempts 5
_pmon_dead_blkrs_scan_rate_secs 3
_pmon_enable_dead_blkrs TRUE
_pmon_load_constants 300,192,64,3,10,10,0,0
_pmon_max_consec_posts 5
_post_wait_queues_dynamic_queues 40
_post_wait_queues_num_per_class
_pqq_debug_txn_act FALSE
_pqq_enabled TRUE
_pre_rewrite_push_pred TRUE
_precompute_gid_values TRUE
_pred_move_around TRUE
_predicate_elimination_enabled TRUE
_prescomm FALSE
_print_refresh_schedule false
_private_memory_address
_project_view_columns TRUE
_projection_pushdown TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_projection_pushdown_debug 0
_prop_old_enabled FALSE
_protect_frame_heaps FALSE
_ptn_cache_threshold 0
_push_join_predicate TRUE
_push_join_union_view TRUE
_push_join_union_view2 TRUE
_px_adaptive_offload_pecentage 0
_px_adaptive_offload_threshold 10
_px_async_getgranule FALSE
_px_bind_peek_sharing TRUE
_px_broadcast_fudge_factor 100
_px_buffer_ttl 30
_px_chunklist_count_ratio 8
_px_compilation_debug 0
_px_compilation_trace 0
_px_dump_12805_source TRUE
_px_dynamic_opt TRUE
_px_dynamic_sample_size 50
_px_execution_services_enabled TRUE
_px_freelist_latch_divisor 2
_px_gim_factor 100
_px_granule_batch_size 10
_px_granule_randomize TRUE
_px_granule_size 1000000
_px_hold_time 0
_px_index_sampling 200
_px_index_sampling_objsize TRUE
_px_io_process_bandwidth 200
_px_io_system_bandwidth 0
_px_kxib_tracing 0
_px_load_factor 300
_px_load_publish_interval 200
_px_loc_msg_cost 1000
_px_max_granules_per_slave 100
_px_max_map_val 32
_px_max_message_pool_pct 40
_px_min_granules_per_slave 13
_px_minus_intersect TRUE
_px_net_msg_cost 10000
_px_no_granule_sort FALSE
_px_no_stealing FALSE
_px_nss_planb TRUE
_px_numa_stealing_enabled TRUE
_px_numa_support_enabled TRUE
_px_partition_scan_enabled TRUE
_px_partition_scan_threshold 64
_px_proc_constrain TRUE
_px_pwg_enabled TRUE
_px_round_robin_rowcnt 1000
_px_rownum_pd TRUE
_px_send_timeout 300
_px_slaves_share_cursors 0
_px_trace none
_px_ual_serial_input TRUE
_px_xtgranule_size 10000
_qa_control 0
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_qa_lrg_type 0
_query_cost_rewrite TRUE
_query_execution_cache_max_size 131072
_query_mmvrewrite_maxcmaps 20
_query_mmvrewrite_maxdmaps 10
_query_mmvrewrite_maxinlists 5
_query_mmvrewrite_maxintervals 5
_query_mmvrewrite_maxpreds 10
_query_mmvrewrite_maxqryinlistvals 500
_query_mmvrewrite_maxregperm 512
_query_on_physical TRUE
_query_rewrite_1 TRUE
_query_rewrite_2 TRUE
_query_rewrite_drj TRUE
_query_rewrite_expression TRUE
_query_rewrite_fpc TRUE
_query_rewrite_fudge 90
_query_rewrite_jgmigrate TRUE
_query_rewrite_maxdisjunct 257
_query_rewrite_or_error FALSE
_query_rewrite_setopgrw_enable TRUE
_query_rewrite_vop_cleanup TRUE
_queue_buffer_max_dump_len 65536
_rbr_ckpt_tracing 0
_rcfg_disable_verify TRUE
_rcfg_parallel_fixwrite TRUE
_rcfg_parallel_replay TRUE
_rcfg_parallel_verify TRUE
_rdbms_compatibility 10.1
_rdbms_internal_fplib_enabled FALSE
_rdbms_internal_fplib_raise_errors FALSE
_read_only_violation_dump_to_trace FALSE
_read_only_violation_max_count 500
_read_only_violation_max_count_per_module 100
_readable_standby_sync_timeout 10
_real_time_apply_sim 0
_realfree_heap_max_size 32768
_realfree_heap_mode 0
_realfree_heap_pagesize_hint 65536
_reasonable_scn_offset_seconds 0
_recoverable_recovery_batch_percent 50
_recovery_asserts FALSE
_recovery_percentage 50
_recovery_read_limit 1024
_recovery_skip_cfseq_check FALSE
_recovery_verify_writes FALSE
_recursive_imu_transactions FALSE
_recursive_with_max_recursion_level 0
_redo_compatibility_check FALSE
_redo_read_from_memory TRUE
_redo_transport_compress_all TRUE
_redo_transport_sanity_check 0
_redo_transport_stall_time 360
_redo_transport_stall_time_long 3600
_redo_transport_stream_test TRUE
_redo_transport_stream_writes TRUE
_redo_transport_vio_size_req 4294967294
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_reduce_sby_log_scan TRUE
_release_insert_threshold 5
_reliable_block_sends TRUE
_relocation_commit_batch_size 8
_remove_aggr_subquery TRUE
_rep_base_path
_replace_virtual_columns TRUE
_reset_maxcap_history 10
_resource_manager_always_off FALSE
_resource_manager_always_on TRUE
_resource_manager_plan
_restore_maxopenfiles 8
_restore_spfile
_result_cache_auto_dml_monitoring_duration 15
_result_cache_auto_dml_monitoring_slots 4
_result_cache_auto_dml_threshold 16
_result_cache_auto_dml_trend_threshold 20
_result_cache_auto_execution_threshold 1
_result_cache_auto_size_threshold 100
_result_cache_auto_time_distance 300
_result_cache_auto_time_threshold 1000
_result_cache_block_size 1024
_result_cache_copy_block_count 1
_result_cache_global TRUE
_result_cache_timeout 10
_reuse_index_loop 5
_right_outer_hash_enable TRUE
_rm_cluster_interconnects
_rm_numa_sched_enable FALSE
_rm_numa_simulation_cpus 0
_rm_numa_simulation_pgs 0
_rman_io_priority 3
_rman_restore_through_link FALSE
_rollback_segment_count 0
_rollback_segment_initial 1
_rollback_stopat 0
_row_cache_cursors 20
_row_cr TRUE
_row_locking always
_row_shipping_explain FALSE
_row_shipping_threshold 80
_rowsource_execution_statistics FALSE
_rowsource_profiling_statistics TRUE
_rowsource_statistics_sampfreq 128
_rowsrc_trace_level 0
_rta_sync_wait_timeout 10
_rtc_infeasible_threshold 25
_sample_rows_per_block 4
_scatter_gcs_resources FALSE
_scatter_gcs_shadows FALSE
_sched_delay_max_samples 4
_sched_delay_measurement_sleep_us 1000
_sched_delay_os_tick_granularity_us 16000
_sched_delay_sample_collection_thresh_ms 200
_sched_delay_sample_interval_ms 1000
_scn_wait_interface_max_backoff_time_secs 600
_scn_wait_interface_max_timeout_secs 2147483647
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_sdiag_crash NONE
_sec_enable_test_rpcs FALSE
_second_spare_parameter
_securefile_timers FALSE
_securefiles_bulkinsert FALSE
_securefiles_concurrency_estimate 12
_securefiles_fg_retry 100
_securefiles_forceflush FALSE
_securefiles_memory_percentofSGA 20
_select_any_dictionary_security_enabled FALSE
_selectivity_for_srf_enabled FALSE
_selfjoin_mv_duplicates TRUE
_selftune_checkpoint_write_pct 3
_selftune_checkpointing_lag 300
_sem_per_semid
_send_ast_to_foreground AUTO
_send_close_with_block TRUE
_send_requests_to_pi TRUE
_serial_direct_read auto
_serial_recovery FALSE
_serializable FALSE
_serialize_lgwr_sync_io FALSE
_service_cleanup_timeout 30
_session_allocation_latches 32
_session_cached_instantiations 60
_session_context_size 10000
_session_idle_bit_latches 0
_session_page_extent 2048
_session_wait_history 10
_set_mgd_recovery_state 0
_seventeenth_spare_parameter
_seventh_spare_parameter
_sga_clear_dump FALSE
_sga_early_trace 0
_sga_locking none
_shared_io_pool_buf_size 1048576
_shared_io_pool_debug_trc 0
_shared_io_pool_size 0
_shared_io_set_value FALSE
_shared_iop_max_size 536870912
_shared_pool_max_size 0
_shared_pool_minsize_on FALSE
_shared_pool_reserved_min_alloc 4400
_shared_pool_reserved_pct 5
_shared_server_load_balance 0
_shared_server_num_queues 3
_shmprotect 0
_short_stack_timeout_ms 30000
_show_mgd_recovery_state FALSE
_shrunk_aggs_disable_threshold 60
_shrunk_aggs_enabled TRUE
_shutdown_completion_timeout_mins 60
_side_channel_batch_size 200
_side_channel_batch_timeout 6
_side_channel_batch_timeout_ms 500
_simple_view_merging TRUE
_simulate_disk_sectorsize 0
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_simulate_io_wait 0
_simulate_mem_transfer FALSE
_simulator_bucket_mindelta 8192
_simulator_internal_bound 10
_simulator_lru_rebalance_sizthr 5
_simulator_lru_rebalance_thresh 10240
_simulator_lru_scan_count 8
_simulator_pin_inval_maxcnt 16
_simulator_reserved_heap_count 4096
_simulator_reserved_obj_count 1024
_simulator_sampling_factor 2
_simulator_upper_bound_multiple 2
_single_process FALSE
_siop_flashback_scandepth 20
_siop_perc_of_bc_x100 2500
_sixteenth_spare_parameter
_sixth_spare_parameter
_skgxp_ctx_flags1 0
_skgxp_ctx_flags1mask 0
_skgxp_dynamic_protocol 0
_skgxp_gen_ant_off_rpc_timeout_in_sec 30
_skgxp_gen_ant_ping_misscount 3
_skgxp_gen_rpc_no_path_check_in_sec 5
_skgxp_gen_rpc_timeout_in_sec 300
_skgxp_inets
_skgxp_min_rpc_rcv_zcpy_len 0
_skgxp_min_zcpy_len 0
_skgxp_reaping 1000
_skgxp_rgn_ports 0
_skgxp_spare_param1
_skgxp_spare_param2
_skgxp_spare_param3
_skgxp_spare_param4
_skgxp_spare_param5
_skgxp_udp_ach_reaping_time 120
_skgxp_udp_ack_delay 0
_skgxp_udp_enable_dynamic_credit_mgmt 0
_skgxp_udp_hiwat_warn 1000
_skgxp_udp_interface_detection_time_secs 60
_skgxp_udp_keep_alive_ping_timer_secs 300
_skgxp_udp_lmp_mtusize 0
_skgxp_udp_lmp_on FALSE
_skgxp_udp_timed_wait_buffering 1024
_skgxp_udp_timed_wait_seconds 5
_skgxp_udp_use_tcb TRUE
_skgxp_zcpy_flags 0
_skgxpg_last_parameter 26
_skip_assume_msg TRUE
_skip_trstamp_check FALSE
_slave_mapping_enabled TRUE
_slave_mapping_group_size 0
_slave_mapping_skew_ratio 2
_small_table_threshold 7213
_smm_advice_enabled TRUE
_smm_advice_log_size 0
_smm_auto_cost_enabled TRUE
_smm_auto_max_io_size 248
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_smm_auto_min_io_size 56
_smm_bound 0
_smm_control 0
_smm_freeable_retain 5120
_smm_isort_cap 102400
_smm_max_size 219540
_smm_min_size 1024
_smm_px_max_size 1097728
_smm_retain_size 0
_smm_trace 0
_smon_internal_errlimit 100
_smon_undo_seg_rescan_limit 10
_smu_debug_mode 0
_smu_error_simulation_site 0
_smu_error_simulation_type 0
_smu_timeouts
_sort_elimination_cost_ratio 0
_sort_multiblock_read_count 2
_sort_spill_threshold 0
_space_align_size 1048576
_spare_test_parameter 0
_spawn_diag_opts 0
_spawn_diag_thresh_secs 30
_spin_count 2000
_spr_max_rules 10000
_spr_push_pred_refspr TRUE
_spr_use_AW_AS TRUE
_spr_use_hash_table FALSE
_sql_analyze_enable_auto_txn FALSE
_sql_analyze_parse_model 2
_sql_compatibility 0
_sql_connect_capability_override 0
_sql_connect_capability_table
_sql_hash_debug 0
_sql_model_unfold_forloops RUN_TIME
_sql_ncg_mode OFF
_sql_plan_management_control 0
_sqlexec_progression_cost 1000
_sqlmon_binds_xml_format default
_sqlmon_max_plan 640
_sqlmon_max_planlines 300
_sqlmon_recycle_time 60
_sqlmon_threshold 5
_sqltune_category_parsed DEFAULT
_srvntfn_job_deq_timeout 60
_srvntfn_jobsubmit_interval 3
_srvntfn_max_concurrent_jobs 20
_srvntfn_q_msgcount 50
_srvntfn_q_msgcount_inc 100
_sscr_dir
_sscr_osdir
_sta_control 0
_stack_guard_level 0
_standby_causal_heartbeat_timeout 2
_standby_flush_mode SLFLUSH
_standby_implicit_rcv_timeout 1
_standby_switchover_timeout 120
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_static_backgrounds
_statistics_based_srf_enabled TRUE
_step_down_limit_in_pct 1
_streams_pool_max_size 0
_subquery_pruning_cost_factor 20
_subquery_pruning_enabled TRUE
_subquery_pruning_mv_enabled FALSE
_subquery_pruning_reduction 50
_switchover_to_standby_option OPEN_ONE
_switchover_to_standby_switch_log TRUE
_swrf_metric_frequent_mode FALSE
_swrf_mmon_dbfus TRUE
_swrf_mmon_flush TRUE
_swrf_mmon_metrics TRUE
_swrf_on_disk_enabled TRUE
_swrf_test_action 0
_swrf_test_dbfus FALSE
_sync_primary_wait_time 5
_synonym_repoint_tracing FALSE
_sysaux_test_param 1
_system_api_interception_debug FALSE
_system_index_caching 0
_system_trig_enabled TRUE
_ta_lns_wait_for_arch_log 20
_table_lookup_prefetch_size 40
_table_lookup_prefetch_thresh 2
_table_scan_cost_plus_one TRUE
_tablespaces_per_transaction 10
_target_rba_max_lag_percentage 81
_tdb_debug_mode 16
_temp_tran_block_threshold 100
_temp_tran_cache TRUE
_tenth_spare_parameter
_test_ksusigskip 5
_test_param_1 25
_test_param_2
_test_param_3
_test_param_4
_test_param_5 25
_test_param_6 0
_third_spare_parameter
_thirteenth_spare_parameter
_threshold_alerts_enable 1
_timemodel_collection TRUE
_timeout_actions_enabled TRUE
_timer_precision 10
_total_large_extent_memory 0
_tq_dump_period 0
_trace_buffer_wait_timeouts 0
_trace_buffers ALL:256
_trace_dump_all_procs FALSE
_trace_dump_client_buckets TRUE
_trace_dump_cur_proc_only FALSE
_trace_dump_static_only FALSE
_trace_events
_trace_files_public FALSE
_trace_kqlidp FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_trace_navigation_scope global
_trace_pin_time 0
_trace_pool_size
_trace_processes ALL
_trace_virtual_columns FALSE
_transaction_auditing TRUE
_transaction_recovery_servers 0
_transient_logical_clear_hold_mrp_bit FALSE
_truncate_optimization_enabled TRUE
_tsenc_tracing 0
_tsm_connect_string
_tsm_disable_auto_cleanup 1
_tstz_localtime_bypass FALSE
_tts_allow_charset_mismatch FALSE
_twelfth_spare_parameter
_twentieth_spare_parameter
_two_pass TRUE
_two_pass_reverse_polish_enabled TRUE
_uga_cga_large_extent_size 262144
_ultrafast_latch_statistics TRUE
_undo_autotune TRUE
_undo_block_compression TRUE
_undo_debug_mode 0
_undo_debug_usage 0
_union_rewrite_for_gs YES_GSET_MVS
_unnest_subquery TRUE
_unused_block_compression TRUE
_update_datafile_headers_with_space_information FALSE
_use_adaptive_log_file_sync TRUE
_use_best_fit FALSE
_use_column_stats_for_function TRUE
_use_hybrid_encryption_mode FALSE
_use_ism TRUE
_use_ism_for_pga TRUE
_use_nosegment_indexes FALSE
_use_platform_compression_lib FALSE
_use_platform_encryption_lib TRUE
_use_realfree_heap TRUE
_use_seq_process_cache TRUE
_use_vector_post TRUE
_use_zero_copy_io TRUE
_validate_flashback_database FALSE
_validate_readmem_redo OFF
_vendor_lib_loc
_verify_fg_log_checksum FALSE
_verify_flashback_redo TRUE
_verify_undo_quota FALSE
_very_large_object_threshold 500
_very_large_partitioned_table 1024
_virtual_column_overload_allowed TRUE
_vkrm_schedule_interval 10
_vktm_assert_thresh 30
_wait_breakup_threshold_csecs 600
_wait_breakup_time_csecs 300
_wait_for_sync TRUE
_wait_samples_max_sections 40
_wait_samples_max_time_secs 120
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_wait_tracker_interval_secs 10
_wait_tracker_num_intervals 0
_wait_yield_hp_mode yield
_wait_yield_mode yield
_wait_yield_sleep_freq 100
_wait_yield_sleep_time_msecs 1
_wait_yield_yield_freq 20
_walk_insert_threshold 0
_watchpoint_on FALSE
_wcr_control 0
_windowfunc_optimization_settings 0
_with_subquery OPTIMIZER
_write_clones 3
_xengem_devname DEFAULT
_xengem_diagmode OFF
_xengem_enabled TRUE
_xpl_peeked_binds_log_size 8192
_xpl_trace 0
_xsolapi_auto_materialization_bound 20
_xsolapi_auto_materialization_type PRED_AND_RC
_xsolapi_build_trace FALSE
_xsolapi_debug_output SUPPRESS
_xsolapi_densify_cubes TABULAR
_xsolapi_dimension_group_creation OVERFETCH
_xsolapi_dml_trace
_xsolapi_fetch_type PARTIAL
_xsolapi_fix_vptrs TRUE
_xsolapi_generate_with_clause FALSE
_xsolapi_hierarchy_value_type unique
_xsolapi_load_at_process_start NEVER
_xsolapi_materialization_rowcache_min_rows_for_use 1
_xsolapi_materialize_sources TRUE
_xsolapi_metadata_reader_mode DEFAULT
_xsolapi_odbo_mode FALSE
_xsolapi_opt_aw_position TRUE
_xsolapi_optimize_suppression TRUE
_xsolapi_precompute_subquery TRUE
_xsolapi_remove_columns_for_materialization TRUE
_xsolapi_set_nls TRUE
_xsolapi_share_executors TRUE
_xsolapi_source_trace FALSE
_xsolapi_sql_all_multi_join_non_base_hints
_xsolapi_sql_all_non_base_hints
_xsolapi_sql_auto_dimension_hints FALSE
_xsolapi_sql_auto_measure_hints TRUE
_xsolapi_sql_dimension_hints
_xsolapi_sql_enable_aw_join TRUE
_xsolapi_sql_enable_aw_qdr_merge TRUE
_xsolapi_sql_hints
_xsolapi_sql_measure_hints
_xsolapi_sql_minus_threshold 1000
_xsolapi_sql_optimize TRUE
_xsolapi_sql_prepare_stmt_cache_size 16
_xsolapi_sql_remove_columns TRUE
_xsolapi_sql_result_set_cache_size 32
_xsolapi_sql_symmetric_predicate TRUE
_xsolapi_sql_top_dimension_hints
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_xsolapi_sql_top_measure_hints
_xsolapi_sql_use_bind_variables TRUE
_xsolapi_stringify_order_levels FALSE
_xsolapi_support_mtm FALSE
_xsolapi_suppression_aw_mask_threshold 1000
_xsolapi_suppression_chunk_size 4000
_xsolapi_use_models TRUE
_xsolapi_use_olap_dml TRUE
_xsolapi_use_olap_dml_for_rank TRUE
_xt_coverage none
_xt_trace none
_xtbuffer_size 0
_xtts_allow_pre10 FALSE
_xtts_set_platform_info FALSE
2405 rows selected.
SQL>
=============================
[oracle@dev ~]$ sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 16 13:17:48 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL> SET PAGESIZE 60
SET LINESIZE 300
COLUMN ksppinm FORMAT A50
COLUMN ksppstvl FORMAT A50
SELECT
ksppinm,
ksppstvl
FROM
x$ksppi a,
x$ksppsv b
WHERE a.indx=b.indx AND substr(ksppinm,1,1) = '_'
ORDER BY ksppinm;
/
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_4030_dump_bitvec 4095
_4031_dump_bitvec 67194879
_4031_dump_interval 300
_4031_max_dumps 100
_4031_sga_dump_interval 3600
_4031_sga_max_dumps 10
_NUMA_instance_mapping Not specified
_NUMA_pool_size Not specified
_PX_use_large_pool FALSE
__db_cache_size 1526726656
__dg_broker_service_names
__java_pool_size 16777216
__large_pool_size 100663296
__oracle_base /u01/app/oracle
__pga_aggregate_target 2248146944
__sga_target 4194304000
__shared_io_pool_size 0
__shared_pool_size 2499805184
__streams_pool_size 0
_abort_recovery_on_join FALSE
_accept_versions
_active_instance_count
_active_session_idle_limit 5
_active_session_legacy_behavior FALSE
_active_standby_fast_reconfiguration TRUE
_adaptive_direct_read TRUE
_adaptive_direct_write TRUE
_adaptive_fetch_enabled TRUE
_adaptive_log_file_sync_high_switch_freq_threshold 3
_adaptive_log_file_sync_poll_aggressiveness 0
_adaptive_log_file_sync_sched_delay_window 60
_adaptive_log_file_sync_use_polling_threshold 200
_adaptive_log_file_sync_use_postwait_threshold 50
_add_col_optim_enabled TRUE
_add_stale_mv_to_dependency_list TRUE
_add_trim_for_nlssort TRUE
_addm_auto_enable TRUE
_addm_skiprules
_addm_version_check TRUE
_adjust_literal_replacement FALSE
_adr_migrate_runonce TRUE
_affinity_on TRUE
_aged_out_cursor_cache_time 300
_aggregation_optimization_settings 0
_aiowait_timeouts 100
_alert_expiration 604800
_alert_message_cleanup 1
_alert_message_purge 1
_alert_post_background 1
_all_shared_dblinks
_allocate_creation_order FALSE
_allocation_update_interval 3
_allow_cell_smart_scan_attr TRUE
_allow_commutativity TRUE
_allow_compatibility_adv_w_grp FALSE
_allow_drop_snapshot_standby_grsp FALSE
_allow_drop_ts_with_grp FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_allow_error_simulation FALSE
_allow_level_without_connect_by FALSE
_allow_read_only_corruption FALSE
_allow_resetlogs_corruption FALSE
_allow_terminal_recovery_corruption FALSE
_alternate_iot_leaf_block_split_points TRUE
_always_anti_join CHOOSE
_always_semi_join CHOOSE
_always_star_transformation FALSE
_and_pruning_enabled TRUE
_app_ctx_vers FALSE
_appqos_qt 10
_aq_max_scan_delay 1500
_aq_tm_deqcountinterval 0
_aq_tm_scanlimit 0
_aq_tm_statistics_duration 0
_arch_comp_dbg_scan 0
_arch_comp_dec_block_check_dump 1
_arch_compress_checksums FALSE
_arch_compression TRUE
_arch_io_slaves 0
_arch_sim_mode 0
_array_update_vector_read_enabled FALSE
_ash_compression_enable TRUE
_ash_disk_filter_ratio 10
_ash_disk_write_enable TRUE
_ash_dummy_test_param 0
_ash_eflush_trigger 66
_ash_enable TRUE
_ash_min_mmnl_dump 90
_ash_sample_all FALSE
_ash_sampling_interval 1000
_ash_size 1048618
_asm_acd_chunks 1
_asm_admin_with_sysdba FALSE
_asm_allow_appliance_dropdisk_noforce FALSE
_asm_allow_lvm_resilvering TRUE
_asm_allow_only_raw_disks TRUE
_asm_allow_system_alias_rename FALSE
_asm_appliance_config_file
_asm_ausize 1048576
_asm_automatic_rezone TRUE
_asm_avoid_pst_scans TRUE
_asm_blksize 4096
_asm_check_for_misbehaving_cf_clients FALSE
_asm_compatibility 10.1
_asm_dba_batch 500000
_asm_dba_threshold 0
_asm_dbmsdg_nohdrchk FALSE
_asm_diag_dead_clients FALSE
_asm_direct_con_expire_time 120
_asm_disable_amdu_dump FALSE
_asm_disable_async_msgs FALSE
_asm_disable_multiple_instance_check FALSE
_asm_disable_profilediscovery FALSE
_asm_disable_smr_creation FALSE
_asm_disk_repair_time 14400
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_asm_emulate_nfs_disk FALSE
_asm_emulmax 10000
_asm_emultimeout 0
_asm_evenread 0
_asm_evenread_alpha 0
_asm_evenread_alpha2 0
_asm_evenread_faststart 0
_asm_fail_random_rx FALSE
_asm_fob_tac_frequency 9
_asm_force_quiesce FALSE
_asm_hbeatiowait 15
_asm_hbeatwaitquantum 2
_asm_imbalance_tolerance 3
_asm_instlock_quota 0
_asm_iostat_latch_count 31
_asm_kfdpevent 0
_asm_kfioevent 0
_asm_kill_unresponsive_clients TRUE
_asm_libraries ufs
_asm_log_scale_rebalance FALSE
_asm_lsod_bucket_size 13
_asm_max_cod_strides 5
_asm_max_redo_buffer_size 2097152
_asm_maxio 1048576
_asm_partner_target_disk_part 8
_asm_partner_target_fg_rel 4
_asm_primary_load 1
_asm_primary_load_cycles TRUE
_asm_random_zone FALSE
_asm_rebalance_plan_size 120
_asm_rebalance_space_errors 4
_asm_repairquantum 60
_asm_reserve_slaves TRUE
_asm_root_directory ASM
_asm_runtime_capability_volume_support FALSE
_asm_secondary_load 10000
_asm_secondary_load_cycles FALSE
_asm_serialize_volume_rebalance FALSE
_asm_shadow_cycle 3
_asm_skip_rename_check FALSE
_asm_skip_resize_check FALSE
_asm_storagemaysplit FALSE
_asm_stripesize 131072
_asm_stripewidth 8
_asm_sync_rebalance FALSE
_asm_usd_batch 64
_asm_wait_time 18
_asmlib_test 0
_asmsid asm
_assm_default TRUE
_assm_force_fetchmeta FALSE
_assm_high_gsp_threshold 11024
_assm_low_gsp_threshold 10000
_async_recovery_claims TRUE
_async_recovery_reads TRUE
_async_ts_threshold 1
_auto_assign_cg_for_sessions FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_auto_bmr enabled
_auto_bmr_bg_time 3600
_auto_bmr_fc_time 60
_auto_bmr_pub_timeout 10
_auto_bmr_req_timeout 60
_auto_bmr_sess_threshold 30
_auto_bmr_sys_threshold 100
_auto_manage_enable_offline_check TRUE
_auto_manage_exadata_disks TRUE
_auto_manage_infreq_tout 0
_auto_manage_ioctl_bufsz 8192
_auto_manage_max_online_tries 3
_auto_manage_num_pipe_msgs 1000
_auto_manage_num_tries 2
_auto_manage_online_tries_expire_time 86400
_automatic_maintenance_test 0
_automemory_broker_interval 3
_autotask_max_window 480
_autotask_min_window 15
_autotune_gtx_idle_time 600
_autotune_gtx_interval 5
_autotune_gtx_threshold 60
_available_core_count 0
_avoid_prepare TRUE
_awr_corrupt_mode FALSE
_awr_disabled_flush_tables
_awr_flush_threshold_metrics TRUE
_awr_flush_workload_metrics FALSE
_awr_mmon_cpuusage TRUE
_awr_mmon_deep_purge_extent 7
_awr_mmon_deep_purge_interval 7
_awr_mmon_deep_purge_numrows 5000
_awr_restrict_mode FALSE
_awr_sql_child_limit 200
_b_tree_bitmap_plans TRUE
_backup_align_write_io TRUE
_backup_automatic_retry 10
_backup_disk_bufcnt 0
_backup_disk_bufsz 0
_backup_disk_io_slaves 0
_backup_dynamic_buffers TRUE
_backup_encrypt_opt_mode 4294967294
_backup_file_bufcnt 0
_backup_file_bufsz 0
_backup_io_pool_size 1048576
_backup_kgc_blksiz 9
_backup_kgc_bufsz 0
_backup_kgc_memlevel 8
_backup_kgc_niters 0
_backup_kgc_perflevel 1
_backup_kgc_scheme ZLIB
_backup_kgc_type 0
_backup_kgc_windowbits 15
_backup_ksfq_bufcnt 0
_backup_ksfq_bufcnt_max 64
_backup_ksfq_bufsz 0
_backup_lzo_size 262144
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_backup_max_gap_size 4294967294
_backup_seq_bufcnt 0
_backup_seq_bufsz 0
_bct_bitmaps_per_file 8
_bct_buffer_allocation_max 104857600
_bct_buffer_allocation_min_extents 1
_bct_buffer_allocation_size 2097152
_bct_chunk_size 0
_bct_crash_reserve_size 262144
_bct_file_block_size 0
_bct_file_extent_size 0
_bct_fixtab_file
_bct_health_check_interval 60
_bct_initial_private_dba_buffer_size 0
_bct_public_dba_buffer_size 0
_bitmap_or_improvement_enabled TRUE
_block_sample_readahead_prob_threshold 10
_blocking_sess_graph_cache_size
_blocks_per_cache_server 32
_bloom_filter_debug 0
_bloom_filter_enabled TRUE
_bloom_folding_density 16
_bloom_folding_enabled TRUE
_bloom_folding_min 131072
_bloom_max_size 268435456
_bloom_minmax_enabled TRUE
_bloom_predicate_enabled TRUE
_bloom_predicate_pushdown_to_storage TRUE
_bloom_pruning_enabled TRUE
_bloom_pushing_max 512
_bloom_pushing_total_max 262144
_bloom_vector_elements 0
_bmr_prefered_standby
_branch_tagging TRUE
_broadcast_scn_wait_timeout 10
_bsln_adaptive_thresholds_enabled TRUE
_bt_mmv_query_rewrite_enabled TRUE
_buffer_busy_wait_timeout 100
_buffered_message_spill_age 300
_buffered_publisher_flow_control_threshold 0
_bufq_stop_flow_control FALSE
_build_deferred_mv_skipping_mvlog_update TRUE
_bump_highwater_mark_count 0
_bwr_for_flushed_pi TRUE
_bypass_srl_for_so_eor FALSE
_bypass_xplatform_error FALSE
_cache_stats_monitor FALSE
_capture_buffer_size 65536
_capture_publisher_flow_control_threshold 0
_case_sensitive_logon TRUE
_causal_standby_wait_timeout 20
_cdc_subscription_owner
_cdmp_diagnostic_level 2
_cell_fast_file_create TRUE
_cell_fast_file_restore TRUE
_cell_file_format_chunk_size 0
_cell_index_scan_enabled TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_cell_offload_capabilities_enabled 1
_cell_offload_hybridcolumnar TRUE
_cell_offload_predicate_reordering_enabled FALSE
_cell_offload_timezone TRUE
_cell_offload_virtual_columns TRUE
_cell_range_scan_enabled TRUE
_cell_storidx_mode EVA
_cgs_allgroup_poll_time 20000
_cgs_dball_group_registration local
_cgs_dbgroup_poll_time 600
_cgs_health_check_in_reconfig TRUE
_cgs_node_kill_escalation TRUE
_cgs_node_kill_escalation_wait 0
_cgs_reconfig_extra_wait 3
_cgs_reconfig_timeout 0
_cgs_send_timeout 300
_cgs_tickets 1000
_cgs_zombie_member_kill_wait 20
_change_vector_buffers 1
_check_block_after_checksum TRUE
_check_block_new_invariant_for_flashback FALSE
_check_column_length TRUE
_check_ts_threshold 0
_cleanup_rollback_entries 100
_cleanup_timeout 150
_cleanup_timeout_flags 2
_clear_buffer_before_reuse FALSE
_client_ntfn_cleanup_interval 2400
_client_ntfn_pinginterval 75
_client_ntfn_pingretries 6
_client_ntfn_pingtimeout 30000
_client_result_cache_bypass FALSE
_client_tstz_error_check TRUE
_close_cached_open_cursors FALSE
_close_deq_by_cond_curs FALSE
_cluster_library clss
_clusterwide_global_transactions TRUE
_collapse_wait_history FALSE
_collect_undo_stats TRUE
_column_compression_factor 0
_column_elimination_off FALSE
_column_tracking_level 1
_compilation_call_heap_extent_size 16384
_complex_view_merging TRUE
_compression_above_cache 0
_compression_advisor 0
_compression_chain 90
_compression_compatibility 11.2.0.0.0
_connect_by_use_union_all TRUE
_connection_broker_host
_controlfile_autobackup_delay 300
_controlfile_backup_copy_check TRUE
_controlfile_block_size 0
_controlfile_enqueue_dump FALSE
_controlfile_enqueue_holding_time 120
_controlfile_enqueue_holding_time_tracking_size 10
_controlfile_enqueue_timeout 900
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_controlfile_section_init_size
_controlfile_section_max_expand
_controlfile_update_check OFF
_convert_set_to_join FALSE
_coord_message_buffer 0
_corrupted_rollback_segments
_cost_equality_semi_join TRUE
_cp_num_hash_latches 1
_cpu_to_io 0
_cr_grant_global_role TRUE
_cr_grant_local_role AUTO
_cr_grant_only FALSE
_cr_server_log_flush TRUE
_cr_trc_buf_size 8192
_create_table_in_any_cluster FALSE
_cursor_bind_capture_area_size 400
_cursor_bind_capture_interval 900
_cursor_cache_time 900
_cursor_db_buffers_pinned 719
_cursor_features_enabled 2
_cursor_obsolete_threshold 100
_cursor_plan_enabled TRUE
_cursor_plan_hash_version 1
_cursor_plan_unparse_enabled TRUE
_cursor_runtimeheap_memlimit 5242880
_cursor_stats_enabled TRUE
_cvw_enable_weak_checking TRUE
_datafile_cow FALSE
_datafile_write_errors_crash_instance TRUE
_db_16k_flash_cache_file
_db_16k_flash_cache_size 0
_db_2k_flash_cache_file
_db_2k_flash_cache_size 0
_db_32k_flash_cache_file
_db_32k_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_aging_cool_count 1
_db_aging_freeze_cr FALSE
_db_aging_hot_criteria 2
_db_aging_stay_count 0
_db_aging_touch_time 3
_db_always_check_system_ts TRUE
_db_block_adjcheck TRUE
_db_block_adjchk_level 0
_db_block_align_direct_read TRUE
_db_block_bad_write_check FALSE
_db_block_buffers 360693
_db_block_cache_clone FALSE
_db_block_cache_history 0
_db_block_cache_history_level 2
_db_block_cache_num_umap 0
_db_block_cache_protect FALSE
_db_block_cache_protect_internal 0
_db_block_check_for_debug FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_db_block_check_objtyp TRUE
_db_block_chunkify_ncmbr FALSE
_db_block_corruption_recovery_threshold 5
_db_block_do_full_mbreads FALSE
_db_block_hash_buckets 1048576
_db_block_hash_latches 32768
_db_block_header_guard_level 0
_db_block_hi_priority_batch_size 0
_db_block_known_clean_pct 2
_db_block_lru_latches 256
_db_block_max_cr_dba 6
_db_block_max_scan_pct 40
_db_block_med_priority_batch_size 0
_db_block_numa 1
_db_block_prefetch_fast_longjumps_enabled TRUE
_db_block_prefetch_limit 0
_db_block_prefetch_override 0
_db_block_prefetch_private_cache_enabled TRUE
_db_block_prefetch_quota 10
_db_block_prefetch_skip_reading_enabled TRUE
_db_block_table_scan_buffer_size 4194304
_db_block_temp_redo FALSE
_db_block_trace_protect FALSE
_db_block_vlm_check FALSE
_db_block_vlm_leak_threshold 3
_db_blocks_per_hash_latch
_db_cache_advice_max_size_factor 2
_db_cache_advice_sample_factor 4
_db_cache_advice_sanity_check FALSE
_db_cache_block_read_stack_trace 0
_db_cache_crx_check FALSE
_db_cache_miss_check_les FALSE
_db_cache_mman_latch_check FALSE
_db_cache_pre_warm TRUE
_db_cache_process_cr_pin_max
_db_cache_wait_debug 0
_db_change_notification_enable TRUE
_db_check_cell_hints FALSE
_db_disable_temp_encryption FALSE
_db_dump_from_disk_noefc 0
_db_fast_obj_check FALSE
_db_fast_obj_ckpt TRUE
_db_fast_obj_truncate TRUE
_db_file_direct_io_count 1048576
_db_file_exec_read_count 128
_db_file_format_io_buffers 4
_db_file_noncontig_mblock_read_count 11
_db_file_optimizer_read_count 8
_db_flash_cache_force_replenish_limit 8
_db_flash_cache_keep_limit 228716368
_db_flash_cache_write_limit 1
_db_flashback_iobuf_size 1
_db_flashback_log_min_size 16777216
_db_flashback_log_min_total_space 0
_db_flashback_num_iobuf 32
_db_handles 4000
_db_handles_cached 8
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_db_hot_block_tracking FALSE
_db_index_block_checking TRUE
_db_initial_cachesize_create_mb 256
_db_l2_tracing 0
_db_large_dirty_queue 25
_db_lost_write_checking 2
_db_lost_write_tracing FALSE
_db_mttr_advice ON
_db_mttr_partitions 0
_db_mttr_sample_factor 64
_db_mttr_sim_target
_db_mttr_sim_trace_size 256
_db_mttr_trace_to_alert FALSE
_db_noarch_disble_optim FALSE
_db_num_evict_waitevents 64
_db_obj_enable_ksr TRUE
_db_percent_hot_default 50
_db_percent_hot_keep 0
_db_percent_hot_recycle 0
_db_percpu_create_cachesize 2
_db_prefetch_histogram_statistics FALSE
_db_recovery_temporal_file_dest
_db_required_percent_fairshare_usage 10
_db_row_overlap_checking TRUE
_db_todefer_cache_create TRUE
_db_writer_chunk_writes 0
_db_writer_coalesce_area_size 4194304
_db_writer_coalesce_write_limit 131072
_db_writer_flush_imu TRUE
_db_writer_histogram_statistics FALSE
_db_writer_max_writes 0
_db_writer_nomemcopy_coalesce FALSE
_db_writer_verify_writes FALSE
_dbg_proc_startup FALSE
_dbms_sql_security_level 1
_dbrm_dynamic_threshold 16843752
_dbrm_num_runnable_list 0
_dbrm_quantum
_dbrm_runchk 0
_dbrm_short_wait_us 300
_dbwr_async_io TRUE
_dbwr_scan_interval 300
_dbwr_tracing 0
_dde_flood_control_init TRUE
_dead_process_scan_interval 60
_deadlock_diagnostic_level 2
_deadlock_resolution_incidents_always FALSE
_deadlock_resolution_incidents_enabled TRUE
_deadlock_resolution_level 1
_deadlock_resolution_min_wait_timeout_secs 60
_deadlock_resolution_signal_process_thresh_secs 60
_dedicated_server_poll_count 10
_dedicated_server_post_wait FALSE
_dedicated_server_post_wait_call FALSE
_default_encrypt_alg 0
_default_non_equality_sel_check TRUE
_defer_eor_orl_arch_for_so FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_defer_log_boundary_ckpt TRUE
_defer_log_count 2
_defer_rcv_during_sw_to_sby FALSE
_deferred_constant_folding_mode DEFAULT
_deferred_log_dest_is_valid TRUE
_delay_index_maintain TRUE
_delta_push_share_blockers 0
_deq_execute_reset_time 30
_deq_ht_child_latches 8
_deq_ht_max_elements 100000
_deq_large_txn_size 25000
_deq_log_array_size 10000
_deq_max_fetch_count 10
_deq_maxwait_time 0
_desired_readmem_rate 90
_dg_broker_trace_level
_dg_cf_check_timer 15
_dg_corrupt_redo_log 0
_diag_adr_auto_purge TRUE
_diag_adr_enabled TRUE
_diag_adr_test_param 0
_diag_arb_before_kill FALSE
_diag_backward_compat TRUE
_diag_cc_enabled TRUE
_diag_conf_cap_enabled TRUE
_diag_crashdump_level 10
_diag_daemon TRUE
_diag_dde_async_age_limit 300
_diag_dde_async_cputime_limit 300
_diag_dde_async_mode 1
_diag_dde_async_msg_capacity 1024
_diag_dde_async_msgs 50
_diag_dde_async_process_rate 5
_diag_dde_async_runtime_limit 900
_diag_dde_async_slaves 5
_diag_dde_enabled TRUE
_diag_dde_fc_enabled TRUE
_diag_dde_fc_implicit_time 0
_diag_dde_fc_macro_time 0
_diag_dde_inc_proc_delay 1
_diag_diagnostics TRUE
_diag_dump_request_debug_level 1
_diag_dump_timeout 30
_diag_enable_startup_events FALSE
_diag_hm_rc_enabled TRUE
_diag_hm_tc_enabled FALSE
_diag_proc_enabled TRUE
_diag_proc_max_time_ms 30000
_diag_proc_stack_capture_type 1
_diag_uts_control 0
_diag_verbose_error_on_init 0
_dimension_skip_null TRUE
_direct_io_skip_cur_slot_on_error TRUE
_direct_io_slots 0
_direct_io_wslots 0
_direct_path_insert_features 0
_direct_read_decision_statistics_driven TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_disable_12751 FALSE
_disable_active_influx_move FALSE
_disable_adaptive_shrunk_aggregation FALSE
_disable_appliance_check FALSE
_disable_appliance_partnering FALSE
_disable_autotune_gtx FALSE
_disable_block_checking FALSE
_disable_cell_optimized_backups FALSE
_disable_cpu_check FALSE
_disable_cursor_sharing FALSE
_disable_datalayer_sampling FALSE
_disable_duplex_link TRUE
_disable_fast_aggregation FALSE
_disable_fast_validate FALSE
_disable_fastopen FALSE
_disable_fba_qrw 0
_disable_fba_wpr 0
_disable_file_locks FALSE
_disable_flashback_archiver 0
_disable_flashback_wait_callback FALSE
_disable_function_based_index FALSE
_disable_gvaq_cache FALSE
_disable_health_check FALSE
_disable_highres_ticks FALSE
_disable_image_check FALSE
_disable_implicit_row_movement FALSE
_disable_incremental_checkpoints FALSE
_disable_incremental_recovery_ckpt FALSE
_disable_index_block_prefetching FALSE
_disable_initial_block_compression FALSE
_disable_instance_params_check FALSE
_disable_interface_checking FALSE
_disable_kcb_flashback_blocknew_opt FALSE
_disable_kcbhxor_osd FALSE
_disable_kcbl_flashback_blocknew_opt FALSE
_disable_kgghshcrc32_osd FALSE
_disable_latch_free_SCN_writes_via_32cas FALSE
_disable_latch_free_SCN_writes_via_64cas FALSE
_disable_logging FALSE
_disable_metrics_group 0
_disable_multiple_block_sizes FALSE
_disable_odm FALSE
_disable_parallel_conventional_load FALSE
_disable_primary_bitmap_switch FALSE
_disable_read_only_open_dict_check FALSE
_disable_rebalance_compact FALSE
_disable_rebalance_space_check FALSE
_disable_recovery_read_skip FALSE
_disable_sample_io_optim FALSE
_disable_savepoint_reset FALSE
_disable_selftune_checkpointing FALSE
_disable_storage_type TRUE
_disable_streams_diagnostics 0
_disable_streams_pool_auto_tuning FALSE
_disable_sun_rsm TRUE
_disable_system_state 4294967294
_disable_system_state_wait_samples FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_disable_temp_tablespace_alerts FALSE
_disable_thread_internal_disable FALSE
_disable_thread_snapshot TRUE
_disable_txn_alert 0
_disable_undo_tablespace_alerts FALSE
_disable_wait_state
_discrete_transactions_enabled FALSE
_disk_sector_size_override FALSE
_diskmon_pipe_name
_dispatcher_rate_scale
_dispatcher_rate_ttl
_distinct_view_unnesting FALSE
_distributed_recovery_connection_hold_time 200
_dlmtrace
_dm_max_shared_pool_pct 1
_dml_batch_error_limit 0
_dml_frequency_tracking FALSE
_dml_frequency_tracking_advance TRUE
_dml_frequency_tracking_slot_time 15
_dml_frequency_tracking_slots 4
_dml_monitoring_enabled TRUE
_domain_index_batch_size 2000
_domain_index_dml_batch_size 200
_dra_bmr_number_threshold 1000
_dra_bmr_percent_threshold 10
_dra_enable_offline_dictionary FALSE
_drm_parallel_freeze TRUE
_drop_flashback_logical_operations_enq FALSE
_drop_table_granule 256
_drop_table_optimization_enabled TRUE
_ds_enable_auto_txn FALSE
_ds_iocount_iosize 6553664
_ds_parse_model 2
_dsc_feature_level 0
_dskm_health_check_cnt 20
_dss_cache_flush FALSE
_dtree_area_size 131072
_dtree_binning_enabled TRUE
_dtree_bintest_id 0
_dtree_compressbmp_enabled TRUE
_dtree_max_surrogates 1
_dtree_pruning_enabled TRUE
_dummy_instance FALSE
_dump_common_subexpressions FALSE
_dump_connect_by_loop_data FALSE
_dump_cursor_heap_sizes FALSE
_dump_interval_limit 120
_dump_max_limit 5
_dump_qbc_tree 0
_dump_rcvr_ipc TRUE
_dump_system_state_scope local
_dump_trace_scope global
_dynamic_rls_policies TRUE
_dynamic_stats_threshold 30
_eighteenth_spare_parameter
_eighth_spare_parameter
_eleventh_spare_parameter
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_eliminate_common_subexpr TRUE
_emon_max_active_connections 256
_emon_outbound_connect_timeout 30000
_emon_regular_ntfn_slaves 4
_enable_Front_End_View_Optimization 1
_enable_LGPG_debug FALSE
_enable_NUMA_interleave TRUE
_enable_NUMA_optimization FALSE
_enable_NUMA_support FALSE
_enable_asyncvio FALSE
_enable_automatic_maintenance 1
_enable_automatic_sqltune TRUE
_enable_block_level_transaction_recovery TRUE
_enable_check_truncate TRUE
_enable_cscn_caching FALSE
_enable_ddl_wait_lock TRUE
_enable_default_affinity 0
_enable_default_temp_threshold TRUE
_enable_default_undo_threshold TRUE
_enable_dml_lock_escalation TRUE
_enable_editions_for_users FALSE
_enable_exchange_validation_using_check TRUE
_enable_fast_ref_after_mv_tbs FALSE
_enable_ffw TRUE
_enable_flash_logging TRUE
_enable_hash_overflow FALSE
_enable_hwm_sync TRUE
_enable_kqf_purge TRUE
_enable_list_io FALSE
_enable_midtier_affinity TRUE
_enable_minscn_cr TRUE
_enable_nativenet_tcpip FALSE
_enable_obj_queues TRUE
_enable_online_index_without_s_locking TRUE
_enable_query_rewrite_on_remote_objs TRUE
_enable_redo_global_post FALSE
_enable_refresh_schedule TRUE
_enable_reliable_latch_waits TRUE
_enable_rename_user FALSE
_enable_rlb TRUE
_enable_row_shipping TRUE
_enable_sb_detection TRUE
_enable_schema_synonyms FALSE
_enable_scn_wait_interface TRUE
_enable_separable_transactions FALSE
_enable_shared_pool_durations TRUE
_enable_shared_server_vector_io FALSE
_enable_space_preallocation 3
_enable_spacebg TRUE
_enable_tablespace_alerts TRUE
_enable_type_dep_selectivity TRUE
_endprot_chunk_comment chk 10235 dflt
_endprot_heap_comment hp 10235 dflt
_endprot_subheaps TRUE
_enqueue_deadlock_scan_secs 0
_enqueue_deadlock_time_sec 5
_enqueue_debug_multi_instance FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_enqueue_hash 1635
_enqueue_hash_chain_latches 32
_enqueue_locks 10190
_enqueue_paranoia_mode_enabled FALSE
_enqueue_resources 3740
_evolve_plan_baseline_report_level typical
_evt_system_event_propagation TRUE
_expand_aggregates TRUE
_explain_rewrite_mode FALSE
_extended_pruning_enabled TRUE
_fair_remote_cvt FALSE
_fairness_threshold 2
_fast_cursor_reexecute FALSE
_fast_dual_enabled TRUE
_fast_full_scan_enabled TRUE
_fastpin_enable 228793345
_fbda_busy_percentage 0
_fbda_debug_assert 0
_fbda_debug_mode 0
_fbda_global_bscn_lag 0
_fbda_inline_percentage 0
_fbda_rac_inactive_limit 0
_fg_iorm_slaves 1
_fg_log_checksum TRUE
_fg_sync_sleep_usecs 0
_fic_algorithm_set automatic
_fic_area_size 131072
_fic_max_length 20
_fic_min_bmsize 1024
_fic_outofmem_candidates FALSE
_fifteenth_spare_parameter
_fifth_spare_parameter
_file_size_increase_increment 67108864
_filemap_dir
_first_k_rows_dynamic_proration TRUE
_first_spare_parameter
_fix_control
_flashback_11.1_block_new_opt FALSE
_flashback_allow_noarchivelog FALSE
_flashback_archiver_partition_size 0
_flashback_barrier_interval 1800
_flashback_copy_latches 10
_flashback_database_test_only FALSE
_flashback_delete_chunk_MB 128
_flashback_dynamic_enable TRUE
_flashback_dynamic_enable_failure 0
_flashback_enable_ra TRUE
_flashback_format_chunk_mb 4
_flashback_format_chunk_mb_dwrite 16
_flashback_fuzzy_barrier TRUE
_flashback_generation_buffer_size 134217728
_flashback_hint_barrier_percent 20
_flashback_log_io_error_behavior 0
_flashback_log_min_size 100
_flashback_log_rac_balance_factor 10
_flashback_log_size 1000
_flashback_logfile_enqueue_timeout 600
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_flashback_marker_cache_enabled TRUE
_flashback_marker_cache_size 328
_flashback_max_log_size 0
_flashback_max_n_log_per_thread 2048
_flashback_max_standby_sync_span 300
_flashback_n_log_per_thread 128
_flashback_prepare_log TRUE
_flashback_size_based_on_redo TRUE
_flashback_standby_barrier_interval 1
_flashback_validate_controlfile FALSE
_flashback_verbose_info FALSE
_flashback_write_max_loop_limit 10
_flush_plan_in_awr_sql 0
_flush_redo_to_standby 0
_flush_undo_after_tx_recovery TRUE
_force_arch_compress 0
_force_datefold_trunc FALSE
_force_hash_join_spill FALSE
_force_hsc_compress FALSE
_force_oltp_compress FALSE
_force_oltp_update_opt TRUE
_force_rcv_info_ping 0
_force_rewrite_enable FALSE
_force_slave_mapping_intra_part_loads FALSE
_force_temptables_for_gsets FALSE
_force_tmp_segment_loads FALSE
_forwarded_2pc_threshold 10
_fourteenth_spare_parameter
_fourth_spare_parameter
_frame_cache_time 0
_full_pwise_join_enabled TRUE
_fusion_security FALSE
_gby_hash_aggregation_enabled TRUE
_gby_onekey_enabled TRUE
_gc_affinity_locking TRUE
_gc_affinity_locks TRUE
_gc_affinity_ratio 50
_gc_async_memcpy FALSE
_gc_bypass_readers TRUE
_gc_check_bscn TRUE
_gc_coalesce_recovery_reads TRUE
_gc_cpu_time FALSE
_gc_cr_server_read_wait TRUE
_gc_defer_ping_index_only TRUE
_gc_defer_time 1
_gc_delta_push_compression 3072
_gc_delta_push_max_level 100
_gc_delta_push_objects 0
_gc_disable_s_lock_brr_ping_check TRUE
_gc_down_convert_after_keep TRUE
_gc_element_percent 110
_gc_escalate_bid TRUE
_gc_fg_merge TRUE
_gc_flush_during_affinity TRUE
_gc_fusion_compression 1024
_gc_global_checkpoint_scn TRUE
_gc_global_cpu TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_gc_global_lru AUTO
_gc_global_lru_touch_count 5
_gc_global_lru_touch_time 60
_gc_integrity_checks 1
_gc_keep_recovery_buffers TRUE
_gc_latches 8
_gc_log_flush TRUE
_gc_long_query_threshold 0
_gc_max_downcvt 256
_gc_maximum_bids 0
_gc_no_fairness_for_clones TRUE
_gc_override_force_cr TRUE
_gc_persistent_read_mostly TRUE
_gc_policy_minimum 1500
_gc_policy_time 10
_gc_read_mostly_flush_check FALSE
_gc_read_mostly_locking TRUE
_gc_sanity_check_cr_buffers FALSE
_gc_serve_high_pi_as_current TRUE
_gc_statistics TRUE
_gc_transfer_ratio 2
_gc_tsn_undo_affinity TRUE
_gc_undo_affinity TRUE
_gc_undo_block_disk_reads TRUE
_gc_use_cr TRUE
_gc_vector_read TRUE
_gcr_enable_high_cpu_kill FALSE
_gcr_enable_high_cpu_rm FALSE
_gcr_enable_high_cpu_rt FALSE
_gcr_high_cpu_threshold 10
_gcr_use_css TRUE
_gcs_disable_remote_handles FALSE
_gcs_disable_skip_close_remastering FALSE
_gcs_fast_reconfig TRUE
_gcs_latches 0
_gcs_pkey_history 4000
_gcs_process_in_recovery TRUE
_gcs_res_per_bucket 4
_gcs_resources
_gcs_shadow_locks
_gcs_testing 0
_generalized_pruning_enabled TRUE
_ges_dd_debug 1
_ges_designated_master FALSE
_ges_diagnostics TRUE
_ges_diagnostics_asm_dump_level 11
_ges_health_check 0
_ges_num_blockers_to_kill 1
_global_hang_analysis_interval_secs 10
_globalindex_pnum_filter_enabled TRUE
_groupby_nopushdown_cut_ratio 3
_groupby_orderby_combine 5000
_gs_anti_semi_join_allowed TRUE
_hang_analysis_num_call_stacks 3
_hang_detection_enabled TRUE
_hang_detection_interval 32
_hang_hiload_promoted_ignored_hang_count 2
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_hang_hiprior_session_attribute_list
_hang_ignored_hang_count 1
_hang_ignored_hangs_interval 300
_hang_log_incidents FALSE
_hang_long_wait_time_threshold 0
_hang_lws_file_count 5
_hang_lws_file_time_limit 3600
_hang_msg_checksum_enabled TRUE
_hang_output_suspected_hangs FALSE
_hang_resolution_confidence_promotion FALSE
_hang_resolution_global_hang_confidence_promotion FALSE
_hang_resolution_policy HIGH
_hang_resolution_promote_process_termination FALSE
_hang_resolution_scope PROCESS
_hang_signature_list_match_output_frequency 10
_hang_statistics_collection_interval 15
_hang_statistics_collection_ma_alpha 30
_hang_statistics_high_io_percentage_threshold 45
_hang_verification_interval 46
_hard_protection FALSE
_hash_join_enabled TRUE
_hash_multiblock_io_count 0
_hb_redo_msg_interval 100
_heur_deadlock_resolution_secs 0
_high_priority_processes LMS*|VKTM
_high_server_threshold 0
_highres_drift_allowed_sec 1
_highthreshold_undoretention 4294967294
_hj_bit_filter_threshold 50
_hm_analysis_oradebug_node_dump_level 0
_hm_analysis_oradebug_sys_dump_level 0
_hm_analysis_output_disk FALSE
_hwm_sync_threshold 10
_idl_conventional_index_maintenance TRUE
_idle_session_kill_enabled TRUE
_idxrb_rowincr 100000000
_ignore_desc_in_index FALSE
_ignore_edition_enabled_for_EV_creation FALSE
_ignore_fg_deps
_immediate_commit_propagation TRUE
_improved_outerjoin_card TRUE
_improved_row_length_enabled TRUE
_imr_active TRUE
_imr_avoid_double_voting TRUE
_imr_controlfile_access_wait_time 10
_imr_device_type controlfile
_imr_disk_voting_interval 3
_imr_diskvote_implementation auto
_imr_evicted_member_kill TRUE
_imr_evicted_member_kill_wait 20
_imr_extra_reconfig_wait 10
_imr_highload_threshold
_imr_max_reconfig_delay 75
_imr_splitbrain_res_wait 0
_imr_systemload_check TRUE
_imu_pools 3
_in_memory_tbs_search TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_in_memory_undo TRUE
_incremental_recovery_ckpt_min_batch 500
_index_join_enabled TRUE
_index_partition_large_extents FALSE
_index_prefetch_factor 100
_index_scan_check_skip_corrupt FALSE
_index_scan_check_stopkey FALSE
_init_granule_interval 10
_init_sql_file ?/rdbms/admin/sql.bsq
_inject_startup_fault 0
_inline_sql_in_plsql FALSE
_inplace_update_retry TRUE
_inquiry_retry_interval 3
_insert_enable_hwm_brokered TRUE
_inst_locking_period 5
_interconnect_checksum TRUE
_intrapart_pdml_enabled TRUE
_intrapart_pdml_randomlocal_enabled TRUE
_io_resource_manager_always_on FALSE
_io_shared_pool_size 4194304
_io_slaves_disabled FALSE
_io_statistics TRUE
_iocalibrate_init_ios 2
_iocalibrate_max_ios 0
_ioq_fanin_multiplier 2
_ior_serialize_fault 0
_iorm_tout 1000
_ioslave_batch_count 1
_ioslave_issue_count 500
_ipc_fail_network 0
_ipc_test_failover 0
_ipc_test_mult_nets 0
_ipddb_enable FALSE
_job_queue_interval 5
_k2q_latches 0
_kcfis_block_dump_level 0
_kcfis_caching_enabled TRUE
_kcfis_cell_passthru_enabled FALSE
_kcfis_cell_passthru_fromcpu_enabled TRUE
_kcfis_control1 0
_kcfis_control2 0
_kcfis_control3 0
_kcfis_control4 0
_kcfis_control5 0
_kcfis_control6 0
_kcfis_disable_platform_decryption FALSE
_kcfis_dump_corrupt_block TRUE
_kcfis_fast_response_enabled TRUE
_kcfis_fast_response_initiosize 2
_kcfis_fast_response_iosizemult 4
_kcfis_fast_response_threshold 1048576
_kcfis_fault_control 0
_kcfis_io_prefetch_size 8
_kcfis_ioreqs_throttle_enabled TRUE
_kcfis_kept_in_cellfc_enabled TRUE
_kcfis_large_payload_enabled FALSE
_kcfis_max_cached_sessions 10
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kcfis_max_out_translations 5000
_kcfis_nonkept_in_cellfc_enabled FALSE
_kcfis_oss_io_size 0
_kcfis_rdbms_blockio_enabled FALSE
_kcfis_read_buffer_limit 0
_kcfis_spawn_debugger FALSE
_kcfis_stats_level 0
_kcfis_storageidx_diag_mode 0
_kcfis_storageidx_disabled FALSE
_kcfis_test_control1 0
_kcfis_trace_bucket_size 131072
_kcfis_trace_level 0
_kcfis_work_set_appliances 2
_kcl_commit TRUE
_kcl_conservative_log_flush FALSE
_kcl_debug TRUE
_kcl_index_split TRUE
_kd_symtab_chk TRUE
_kdbl_enable_post_allocation FALSE
_kdi_avoid_block_checking FALSE
_kdic_segarr_sz 0
_kdis_reject_level 24
_kdis_reject_limit 5
_kdis_reject_ops FALSE
_kdli_STOP_bsz 0
_kdli_STOP_dba 0
_kdli_STOP_fsz 0
_kdli_STOP_nio 0
_kdli_STOP_tsn 0
_kdli_allow_corrupt TRUE
_kdli_buffer_inject TRUE
_kdli_cache_inode TRUE
_kdli_cache_read_threshold 0
_kdli_cache_size 8
_kdli_cache_verify FALSE
_kdli_cache_write_threshold 0
_kdli_cacheable_length 0
_kdli_checkpoint_flush FALSE
_kdli_dbc none
_kdli_delay_flushes TRUE
_kdli_flush_cache_reads FALSE
_kdli_flush_injections TRUE
_kdli_force_cr TRUE
_kdli_force_cr_meta TRUE
_kdli_force_storage none
_kdli_full_readahead_threshold 0
_kdli_inject_assert 0
_kdli_inject_batch 0
_kdli_inject_crash 0
_kdli_inline_xfm TRUE
_kdli_inode_preference data
_kdli_inplace_overwrite 0
_kdli_itree_entries 0
_kdli_memory_protect FALSE
_kdli_oneblk FALSE
_kdli_preallocation_mode length
_kdli_preallocation_pct 0
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kdli_rci_lobmap_entries 255
_kdli_readahead_limit 0
_kdli_readahead_strategy contig
_kdli_recent_scn FALSE
_kdli_reshape FALSE
_kdli_safe_callbacks TRUE
_kdli_sio_async TRUE
_kdli_sio_backoff FALSE
_kdli_sio_bps 0
_kdli_sio_dop 2
_kdli_sio_fbwrite_pct 35
_kdli_sio_fgio TRUE
_kdli_sio_fileopen none
_kdli_sio_flush FALSE
_kdli_sio_free TRUE
_kdli_sio_min_read 0
_kdli_sio_min_write 0
_kdli_sio_nbufs 8
_kdli_sio_niods 8
_kdli_sio_on TRUE
_kdli_sio_pga FALSE
_kdli_sio_pga_top FALSE
_kdli_sio_strategy extent
_kdli_sio_write_pct 100
_kdli_small_cache_limit 32
_kdli_sort_dbas FALSE
_kdli_space_cache_limit 2048
_kdli_squeeze TRUE
_kdli_timer_dmp FALSE
_kdli_timer_trc FALSE
_kdli_trace 0
_kdli_vll_direct TRUE
_kdlu_max_bucket_size 4194304
_kdlu_max_bucket_size_mts 131072
_kdlu_trace_layer 0
_kdlu_trace_session 0
_kdlu_trace_system 0
_kdlw_enable_ksi_locking FALSE
_kdlw_enable_write_gathering TRUE
_kdlwp_flush_threshold 4194304
_kdlxp_cmp_subunit_size 262144
_kdlxp_dedup_flush_threshold 8388608
_kdlxp_dedup_hash_algo SHA1
_kdlxp_dedup_inl_pctfree 5
_kdlxp_dedup_prefix_threshold 1048576
_kdlxp_dedup_wapp_len 0
_kdlxp_lobcmpadp FALSE
_kdlxp_lobcmplevel 2
_kdlxp_lobcmprciver 1
_kdlxp_lobcompress FALSE
_kdlxp_lobdeduplicate FALSE
_kdlxp_lobdedupvalidate TRUE
_kdlxp_lobencrypt FALSE
_kdlxp_mincmp 20
_kdlxp_mincmplen 200
_kdlxp_minxfm_size 32768
_kdlxp_spare1 0
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kdlxp_uncmp FALSE
_kdlxp_xfmcache TRUE
_kdt_buffering TRUE
_kdtgsp_retries 1024
_kdu_array_depth 16
_kdz_hcc_flags 0
_kdz_hcc_track_upd_rids TRUE
_kebm_nstrikes 3
_kebm_suspension_time 82800
_keep_remote_column_size FALSE
_kernel_message_network_driver FALSE
_kes_parse_model 2
_kffmap_hash_size 1024
_kffmop_hash_size 2048
_kfm_disable_set_fence FALSE
_kghdsidx_count 6
_kgl_bucket_count 9
_kgl_cluster_lock TRUE
_kgl_cluster_lock_read_mostly FALSE
_kgl_cluster_pin TRUE
_kgl_debug
_kgl_fixed_extents TRUE
_kgl_hash_collision FALSE
_kgl_heap_size 4096
_kgl_hot_object_copies 0
_kgl_kqr_cap_so_stacks FALSE
_kgl_large_heap_warning_threshold 52428800
_kgl_latch_count 0
_kgl_message_locks 64
_kgl_min_cached_so_count 1
_kgl_time_to_wait_for_locks 15
_kglsim_maxmem_percent 5
_kgsb_threshold_size 16777216
_kgx_latches 1024
_kill_controlfile_enqueue_blocker TRUE
_kill_diagnostics_timeout 60
_kill_enqueue_blocker 2
_kill_java_threads_on_eoc FALSE
_kill_session_dump TRUE
_kkfi_trace FALSE
_kks_cached_parse_errors 0
_kks_free_cursor_stat_pct 10
_kokli_cache_size 128
_kokln_current_read FALSE
_kolfuseslf FALSE
_kql_subheap_trace 0
_ksb_restart_clean_time 30000
_ksb_restart_policy_times 0, 60, 120, 240
_ksd_test_param 999
_ksdx_charset_ratio 0
_ksdxdocmd_default_timeout_ms 30000
_ksdxdocmd_enabled TRUE
_ksdxw_cini_flg 0
_ksdxw_nbufs 1000
_ksdxw_num_pgw 10
_ksdxw_num_sgw 10
_ksdxw_stack_depth 4
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kse_die_timeout 60000
_kse_pc_table_size 256
_kse_signature_entries 0
_kse_signature_limit 7
_kse_snap_ring_record_stack FALSE
_kse_snap_ring_size 0
_kse_trace_int_msg_clear FALSE
_ksfd_verify_write FALSE
_ksi_clientlocks_enabled TRUE
_ksi_trace
_ksi_trace_bucket PRIVATE
_ksi_trace_bucket_size 8192
_ksm_post_sga_init_notif_delay_secs 0
_ksm_pre_sga_init_notif_delay_secs 0
_ksmb_debug 0
_ksmd_protect_mode off
_ksmg_granule_locking_status 1
_ksmg_granule_size 16777216
_ksmg_lock_check_interval
_ksmg_lock_reacquire_count 5
_kspol_tac_timeout 5
_ksr_unit_test_processes 0
_kss_callstack_type
_kss_quiet FALSE
_ksu_diag_kill_time 5
_ksuitm_addon_trccmd
_ksuitm_dont_kill_dumper FALSE
_ksv_dynamic_flags1 0
_ksv_max_spawn_fail_limit 5
_ksv_pool_hang_kill_to 0
_ksv_pool_wait_timeout 600
_ksv_spawn_control_all FALSE
_ksv_static_flags1 0
_ksvppktmode 0
_ksxp_compat_flags 0
_ksxp_control_flags 0
_ksxp_diagmode OFF
_ksxp_disable_clss 0
_ksxp_disable_dynamic_loading FALSE
_ksxp_disable_ipc_stats FALSE
_ksxp_disable_rolling_migration FALSE
_ksxp_dump_timeout 20
_ksxp_dynamic_skgxp_param
_ksxp_if_config 0
_ksxp_init_stats_bkts 0
_ksxp_lwipc_enabled FALSE
_ksxp_max_stats_bkts 0
_ksxp_ping_enable TRUE
_ksxp_ping_polling_time 0
_ksxp_reaping 20
_ksxp_reporting_process LMD0
_ksxp_send_timeout 300
_ksxp_skgxp_compat_library_path
_ksxp_skgxp_ctx_flags1 0
_ksxp_skgxp_ctx_flags1mask 0
_ksxp_skgxp_dynamic_protocol 4096
_ksxp_skgxp_library_path
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_ksxp_skgxp_rgn_ports 0
_ksxp_skgxp_spare_param1
_ksxp_skgxp_spare_param2
_ksxp_skgxp_spare_param3
_ksxp_skgxp_spare_param4
_ksxp_skgxp_spare_param5
_ksxp_skgxpg_last_parameter 26
_ksxp_stats_mem_lmt 0
_ksxp_testing 0
_ksxp_unit_test_byte_transformation FALSE
_ksxp_wait_flags 0
_ktb_debug_flags 0
_ktc_debug 0
_ktc_latches 0
_ktslj_segext_max_mb 0
_ktslj_segext_retry 5
_ktslj_segext_warning 10
_ktslj_segext_warning_mb 0
_ktspsrch_maxsc 1024
_ktspsrch_maxskip 5
_kttext_warning 5
_ktu_latches 0
_ku_trace none
_large_pool_min_alloc 65536
_last_allocation_period 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
_latch_recovery_alignment 65534
_ldr_io_size 262144
_ldr_io_size2 1048576
_ldr_pga_lim 0
_left_nested_loops_random TRUE
_lgwr_delay_write FALSE
_lgwr_io_slaves 0
_lgwr_max_ns_wt 1
_lgwr_ns_nl_max 1000
_lgwr_ns_nl_min 500
_lgwr_ns_sim_err 0
_lgwr_posts_for_pending_bcasts FALSE
_lgwr_ta_sim_err 0
_library_cache_advice TRUE
_lightweight_hdrs TRUE
_like_with_bind_as_equality FALSE
_limit_itls 20
_linux_prepage_large_pages FALSE
_lm_activate_lms_threshold 100
_lm_asm_enq_hashing TRUE
_lm_batch_compression_threshold 0
_lm_better_ddvictim TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_lm_broadcast_res disable
_lm_broadcast_resname AD
_lm_cache_allocated_res_ratio 50
_lm_cache_lvl0_cleanup 0
_lm_cache_res_cleanup 25
_lm_cache_res_cleanup_tries 10
_lm_cache_res_options 0
_lm_cache_res_skip_cleanup 20
_lm_cache_res_type TMHWHVDI
_lm_checksum_batch_msg 0
_lm_compression_scheme zlib
_lm_contiguous_res_count 128
_lm_dd_ignore_nodd FALSE
_lm_dd_interval 10
_lm_dd_max_search_time 180
_lm_dd_maxdump 50
_lm_dd_scan_interval 5
_lm_dd_search_cnt 3
_lm_deferred_msg_timeout 163
_lm_drm_batch_time 10
_lm_drm_disable 0
_lm_drm_hiload_percentage 200
_lm_drm_lowload_percentage 200
_lm_drm_max_requests 100
_lm_drm_min_interval 300
_lm_drm_object_scan TRUE
_lm_drm_window 0
_lm_drm_xlatch 0
_lm_dump_null_lock FALSE
_lm_dynamic_lms FALSE
_lm_dynamic_load TRUE
_lm_enable_aff_benefit_stats FALSE
_lm_enq_lock_freelist
_lm_enq_rcfg TRUE
_lm_enqueue_blocker_dump_timeout 120
_lm_enqueue_blocker_kill_timeout 0
_lm_enqueue_freelist 3
_lm_enqueue_timeout 360
_lm_file_affinity
_lm_file_read_mostly
_lm_free_queue_threshold 0
_lm_freeze_kill_time 30
_lm_global_posts TRUE
_lm_hb_callstack_collect_time 5
_lm_hb_disable_check_list none
_lm_high_load_sysload_percentage 90
_lm_high_load_threshold 5
_lm_idle_connection_check TRUE
_lm_idle_connection_check_interval 140
_lm_idle_connection_instance_check_callout FALSE
_lm_idle_connection_kill TRUE
_lm_kill_fg_on_timeout TRUE
_lm_lhupd_interval 5
_lm_lmd_waittime 8
_lm_lmon_nowait_latch TRUE
_lm_lms 0
_lm_lms_priority_dynamic TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_lm_lms_rt_threshold
_lm_lms_spin FALSE
_lm_lms_waittime 3
_lm_local_hp_enq TRUE
_lm_locks 12000
_lm_low_load_percentage 75
_lm_master_weight 1
_lm_max_lms 0
_lm_msg_batch_size 0
_lm_msg_cleanup_interval 3000
_lm_no_lh_check FALSE
_lm_no_sync TRUE
_lm_node_join_opt FALSE
_lm_non_fault_tolerant FALSE
_lm_num_pt_buckets 8192
_lm_num_pt_latches 128
_lm_postevent_buffer_size 256
_lm_preregister_css_restype CF
_lm_proc_freeze_timeout 70
_lm_process_batching TRUE
_lm_procs 320
_lm_psrcfg TRUE
_lm_rac_spare_dp1 0
_lm_rac_spare_dp10
_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_p1 0
_lm_rac_spare_p10
_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_rcfg_timeout 489
_lm_rcvinst TRUE
_lm_rcvr_hang_allow_time 70
_lm_rcvr_hang_cfio_kill FALSE
_lm_rcvr_hang_check_frequency 20
_lm_rcvr_hang_check_system_load TRUE
_lm_rcvr_hang_kill TRUE
_lm_rcvr_hang_systemstate_dump_level 0
_lm_res_hash_bucket 0
_lm_res_part 128
_lm_ress 6000
_lm_send_mode auto
_lm_send_queue_batching TRUE
_lm_send_queue_length 5000
_lm_sendproxy_reserve 25
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_lm_share_lock_opt FALSE
_lm_single_inst_affinity_lock TRUE
_lm_spare_threads 0
_lm_spare_undo 0
_lm_sq_batch_factor 2
_lm_sq_batch_type auto
_lm_sq_batch_waittick 3
_lm_sync_timeout 163
_lm_ticket_active_sendback
_lm_tickets 1000
_lm_tx_delta 16
_lm_use_gcr TRUE
_lm_use_new_defmsgtmo_action TRUE
_lm_use_tx_tsn TRUE
_lm_validate_pbatch FALSE
_lm_validate_resource_type FALSE
_lm_watchpoint_maximum 3
_lm_watchpoint_timeout 3600
_lm_xids 352
_lmn_compression TRUE
_load_without_compile NONE
_local_arc_assert_on_wait FALSE
_local_communication_costing_enabled TRUE
_local_communication_ratio 50
_local_hang_analysis_interval_secs 3
_lock_sga_areas 0
_log_archive_avoid_memcpy TRUE
_log_archive_buffers 10
_log_archive_callout
_log_archive_network_redo_size 10
_log_archive_prot_auto_demote FALSE
_log_archive_security_enabled TRUE
_log_archive_strong_auth TRUE
_log_archive_trace_pids
_log_blocks_during_backup TRUE
_log_buffer_coalesce FALSE
_log_buffers_corrupt FALSE
_log_buffers_debug FALSE
_log_checkpoint_recovery_check 0
_log_committime_block_cleanout FALSE
_log_deletion_policy mandatory
_log_event_queues 0
_log_file_sync_timeout 10
_log_io_size 0
_log_max_optimize_threads 128
_log_parallelism_dynamic TRUE
_log_parallelism_max 2
_log_private_mul 5
_log_private_parallelism_mul 10
_log_read_buffer_size 8
_log_read_buffers 8
_log_simultaneous_copies 64
_log_space_errors TRUE
_log_switch_timeout 0
_logout_storm_rate 0
_logout_storm_retrycnt 600
_logout_storm_timeout 5
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_long_bcast_ack_warning_threshold 500
_long_log_write_warning_threshold 500
_longops_enabled TRUE
_low_server_threshold 0
_lowres_drift_allowed_sec 5
_ltc_trace 0
_main_dead_process_scan_interval 0
_master_direct_sends 31
_mav_refresh_consistent_read TRUE
_mav_refresh_double_count_prevented FALSE
_mav_refresh_opt 0
_mav_refresh_unionall_tables 3
_max_aq_persistent_queue_memory 10
_max_async_wait_for_catch_up 20
_max_cr_rollbacks 0
_max_exponential_sleep 0
_max_filestat_tries 10
_max_fsu_segments 4096
_max_fsu_stale_time 600
_max_io_size 1048576
_max_large_io 0
_max_largepage_alloc_time_secs 10
_max_lns_shutdown_archival_time 30
_max_pending_scn_bcasts 8
_max_protocol_support 10000
_max_reasonable_scn_rate 32768
_max_rwgs_groupings 8192
_max_services 150
_max_shrink_obj_stats 0
_max_sleep_holding_latch 4
_max_small_io 0
_max_spacebg_msgs_percentage 50
_max_spacebg_slaves 10
_max_spacebg_tasks 1000
_media_recovery_read_batch 32
_mem_annotation_pr_lev 0
_mem_annotation_scale 1
_mem_annotation_sh_lev 0
_mem_annotation_store FALSE
_mem_std_extent_size 4096
_memory_broker_log_stat_entries 5
_memory_broker_marginal_utility_bc 12
_memory_broker_marginal_utility_sp 7
_memory_broker_shrink_heaps 15
_memory_broker_shrink_java_heaps 900
_memory_broker_shrink_streams_pool 900
_memory_broker_shrink_timeout 60000000
_memory_broker_stat_interval 30
_memory_checkinuse_timeintv 30
_memory_imm_mode_without_autosga TRUE
_memory_initial_sga_split_perc 60
_memory_management_tracing 0
_memory_mgmt_fail_immreq FALSE
_memory_mgmt_immreq_timeout 150
_memory_nocancel_defsgareq FALSE
_memory_sanity_check 0
_messages 1000
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_mgd_rcv_handle_orphan_datafiles FALSE
_midtier_affinity_clusterwait_threshold 100
_midtier_affinity_goodness_threshold 2000
_minfree_plus 0
_minimal_stats_aggregation TRUE
_minimum_blocks_to_shrink 0
_minimum_db_flashback_retention 60
_minimum_extents_to_shrink 1
_minimum_giga_scn 0
_mirror_redo_buffers FALSE
_mmv_query_rewrite_enabled TRUE
_module_action_old_length TRUE
_mpmt_enabled FALSE
_multi_instance_pmr TRUE
_multi_join_key_table_lookup TRUE
_multiple_instance_recovery FALSE
_mutex_spin_count 255
_mutex_wait_scheme 2
_mutex_wait_time 1
_mv_generalized_oj_refresh_opt TRUE
_mv_refresh_ana 0
_mv_refresh_costing rule
_mv_refresh_delta_fraction 10
_mv_refresh_enhanced_dml_detection ON_RC
_mv_refresh_eut TRUE
_mv_refresh_force_parallel_query 0
_mv_refresh_new_setup_disabled FALSE
_mv_refresh_no_idx_rebuild FALSE
_mv_refresh_pkfk_data_units_opt auto
_mv_refresh_pkfk_relationship_opt TRUE
_mv_refresh_rebuild_percentage 10
_mv_refresh_selections TRUE
_mv_refresh_update_analysis TRUE
_mv_refresh_use_hash_sj TRUE
_mv_refresh_use_no_merge TRUE
_mv_refresh_use_stats FALSE
_mv_refsched_timeincr 300000
_mv_rolling_inv FALSE
_mwin_schedule TRUE
_nchar_imp_cnv TRUE
_nchar_imp_conv TRUE
_ncmb_readahead_enabled 0
_ncmb_readahead_tracing 0
_ncomp_shared_objects_dir
_nested_loop_fudge 100
_nested_mv_fast_oncommit_enabled TRUE
_new_initial_join_orders TRUE
_new_sort_cost_estimate TRUE
_newsort_enabled TRUE
_newsort_ordered_pct 63
_newsort_type 0
_nineteenth_spare_parameter
_ninth_spare_parameter
_nlj_batching_ae_flag 2
_nlj_batching_enabled 1
_nlj_batching_misses_enabled 1
_nls_parameter_sync_enabled TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_no_objects FALSE
_no_or_expansion FALSE
_no_recovery_through_resetlogs FALSE
_noseg_for_unusable_index_enabled TRUE
_notify_crs FALSE
_ns_max_flush_wt 1
_ns_max_send_delay 15
_num_longop_child_latches 32
_numa_buffer_cache_stats 0
_numa_trace_level 0
_number_cached_attributes 10
_number_cached_group_memberships 32
_obj_ckpt_tracing 0
_object_number_cache_size 5
_object_reuse_bast 2
_object_statistics TRUE
_object_stats_max_entries 3072
_offline_rollback_segments
_ogms_home
_olap_adv_comp_stats_cc_precomp 20
_olap_adv_comp_stats_max_rows 100000
_olap_aggregate_buffer_size 1048576
_olap_aggregate_flags 0
_olap_aggregate_function_cache_enabled TRUE
_olap_aggregate_max_thread_tuples 5000
_olap_aggregate_min_buffer_size 1024
_olap_aggregate_min_thread_status 64
_olap_aggregate_multipath_hier FALSE
_olap_aggregate_statlen_thresh 1024
_olap_aggregate_work_per_thread 1024
_olap_aggregate_worklist_max 5000
_olap_allocate_errorlog_format %8p %8y %8z %e (%n)
_olap_allocate_errorlog_header Dim Source Basis
%-8d %-8s %-8b Description
-------- -------- -------- -----------
_olap_analyze_max 10000
_olap_continuous_trace_file false
_olap_dbgoutfile_echo_to_eventlog FALSE
_olap_dimension_corehash_force FALSE
_olap_dimension_corehash_large 50000
_olap_dimension_corehash_pressure 90
_olap_dimension_corehash_size 30
_olap_eif_export_lob_size 2147483647
_olap_lmgen_dim_size 100
_olap_lmgen_meas_size 1000
_olap_object_hash_class 3
_olap_page_pool_expand_rate 20
_olap_page_pool_hi 50
_olap_page_pool_hit_target 100
_olap_page_pool_low 262144
_olap_page_pool_pressure 90
_olap_page_pool_shrink_rate 50
_olap_parallel_update_server_num 0
_olap_parallel_update_small_threshold 1000
_olap_parallel_update_threshold 1000
_olap_sesscache_enabled TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_olap_sort_buffer_pct 10
_olap_sort_buffer_size 262144
_olap_statbool_corebits 20000000
_olap_statbool_threshold 8100
_olap_table_function_statistics FALSE
_olap_wrap_errors FALSE
_olapi_history_retention FALSE
_olapi_iface_object_history 1000
_olapi_iface_object_history_retention FALSE
_olapi_iface_operation_history_retention FALSE
_olapi_interface_operation_history 1000
_olapi_memory_operation_history 1000
_olapi_memory_operation_history_pause_at_seqno 0
_olapi_memory_operation_history_retention FALSE
_olapi_session_history 300
_olapi_session_history_retention FALSE
_old_connect_by_enabled FALSE
_ols_cleanup_task TRUE
_oltp_compression TRUE
_oltp_compression_gain 10
_omf enabled
_oneside_colstat_for_equijoins TRUE
_online_patch_disable_stack_check FALSE
_ops_per_semop
_optim_adjust_for_part_skews TRUE
_optim_dict_stats_at_db_cr_upg TRUE
_optim_enhance_nnull_detection TRUE
_optim_new_default_join_sel TRUE
_optim_peek_user_binds TRUE
_optimizer_adaptive_cursor_sharing TRUE
_optimizer_adjust_for_nulls TRUE
_optimizer_autostats_job TRUE
_optimizer_aw_join_push_enabled TRUE
_optimizer_aw_stats_enabled TRUE
_optimizer_better_inlist_costing ALL
_optimizer_block_size 8192
_optimizer_cache_stats FALSE
_optimizer_cartesian_enabled TRUE
_optimizer_cbqt_factor 50
_optimizer_cbqt_no_size_restriction TRUE
_optimizer_ceil_cost TRUE
_optimizer_coalesce_subqueries TRUE
_optimizer_complex_pred_selectivity TRUE
_optimizer_compute_index_stats TRUE
_optimizer_connect_by_cb_whr_only FALSE
_optimizer_connect_by_combine_sw TRUE
_optimizer_connect_by_cost_based TRUE
_optimizer_connect_by_elim_dups TRUE
_optimizer_correct_sq_selectivity TRUE
_optimizer_cost_based_transformation LINEAR
_optimizer_cost_filter_pred FALSE
_optimizer_cost_hjsmj_multimatch TRUE
_optimizer_cost_model CHOOSE
_optimizer_degree 0
_optimizer_dim_subq_join_sel TRUE
_optimizer_disable_strans_sanity_checks 0
_optimizer_distinct_agg_transform TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_optimizer_distinct_elimination TRUE
_optimizer_distinct_placement TRUE
_optimizer_dyn_smp_blks 32
_optimizer_eliminate_filtering_join TRUE
_optimizer_enable_density_improvements TRUE
_optimizer_enable_extended_stats TRUE
_optimizer_enable_table_lookup_by_nl TRUE
_optimizer_enhanced_filter_push TRUE
_optimizer_extend_jppd_view_types TRUE
_optimizer_extended_cursor_sharing UDO
_optimizer_extended_cursor_sharing_rel SIMPLE
_optimizer_extended_stats_usage_control 192
_optimizer_false_filter_pred_pullup TRUE
_optimizer_fast_access_pred_analysis TRUE
_optimizer_fast_pred_transitivity TRUE
_optimizer_feedback_control
_optimizer_filter_pred_pullup TRUE
_optimizer_filter_pushdown TRUE
_optimizer_fkr_index_cost_bias 10
_optimizer_force_CBQT
_optimizer_free_transformation_heap TRUE
_optimizer_full_outer_join_to_outer TRUE
_optimizer_group_by_placement TRUE
_optimizer_ignore_hints FALSE
_optimizer_improve_selectivity TRUE
_optimizer_instance_count 0
_optimizer_interleave_jppd TRUE
_optimizer_invalidation_period 18000
_optimizer_join_elimination_enabled TRUE
_optimizer_join_factorization TRUE
_optimizer_join_order_control 3
_optimizer_join_sel_sanity_check TRUE
_optimizer_max_permutations 2000
_optimizer_min_cache_blocks 10
_optimizer_mjc_enabled TRUE
_optimizer_mode_force TRUE
_optimizer_multi_level_push_pred TRUE
_optimizer_multiple_cenv
_optimizer_multiple_cenv_report result
_optimizer_multiple_cenv_stmt query
_optimizer_native_full_outer_join FORCE
_optimizer_nested_rollup_for_gset 100
_optimizer_new_join_card_computation TRUE
_optimizer_null_aware_antijoin TRUE
_optimizer_or_expansion DEPTH
_optimizer_or_expansion_subheap TRUE
_optimizer_order_by_elimination_enabled TRUE
_optimizer_outer_join_to_inner TRUE
_optimizer_outer_to_anti_enabled TRUE
_optimizer_percent_parallel 101
_optimizer_purge_stats_iteration_row_count 10000
_optimizer_push_down_distinct 0
_optimizer_push_pred_cost_based TRUE
_optimizer_random_plan 0
_optimizer_reuse_cost_annotations TRUE
_optimizer_rownum_bind_default 10
_optimizer_rownum_pred_based_fkr TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_optimizer_save_stats TRUE
_optimizer_search_limit 5
_optimizer_self_induced_cache_cost FALSE
_optimizer_skip_scan_enabled TRUE
_optimizer_skip_scan_guess FALSE
_optimizer_sortmerge_join_enabled TRUE
_optimizer_sortmerge_join_inequality TRUE
_optimizer_squ_bottomup TRUE
_optimizer_star_tran_in_with_clause TRUE
_optimizer_star_trans_min_cost 0
_optimizer_star_trans_min_ratio 0
_optimizer_starplan_enabled TRUE
_optimizer_system_stats_usage TRUE
_optimizer_table_expansion TRUE
_optimizer_trace none
_optimizer_transitivity_retain TRUE
_optimizer_try_st_before_jppd TRUE
_optimizer_undo_changes FALSE
_optimizer_undo_cost_change 11.2.0.3
_optimizer_unnest_all_subqueries TRUE
_optimizer_unnest_corr_set_subq TRUE
_optimizer_unnest_disjunctive_subq TRUE
_optimizer_use_cbqt_star_transformation TRUE
_optimizer_use_feedback TRUE
_optimizer_use_subheap TRUE
_or_expand_nvl_predicate TRUE
_oradbg_pathname
_oradebug_cmds_at_startup
_oradebug_force FALSE
_ordered_nested_loop TRUE
_ordered_semijoin TRUE
_orph_cln_interval 1200
_os_sched_high_priority 1
_oss_skgxp_udp_dynamic_credit_mgmt 1
_other_wait_event_exclusion
_other_wait_threshold 0
_outline_bitmap_tree TRUE
_parallel_adaptive_max_users 4
_parallel_blackbox_enabled TRUE
_parallel_blackbox_size 16384
_parallel_broadcast_enabled TRUE
_parallel_cluster_cache_pct 80
_parallel_cluster_cache_policy ADAPTIVE
_parallel_conservative_queuing FALSE
_parallel_default_max_instances 1
_parallel_execution_message_align FALSE
_parallel_fake_class_pct 0
_parallel_fixwrite_bucket 1000
_parallel_heartbeat_snapshot_interval 2
_parallel_heartbeat_snapshot_max 128
_parallel_load_bal_unit 0
_parallel_load_balancing TRUE
_parallel_load_publish_threshold 10
_parallel_min_message_pool 8192000
_parallel_optimization_phase_for_local FALSE
_parallel_queuing_max_waitingtime
_parallel_recovery_stopat 32767
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_parallel_replay_msg_limit 4000
_parallel_scalability 50
_parallel_server_idle_time 30000
_parallel_server_sleep_time 10
_parallel_slave_acquisition_wait 1
_parallel_statement_queuing FALSE
_parallel_syspls_obey_force TRUE
_parallel_time_unit 10
_parallel_txn_global FALSE
_parallelism_cost_fudge_factor 350
_parameter_table_block_size 2048
_partial_pwise_join_enabled TRUE
_partition_large_extents TRUE
_partition_view_enabled TRUE
_passwordfile_enqueue_timeout 900
_pct_refresh_double_count_prevented TRUE
_pdml_gim_sampling 5000
_pdml_gim_staggered FALSE
_pdml_slaves_diff_part TRUE
_percent_flashback_buf_partial_full 50
_pga_large_extent_size 1048576
_pga_max_size 449617920
_pgactx_cap_stacks FALSE
_pivot_implementation_method CHOOSE
_pkt_enable FALSE
_pkt_pmon_interval 50
_pkt_start FALSE
_plan_outline_data TRUE
_plan_verify_improvement_margin 150
_plan_verify_local_time_limit 0
_plsql_anon_block_code_type INTERPRETED
_plsql_cache_enable TRUE
_plsql_dump_buffer_events
_plsql_max_stack_size 0
_plsql_minimum_cache_hit_percent 20
_plsql_native_frame_threshold 4294967294
_plsql_nvl_optimize FALSE
_pmon_dead_blkrs_alive_chk_rate_secs 3
_pmon_dead_blkrs_max_blkrs 200
_pmon_dead_blkrs_max_cleanup_attempts 5
_pmon_dead_blkrs_scan_rate_secs 3
_pmon_enable_dead_blkrs TRUE
_pmon_load_constants 300,192,64,3,10,10,0,0
_pmon_max_consec_posts 5
_post_wait_queues_dynamic_queues 40
_post_wait_queues_num_per_class
_pqq_debug_txn_act FALSE
_pqq_enabled TRUE
_pre_rewrite_push_pred TRUE
_precompute_gid_values TRUE
_pred_move_around TRUE
_predicate_elimination_enabled TRUE
_prescomm FALSE
_print_refresh_schedule false
_private_memory_address
_project_view_columns TRUE
_projection_pushdown TRUE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_projection_pushdown_debug 0
_prop_old_enabled FALSE
_protect_frame_heaps FALSE
_ptn_cache_threshold 0
_push_join_predicate TRUE
_push_join_union_view TRUE
_push_join_union_view2 TRUE
_px_adaptive_offload_pecentage 0
_px_adaptive_offload_threshold 10
_px_async_getgranule FALSE
_px_bind_peek_sharing TRUE
_px_broadcast_fudge_factor 100
_px_buffer_ttl 30
_px_chunklist_count_ratio 8
_px_compilation_debug 0
_px_compilation_trace 0
_px_dump_12805_source TRUE
_px_dynamic_opt TRUE
_px_dynamic_sample_size 50
_px_execution_services_enabled TRUE
_px_freelist_latch_divisor 2
_px_gim_factor 100
_px_granule_batch_size 10
_px_granule_randomize TRUE
_px_granule_size 1000000
_px_hold_time 0
_px_index_sampling 200
_px_index_sampling_objsize TRUE
_px_io_process_bandwidth 200
_px_io_system_bandwidth 0
_px_kxib_tracing 0
_px_load_factor 300
_px_load_publish_interval 200
_px_loc_msg_cost 1000
_px_max_granules_per_slave 100
_px_max_map_val 32
_px_max_message_pool_pct 40
_px_min_granules_per_slave 13
_px_minus_intersect TRUE
_px_net_msg_cost 10000
_px_no_granule_sort FALSE
_px_no_stealing FALSE
_px_nss_planb TRUE
_px_numa_stealing_enabled TRUE
_px_numa_support_enabled TRUE
_px_partition_scan_enabled TRUE
_px_partition_scan_threshold 64
_px_proc_constrain TRUE
_px_pwg_enabled TRUE
_px_round_robin_rowcnt 1000
_px_rownum_pd TRUE
_px_send_timeout 300
_px_slaves_share_cursors 0
_px_trace none
_px_ual_serial_input TRUE
_px_xtgranule_size 10000
_qa_control 0
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_qa_lrg_type 0
_query_cost_rewrite TRUE
_query_execution_cache_max_size 131072
_query_mmvrewrite_maxcmaps 20
_query_mmvrewrite_maxdmaps 10
_query_mmvrewrite_maxinlists 5
_query_mmvrewrite_maxintervals 5
_query_mmvrewrite_maxpreds 10
_query_mmvrewrite_maxqryinlistvals 500
_query_mmvrewrite_maxregperm 512
_query_on_physical TRUE
_query_rewrite_1 TRUE
_query_rewrite_2 TRUE
_query_rewrite_drj TRUE
_query_rewrite_expression TRUE
_query_rewrite_fpc TRUE
_query_rewrite_fudge 90
_query_rewrite_jgmigrate TRUE
_query_rewrite_maxdisjunct 257
_query_rewrite_or_error FALSE
_query_rewrite_setopgrw_enable TRUE
_query_rewrite_vop_cleanup TRUE
_queue_buffer_max_dump_len 65536
_rbr_ckpt_tracing 0
_rcfg_disable_verify TRUE
_rcfg_parallel_fixwrite TRUE
_rcfg_parallel_replay TRUE
_rcfg_parallel_verify TRUE
_rdbms_compatibility 10.1
_rdbms_internal_fplib_enabled FALSE
_rdbms_internal_fplib_raise_errors FALSE
_read_only_violation_dump_to_trace FALSE
_read_only_violation_max_count 500
_read_only_violation_max_count_per_module 100
_readable_standby_sync_timeout 10
_real_time_apply_sim 0
_realfree_heap_max_size 32768
_realfree_heap_mode 0
_realfree_heap_pagesize_hint 65536
_reasonable_scn_offset_seconds 0
_recoverable_recovery_batch_percent 50
_recovery_asserts FALSE
_recovery_percentage 50
_recovery_read_limit 1024
_recovery_skip_cfseq_check FALSE
_recovery_verify_writes FALSE
_recursive_imu_transactions FALSE
_recursive_with_max_recursion_level 0
_redo_compatibility_check FALSE
_redo_read_from_memory TRUE
_redo_transport_compress_all TRUE
_redo_transport_sanity_check 0
_redo_transport_stall_time 360
_redo_transport_stall_time_long 3600
_redo_transport_stream_test TRUE
_redo_transport_stream_writes TRUE
_redo_transport_vio_size_req 4294967294
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_reduce_sby_log_scan TRUE
_release_insert_threshold 5
_reliable_block_sends TRUE
_relocation_commit_batch_size 8
_remove_aggr_subquery TRUE
_rep_base_path
_replace_virtual_columns TRUE
_reset_maxcap_history 10
_resource_manager_always_off FALSE
_resource_manager_always_on TRUE
_resource_manager_plan
_restore_maxopenfiles 8
_restore_spfile
_result_cache_auto_dml_monitoring_duration 15
_result_cache_auto_dml_monitoring_slots 4
_result_cache_auto_dml_threshold 16
_result_cache_auto_dml_trend_threshold 20
_result_cache_auto_execution_threshold 1
_result_cache_auto_size_threshold 100
_result_cache_auto_time_distance 300
_result_cache_auto_time_threshold 1000
_result_cache_block_size 1024
_result_cache_copy_block_count 1
_result_cache_global TRUE
_result_cache_timeout 10
_reuse_index_loop 5
_right_outer_hash_enable TRUE
_rm_cluster_interconnects
_rm_numa_sched_enable FALSE
_rm_numa_simulation_cpus 0
_rm_numa_simulation_pgs 0
_rman_io_priority 3
_rman_restore_through_link FALSE
_rollback_segment_count 0
_rollback_segment_initial 1
_rollback_stopat 0
_row_cache_cursors 20
_row_cr TRUE
_row_locking always
_row_shipping_explain FALSE
_row_shipping_threshold 80
_rowsource_execution_statistics FALSE
_rowsource_profiling_statistics TRUE
_rowsource_statistics_sampfreq 128
_rowsrc_trace_level 0
_rta_sync_wait_timeout 10
_rtc_infeasible_threshold 25
_sample_rows_per_block 4
_scatter_gcs_resources FALSE
_scatter_gcs_shadows FALSE
_sched_delay_max_samples 4
_sched_delay_measurement_sleep_us 1000
_sched_delay_os_tick_granularity_us 16000
_sched_delay_sample_collection_thresh_ms 200
_sched_delay_sample_interval_ms 1000
_scn_wait_interface_max_backoff_time_secs 600
_scn_wait_interface_max_timeout_secs 2147483647
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_sdiag_crash NONE
_sec_enable_test_rpcs FALSE
_second_spare_parameter
_securefile_timers FALSE
_securefiles_bulkinsert FALSE
_securefiles_concurrency_estimate 12
_securefiles_fg_retry 100
_securefiles_forceflush FALSE
_securefiles_memory_percentofSGA 20
_select_any_dictionary_security_enabled FALSE
_selectivity_for_srf_enabled FALSE
_selfjoin_mv_duplicates TRUE
_selftune_checkpoint_write_pct 3
_selftune_checkpointing_lag 300
_sem_per_semid
_send_ast_to_foreground AUTO
_send_close_with_block TRUE
_send_requests_to_pi TRUE
_serial_direct_read auto
_serial_recovery FALSE
_serializable FALSE
_serialize_lgwr_sync_io FALSE
_service_cleanup_timeout 30
_session_allocation_latches 32
_session_cached_instantiations 60
_session_context_size 10000
_session_idle_bit_latches 0
_session_page_extent 2048
_session_wait_history 10
_set_mgd_recovery_state 0
_seventeenth_spare_parameter
_seventh_spare_parameter
_sga_clear_dump FALSE
_sga_early_trace 0
_sga_locking none
_shared_io_pool_buf_size 1048576
_shared_io_pool_debug_trc 0
_shared_io_pool_size 0
_shared_io_set_value FALSE
_shared_iop_max_size 536870912
_shared_pool_max_size 0
_shared_pool_minsize_on FALSE
_shared_pool_reserved_min_alloc 4400
_shared_pool_reserved_pct 5
_shared_server_load_balance 0
_shared_server_num_queues 3
_shmprotect 0
_short_stack_timeout_ms 30000
_show_mgd_recovery_state FALSE
_shrunk_aggs_disable_threshold 60
_shrunk_aggs_enabled TRUE
_shutdown_completion_timeout_mins 60
_side_channel_batch_size 200
_side_channel_batch_timeout 6
_side_channel_batch_timeout_ms 500
_simple_view_merging TRUE
_simulate_disk_sectorsize 0
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_simulate_io_wait 0
_simulate_mem_transfer FALSE
_simulator_bucket_mindelta 8192
_simulator_internal_bound 10
_simulator_lru_rebalance_sizthr 5
_simulator_lru_rebalance_thresh 10240
_simulator_lru_scan_count 8
_simulator_pin_inval_maxcnt 16
_simulator_reserved_heap_count 4096
_simulator_reserved_obj_count 1024
_simulator_sampling_factor 2
_simulator_upper_bound_multiple 2
_single_process FALSE
_siop_flashback_scandepth 20
_siop_perc_of_bc_x100 2500
_sixteenth_spare_parameter
_sixth_spare_parameter
_skgxp_ctx_flags1 0
_skgxp_ctx_flags1mask 0
_skgxp_dynamic_protocol 0
_skgxp_gen_ant_off_rpc_timeout_in_sec 30
_skgxp_gen_ant_ping_misscount 3
_skgxp_gen_rpc_no_path_check_in_sec 5
_skgxp_gen_rpc_timeout_in_sec 300
_skgxp_inets
_skgxp_min_rpc_rcv_zcpy_len 0
_skgxp_min_zcpy_len 0
_skgxp_reaping 1000
_skgxp_rgn_ports 0
_skgxp_spare_param1
_skgxp_spare_param2
_skgxp_spare_param3
_skgxp_spare_param4
_skgxp_spare_param5
_skgxp_udp_ach_reaping_time 120
_skgxp_udp_ack_delay 0
_skgxp_udp_enable_dynamic_credit_mgmt 0
_skgxp_udp_hiwat_warn 1000
_skgxp_udp_interface_detection_time_secs 60
_skgxp_udp_keep_alive_ping_timer_secs 300
_skgxp_udp_lmp_mtusize 0
_skgxp_udp_lmp_on FALSE
_skgxp_udp_timed_wait_buffering 1024
_skgxp_udp_timed_wait_seconds 5
_skgxp_udp_use_tcb TRUE
_skgxp_zcpy_flags 0
_skgxpg_last_parameter 26
_skip_assume_msg TRUE
_skip_trstamp_check FALSE
_slave_mapping_enabled TRUE
_slave_mapping_group_size 0
_slave_mapping_skew_ratio 2
_small_table_threshold 7213
_smm_advice_enabled TRUE
_smm_advice_log_size 0
_smm_auto_cost_enabled TRUE
_smm_auto_max_io_size 248
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_smm_auto_min_io_size 56
_smm_bound 0
_smm_control 0
_smm_freeable_retain 5120
_smm_isort_cap 102400
_smm_max_size 219540
_smm_min_size 1024
_smm_px_max_size 1097728
_smm_retain_size 0
_smm_trace 0
_smon_internal_errlimit 100
_smon_undo_seg_rescan_limit 10
_smu_debug_mode 0
_smu_error_simulation_site 0
_smu_error_simulation_type 0
_smu_timeouts
_sort_elimination_cost_ratio 0
_sort_multiblock_read_count 2
_sort_spill_threshold 0
_space_align_size 1048576
_spare_test_parameter 0
_spawn_diag_opts 0
_spawn_diag_thresh_secs 30
_spin_count 2000
_spr_max_rules 10000
_spr_push_pred_refspr TRUE
_spr_use_AW_AS TRUE
_spr_use_hash_table FALSE
_sql_analyze_enable_auto_txn FALSE
_sql_analyze_parse_model 2
_sql_compatibility 0
_sql_connect_capability_override 0
_sql_connect_capability_table
_sql_hash_debug 0
_sql_model_unfold_forloops RUN_TIME
_sql_ncg_mode OFF
_sql_plan_management_control 0
_sqlexec_progression_cost 1000
_sqlmon_binds_xml_format default
_sqlmon_max_plan 640
_sqlmon_max_planlines 300
_sqlmon_recycle_time 60
_sqlmon_threshold 5
_sqltune_category_parsed DEFAULT
_srvntfn_job_deq_timeout 60
_srvntfn_jobsubmit_interval 3
_srvntfn_max_concurrent_jobs 20
_srvntfn_q_msgcount 50
_srvntfn_q_msgcount_inc 100
_sscr_dir
_sscr_osdir
_sta_control 0
_stack_guard_level 0
_standby_causal_heartbeat_timeout 2
_standby_flush_mode SLFLUSH
_standby_implicit_rcv_timeout 1
_standby_switchover_timeout 120
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_static_backgrounds
_statistics_based_srf_enabled TRUE
_step_down_limit_in_pct 1
_streams_pool_max_size 0
_subquery_pruning_cost_factor 20
_subquery_pruning_enabled TRUE
_subquery_pruning_mv_enabled FALSE
_subquery_pruning_reduction 50
_switchover_to_standby_option OPEN_ONE
_switchover_to_standby_switch_log TRUE
_swrf_metric_frequent_mode FALSE
_swrf_mmon_dbfus TRUE
_swrf_mmon_flush TRUE
_swrf_mmon_metrics TRUE
_swrf_on_disk_enabled TRUE
_swrf_test_action 0
_swrf_test_dbfus FALSE
_sync_primary_wait_time 5
_synonym_repoint_tracing FALSE
_sysaux_test_param 1
_system_api_interception_debug FALSE
_system_index_caching 0
_system_trig_enabled TRUE
_ta_lns_wait_for_arch_log 20
_table_lookup_prefetch_size 40
_table_lookup_prefetch_thresh 2
_table_scan_cost_plus_one TRUE
_tablespaces_per_transaction 10
_target_rba_max_lag_percentage 81
_tdb_debug_mode 16
_temp_tran_block_threshold 100
_temp_tran_cache TRUE
_tenth_spare_parameter
_test_ksusigskip 5
_test_param_1 25
_test_param_2
_test_param_3
_test_param_4
_test_param_5 25
_test_param_6 0
_third_spare_parameter
_thirteenth_spare_parameter
_threshold_alerts_enable 1
_timemodel_collection TRUE
_timeout_actions_enabled TRUE
_timer_precision 10
_total_large_extent_memory 0
_tq_dump_period 0
_trace_buffer_wait_timeouts 0
_trace_buffers ALL:256
_trace_dump_all_procs FALSE
_trace_dump_client_buckets TRUE
_trace_dump_cur_proc_only FALSE
_trace_dump_static_only FALSE
_trace_events
_trace_files_public FALSE
_trace_kqlidp FALSE
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_trace_navigation_scope global
_trace_pin_time 0
_trace_pool_size
_trace_processes ALL
_trace_virtual_columns FALSE
_transaction_auditing TRUE
_transaction_recovery_servers 0
_transient_logical_clear_hold_mrp_bit FALSE
_truncate_optimization_enabled TRUE
_tsenc_tracing 0
_tsm_connect_string
_tsm_disable_auto_cleanup 1
_tstz_localtime_bypass FALSE
_tts_allow_charset_mismatch FALSE
_twelfth_spare_parameter
_twentieth_spare_parameter
_two_pass TRUE
_two_pass_reverse_polish_enabled TRUE
_uga_cga_large_extent_size 262144
_ultrafast_latch_statistics TRUE
_undo_autotune TRUE
_undo_block_compression TRUE
_undo_debug_mode 0
_undo_debug_usage 0
_union_rewrite_for_gs YES_GSET_MVS
_unnest_subquery TRUE
_unused_block_compression TRUE
_update_datafile_headers_with_space_information FALSE
_use_adaptive_log_file_sync TRUE
_use_best_fit FALSE
_use_column_stats_for_function TRUE
_use_hybrid_encryption_mode FALSE
_use_ism TRUE
_use_ism_for_pga TRUE
_use_nosegment_indexes FALSE
_use_platform_compression_lib FALSE
_use_platform_encryption_lib TRUE
_use_realfree_heap TRUE
_use_seq_process_cache TRUE
_use_vector_post TRUE
_use_zero_copy_io TRUE
_validate_flashback_database FALSE
_validate_readmem_redo OFF
_vendor_lib_loc
_verify_fg_log_checksum FALSE
_verify_flashback_redo TRUE
_verify_undo_quota FALSE
_very_large_object_threshold 500
_very_large_partitioned_table 1024
_virtual_column_overload_allowed TRUE
_vkrm_schedule_interval 10
_vktm_assert_thresh 30
_wait_breakup_threshold_csecs 600
_wait_breakup_time_csecs 300
_wait_for_sync TRUE
_wait_samples_max_sections 40
_wait_samples_max_time_secs 120
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_wait_tracker_interval_secs 10
_wait_tracker_num_intervals 0
_wait_yield_hp_mode yield
_wait_yield_mode yield
_wait_yield_sleep_freq 100
_wait_yield_sleep_time_msecs 1
_wait_yield_yield_freq 20
_walk_insert_threshold 0
_watchpoint_on FALSE
_wcr_control 0
_windowfunc_optimization_settings 0
_with_subquery OPTIMIZER
_write_clones 3
_xengem_devname DEFAULT
_xengem_diagmode OFF
_xengem_enabled TRUE
_xpl_peeked_binds_log_size 8192
_xpl_trace 0
_xsolapi_auto_materialization_bound 20
_xsolapi_auto_materialization_type PRED_AND_RC
_xsolapi_build_trace FALSE
_xsolapi_debug_output SUPPRESS
_xsolapi_densify_cubes TABULAR
_xsolapi_dimension_group_creation OVERFETCH
_xsolapi_dml_trace
_xsolapi_fetch_type PARTIAL
_xsolapi_fix_vptrs TRUE
_xsolapi_generate_with_clause FALSE
_xsolapi_hierarchy_value_type unique
_xsolapi_load_at_process_start NEVER
_xsolapi_materialization_rowcache_min_rows_for_use 1
_xsolapi_materialize_sources TRUE
_xsolapi_metadata_reader_mode DEFAULT
_xsolapi_odbo_mode FALSE
_xsolapi_opt_aw_position TRUE
_xsolapi_optimize_suppression TRUE
_xsolapi_precompute_subquery TRUE
_xsolapi_remove_columns_for_materialization TRUE
_xsolapi_set_nls TRUE
_xsolapi_share_executors TRUE
_xsolapi_source_trace FALSE
_xsolapi_sql_all_multi_join_non_base_hints
_xsolapi_sql_all_non_base_hints
_xsolapi_sql_auto_dimension_hints FALSE
_xsolapi_sql_auto_measure_hints TRUE
_xsolapi_sql_dimension_hints
_xsolapi_sql_enable_aw_join TRUE
_xsolapi_sql_enable_aw_qdr_merge TRUE
_xsolapi_sql_hints
_xsolapi_sql_measure_hints
_xsolapi_sql_minus_threshold 1000
_xsolapi_sql_optimize TRUE
_xsolapi_sql_prepare_stmt_cache_size 16
_xsolapi_sql_remove_columns TRUE
_xsolapi_sql_result_set_cache_size 32
_xsolapi_sql_symmetric_predicate TRUE
_xsolapi_sql_top_dimension_hints
KSPPINM KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_xsolapi_sql_top_measure_hints
_xsolapi_sql_use_bind_variables TRUE
_xsolapi_stringify_order_levels FALSE
_xsolapi_support_mtm FALSE
_xsolapi_suppression_aw_mask_threshold 1000
_xsolapi_suppression_chunk_size 4000
_xsolapi_use_models TRUE
_xsolapi_use_olap_dml TRUE
_xsolapi_use_olap_dml_for_rank TRUE
_xt_coverage none
_xt_trace none
_xtbuffer_size 0
_xtts_allow_pre10 FALSE
_xtts_set_platform_info FALSE
2405 rows selected.
SQL>
No comments:
Post a Comment