SQL> SELECT nam.ksppinm NAME, val.ksppstvl VALUE FROM x$ksppi nam, x$ksppsv val WHERE nam.indx = val.indx order by 1;
NAME VALUE
--------------------------------------------------- ----------------------------------------------------------------------------------------------------
O7_DICTIONARY_ACCESSIBILITY FALSE
_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 394264576
__dg_broker_service_names
__java_pool_size 4194304
__large_pool_size 4194304
__oracle_base /home/oracle/zxindbf
__pga_aggregate_target 0
__sga_target 595591168
__shared_io_pool_size 0
__shared_pool_size 184549376
__streams_pool_size 0
_abort_recovery_on_join FALSE
_accept_versions
_active_instance_count
_active_session_idle_limit 0
_active_session_legacy_behavior FALSE
_active_standby_fast_reconfiguration TRUE
_adaptive_direct_read TRUE
_adaptive_direct_write TRUE
_adaptive_fetch_enabled TRUE
_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
_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_drop_snapshot_standby_grsp FALSE
_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_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_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_lvm_resilvering FALSE
_asm_allow_only_raw_disks TRUE
_asm_ausize 1048576
_asm_automatic_rezone TRUE
_asm_blksize 4096
_asm_compatibility 10.1
_asm_dbmsdg_nohdrchk FALSE
_asm_direct_con_expire_time 120
_asm_disable_amdu_dump FALSE
_asm_disable_multiple_instance_check FALSE
_asm_disable_profilediscovery FALSE
_asm_disable_smr_creation FALSE
_asm_disk_repair_time 14400
_asm_emulate_nfs_disk FALSE
_asm_emulmax 10000
_asm_emultimeout 0
_asm_fob_tac_frequency 9
_asm_force_quiesce FALSE
_asm_hbeatwaitquantum 2
_asm_imbalance_tolerance 3
_asm_instlock_quota 0
_asm_kfdpevent 0
_asm_kfioevent 0
_asm_libraries ufs
_asm_lsod_bucket_size 13
_asm_max_cod_strides 5
_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_repairquantum 60
_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_wait_time 18
_asmlib_test 0
_asmsid asm
_assm_default TRUE
_assm_force_fetchmeta FALSE
_async_recovery_claims TRUE
_async_recovery_reads TRUE
_async_ts_threshold 1
_auto_assign_cg_for_sessions FALSE
_auto_bmr disabled
_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 FALSE
_auto_manage_exadata_disks TRUE
_auto_manage_ioctl_bufsz 2048
_auto_manage_num_tries 3
_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
_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_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
_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_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_predicate_enabled TRUE
_bloom_predicate_pushdown_to_storage TRUE
_bloom_pruning_enabled TRUE
_bloom_pushing_max 524288
_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 FALSE
_bump_highwater_mark_count 0
_bwr_for_flushed_pi TRUE
_cache_stats_monitor FALSE
_capture_buffer_size 65536
_capture_publisher_flow_control_threshold 0
_case_sensitive_logon TRUE
_causal_standby_wait_timeout 20
_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
_cell_offload_capabilities_enabled 0
_cell_offload_hybridcolumnar TRUE
_cell_offload_predicate_reordering_enabled FALSE
_cell_offload_timezone TRUE
_cell_range_scan_enabled 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
_check_block_after_checksum TRUE
_check_block_new_invariant_for_flashback FALSE
_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 10.2.0.1.0
_connect_by_use_union_all TRUE
_controlfile_autobackup_delay 300
_controlfile_block_size 0
_controlfile_enqueue_dump FALSE
_controlfile_enqueue_holding_time 120
_controlfile_enqueue_holding_time_tracking_size 10
_controlfile_enqueue_timeout 900
_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
_create_table_in_any_cluster FALSE
_cursor_bind_capture_area_size 400
_cursor_bind_capture_interval 900
_cursor_cache_time 1800
_cursor_db_buffers_pinned 99
_cursor_features_enabled 2
_cursor_plan_enabled TRUE
_cursor_plan_hash_version 1
_cursor_plan_unparse_enabled TRUE
_cursor_stats_bucket 15
_cursor_stats_heap 4
_cvw_enable_weak_checking TRUE
_datafile_cow FALSE
_datafile_write_errors_crash_instance FALSE
_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 55974
_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
_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 131072
_db_block_hash_latches 4096
_db_block_header_guard_level 0
_db_block_hi_priority_batch_size 0
_db_block_known_clean_pct 2
_db_block_lru_latches 8
_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_crx_check FALSE
_db_cache_miss_check_les 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_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 16
_db_file_format_io_buffers 4
_db_file_noncontig_mblock_read_count 11
_db_file_optimizer_read_count 16
_db_flash_cache_keep_limit 80
_db_handles 2750
_db_handles_cached 5
_db_hot_block_tracking FALSE
_db_index_block_checking TRUE
_db_l2_tracing 0
_db_large_dirty_queue 25
_db_lost_write_checking 0
_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 4190016
_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 33489896
_dbrm_quantum
_dbrm_readylist_chk 1
_dbrm_runchk 0
_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_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_log_boundary_ckpt TRUE
_defer_log_count 2
_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_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_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_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
_disable_12751 FALSE
_disable_active_influx_move FALSE
_disable_adaptive_shrunk_aggregation FALSE
_disable_autotune_gtx FALSE
_disable_cell_optimized_backups FALSE
_disable_cpu_check 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_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_sec_ticks FALSE
_disable_selftune_checkpointing FALSE
_disable_streams_pool_auto_tuning FALSE
_disable_sun_rsm TRUE
_disable_system_state 4294967294
_disable_system_state_wait_samples FALSE
_disable_temp_tablespace_alerts FALSE
_disable_thread_internal_disable FALSE
_disable_txn_alert 0
_disable_undo_tablespace_alerts FALSE
_disable_vktm 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_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
_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
_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
_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_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_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_refresh_schedule TRUE
_enable_reliable_latch_waits TRUE
_enable_rlb TRUE
_enable_row_shipping TRUE
_enable_sb_detection TRUE
_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
_enqueue_hash 1729
_enqueue_hash_chain_latches 1
_enqueue_locks 9990
_enqueue_paranoia_mode_enabled FALSE
_enqueue_resources 3944
_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 1
_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
_fifth_spare_parameter
_file_size_increase_increment 52428800
_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_dynamic_enable TRUE
_flashback_dynamic_enable_failure 0
_flashback_format_chunk_mb 4
_flashback_format_chunk_mb_dwrite 16
_flashback_fuzzy_barrier TRUE
_flashback_generation_buffer_size 4194304
_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
_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_standby_barrier_interval 1
_flashback_verbose_info FALSE
_flashback_write_max_loop_limit 10
_flush_redo_to_standby 0
_flush_undo_after_tx_recovery TRUE
_force_arch_compress 0
_force_datefold_trunc FALSE
_force_hsc_compress FALSE
_force_oltp_compress FALSE
_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
_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_cr_server_read_wait TRUE
_gc_defer_ping_index_only TRUE
_gc_defer_time 3
_gc_delta_push_compression 3072
_gc_delta_push_max_level 100
_gc_delta_push_objects 0
_gc_down_convert_after_keep TRUE
_gc_element_percent 110
_gc_flush_during_affinity TRUE
_gc_fusion_compression 1536
_gc_global_checkpoint_scn TRUE
_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_long_query_threshold 0
_gc_max_downcvt 256
_gc_maximum_bids 0
_gc_policy_minimum 1500
_gc_policy_time 10
_gc_read_mostly_flush_check FALSE
_gc_read_mostly_locking 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
_gcs_disable_remote_handles FALSE
_gcs_fast_reconfig TRUE
_gcs_latches 0
_gcs_pkey_history 4000
_gcs_process_in_recovery TRUE
_gcs_res_per_bucket 16
_gcs_resources
_gcs_shadow_locks
_gcs_testing 0
_generalized_pruning_enabled TRUE
_ges_dd_debug 1
_ges_diagnostics TRUE
_ges_diagnostics_asm_dump_level 11
_ges_health_check 1
_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 30
_hang_ignored_hangs_interval 30
_hang_log_incidents FALSE
_hang_long_wait_time_threshold 0
_hang_lws_file_count 5
_hang_lws_file_time_limit 1800
_hang_msg_checksum_enabled TRUE
_hang_output_suspected_hangs FALSE
_hang_resolution_confidence_promotion FALSE
_hang_resolution_policy HIGH
_hang_resolution_scope OFF
_hang_signature_list_output_frequency 25
_hang_statistics_collection_interval 0
_hang_statistics_collection_react_ma_alpha 30
_hang_statistics_collection_react_ma_sum_delta_cnt 15
_hang_statistics_collection_smooth_ma_alpha 8
_hard_protection FALSE
_hash_join_enabled TRUE
_hash_multiblock_io_count 0
_heur_deadlock_resolution_secs 0
_high_priority_process_num_yields_before_sleep 1000
_high_priority_processes LMS*|VKTM
_high_server_threshold 0
_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
_hm_verification_interval 30
_hwm_sync_threshold 10
_idl_conventional_index_maintenance TRUE
_idle_session_kill_enabled TRUE
_idxrb_rowincr 100000000
_ignore_desc_in_index 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_device_type controlfile
_imr_disk_voting_interval 3
_imr_diskvote_implementation auto
_imr_evicted_member_kill TRUE
_imr_evicted_member_kill_wait 20
_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
_in_memory_undo TRUE
_incremental_recovery_ckpt_min_batch 500
_index_join_enabled TRUE
_index_prefetch_factor 100
_index_scan_check_skip_corrupt FALSE
_init_granule_interval 10
_init_sql_file ?/rdbms/admin/sql.bsq
_inject_startup_fault 0
_inline_sql_in_plsql FALSE
_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
_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_caching_enabled TRUE
_kcfis_cell_passthru_enabled FALSE
_kcfis_control1 0
_kcfis_control2 0
_kcfis_control3 0
_kcfis_control4 0
_kcfis_control5 0
_kcfis_control6 0
_kcfis_fault_control 0
_kcfis_max_cached_sessions 10
_kcfis_metadata_io_write_enabled TRUE
_kcfis_oss_io_size 0
_kcfis_rdbms_blockio_enabled FALSE
_kcfis_read_buffer_limit 0
_kcfis_reuse_any_cached_enabled TRUE
_kcfis_stats_level 0
_kcfis_storageidx_diag_mode FALSE
_kcfis_storageidx_disabled FALSE
_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
_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 TRUE
_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_itree_entries 0
_kdli_memory_protect FALSE
_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_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_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
_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_lobcmpadp FALSE
_kdlxp_lobcmplevel 2
_kdlxp_lobcmprciver 1
_kdlxp_lobcompress FALSE
_kdlxp_lobdeduplicate FALSE
_kdlxp_lobdedupvalidate TRUE
_kdlxp_lobencrypt FALSE
_kdlxp_mincmp 20
_kdlxp_minxfm_size 32768
_kdlxp_spare1 0
_kdlxp_xfmcache TRUE
_kdt_buffering TRUE
_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
_kffmap_hash_size 1024
_kffmop_hash_size 2048
_kfm_disable_set_fence FALSE
_kghdsidx_count 1
_kgl_bucket_count 9
_kgl_debug
_kgl_fixed_extents TRUE
_kgl_hash_collision FALSE
_kgl_heap_size 4096
_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_multi_instance_invalidation TRUE
_kgl_multi_instance_lock TRUE
_kgl_multi_instance_pin TRUE
_kgl_mutex_wait_time 0
_kgl_time_to_wait_for_locks 15
_kglsim_maxmem_percent 5
_kgsb_threshold_size 16777216
_kgx_latches 1024
_kgx_spin_count 255
_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_free_cursor_stat_pct 10
_kokli_cache_size 128
_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
_kse_die_timeout 60000
_kse_pc_table_size 256
_kse_signature_entries 0
_kse_signature_limit 7
_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
_ksmb_debug 0
_ksmd_protect_mode off
_ksmg_granule_locking_status 1
_ksmg_granule_size 4194304
_ksmg_lock_check_interval
_ksmg_lock_reacquire_count 5
_kspol_tac_timeout 5
_ksr_unit_test_processes 0
_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_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_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
_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
_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
_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_pga_lim 0
_left_nested_loops_random TRUE
_lgwr_async_broadcasts 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_ta_sim_err 0
_library_cache_advice TRUE
_lightweight_hdrs TRUE
_like_with_bind_as_equality FALSE
_limit_itls 20
_lm_activate_lms_threshold 100
_lm_asm_enq_hashing TRUE
_lm_batch_compression_threshold 0
_lm_better_ddvictim TRUE
_lm_cache_lvl0_cleanup 0
_lm_cache_res_cleanup 25
_lm_cache_res_type TMHWDI
_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_disable 0
_lm_drm_max_requests 100
_lm_drm_object_scan TRUE
_lm_drm_window 0
_lm_drm_xlatch 0
_lm_dynamic_lms FALSE
_lm_dynamic_load TRUE
_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_file_affinity
_lm_global_posts TRUE
_lm_idle_connection_check TRUE
_lm_idle_connection_check_interval 140
_lm_idle_connection_kill TRUE
_lm_kill_fg_on_timeout TRUE
_lm_lmd_waittime 8
_lm_lmon_nowait_latch TRUE
_lm_lms 0
_lm_lms_waittime 8
_lm_locks 12000
_lm_master_weight 1
_lm_max_lms 0
_lm_msg_batch_size 0
_lm_msg_cleanup_interval 3000
_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_rcfg_timeout 489
_lm_rcvinst TRUE
_lm_rcvr_hang_allow_time 70
_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
_lm_share_lock_opt FALSE
_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_validate_pbatch FALSE
_lm_validate_resource_type FALSE
_lm_xids 352
_lmn_compression TRUE
_load_without_compile none
_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_blocks_during_backup TRUE
_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 1
_log_private_mul 5
_log_private_parallelism_mul 10
_log_read_buffer_size 8
_log_read_buffers 8
_log_simultaneous_copies 2
_log_space_errors TRUE
_log_switch_timeout 0
_logout_storm_rate 0
_logout_storm_retrycnt 600
_logout_storm_timeout 5
_longops_enabled TRUE
_low_server_threshold 0
_ltc_trace 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_cr_rollbacks 0
_max_exponential_sleep 0
_max_io_size 1048576
_max_large_io 0
_max_lns_shutdown_archival_time 30
_max_protocol_support 10000
_max_shrink_obj_stats 0
_max_sleep_holding_latch 4
_max_small_io 0
_max_spacebg_slaves 10
_max_spacebg_tasks 1000
_max_temp_overhead 0
_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 1100
_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
_mpmt_enabled FALSE
_multi_instance_pmr TRUE
_multi_join_key_table_lookup TRUE
_multiple_instance_recovery FALSE
_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_pkfk_data_units_opt auto
_mv_refresh_pkfk_relationship_opt TRUE
_mv_refresh_rebuild_percentage 10
_mv_refresh_selections 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_mav_fast_oncommit_enabled TRUE
_new_initial_join_orders TRUE
_new_sort_cost_estimate TRUE
_newsort_enabled TRUE
_newsort_ordered_pct 63
_newsort_type 0
_nlj_batching_enabled 1
_nlj_batching_misses_enabled 1
_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 1
_numa_trace_level 0
_number_cached_attributes 10
_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_function_merge_threshold 529
_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_store_probability 100
_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
-------- -------- -------- -----------
--------------------------------------------------- ----------------------------------------------------------------------------------------------------
O7_DICTIONARY_ACCESSIBILITY FALSE
_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 394264576
__dg_broker_service_names
__java_pool_size 4194304
__large_pool_size 4194304
__oracle_base /home/oracle/zxindbf
__pga_aggregate_target 0
__sga_target 595591168
__shared_io_pool_size 0
__shared_pool_size 184549376
__streams_pool_size 0
_abort_recovery_on_join FALSE
_accept_versions
_active_instance_count
_active_session_idle_limit 0
_active_session_legacy_behavior FALSE
_active_standby_fast_reconfiguration TRUE
_adaptive_direct_read TRUE
_adaptive_direct_write TRUE
_adaptive_fetch_enabled TRUE
_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
_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_drop_snapshot_standby_grsp FALSE
_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_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_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_lvm_resilvering FALSE
_asm_allow_only_raw_disks TRUE
_asm_ausize 1048576
_asm_automatic_rezone TRUE
_asm_blksize 4096
_asm_compatibility 10.1
_asm_dbmsdg_nohdrchk FALSE
_asm_direct_con_expire_time 120
_asm_disable_amdu_dump FALSE
_asm_disable_multiple_instance_check FALSE
_asm_disable_profilediscovery FALSE
_asm_disable_smr_creation FALSE
_asm_disk_repair_time 14400
_asm_emulate_nfs_disk FALSE
_asm_emulmax 10000
_asm_emultimeout 0
_asm_fob_tac_frequency 9
_asm_force_quiesce FALSE
_asm_hbeatwaitquantum 2
_asm_imbalance_tolerance 3
_asm_instlock_quota 0
_asm_kfdpevent 0
_asm_kfioevent 0
_asm_libraries ufs
_asm_lsod_bucket_size 13
_asm_max_cod_strides 5
_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_repairquantum 60
_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_wait_time 18
_asmlib_test 0
_asmsid asm
_assm_default TRUE
_assm_force_fetchmeta FALSE
_async_recovery_claims TRUE
_async_recovery_reads TRUE
_async_ts_threshold 1
_auto_assign_cg_for_sessions FALSE
_auto_bmr disabled
_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 FALSE
_auto_manage_exadata_disks TRUE
_auto_manage_ioctl_bufsz 2048
_auto_manage_num_tries 3
_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
_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_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
_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_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_predicate_enabled TRUE
_bloom_predicate_pushdown_to_storage TRUE
_bloom_pruning_enabled TRUE
_bloom_pushing_max 524288
_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 FALSE
_bump_highwater_mark_count 0
_bwr_for_flushed_pi TRUE
_cache_stats_monitor FALSE
_capture_buffer_size 65536
_capture_publisher_flow_control_threshold 0
_case_sensitive_logon TRUE
_causal_standby_wait_timeout 20
_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
_cell_offload_capabilities_enabled 0
_cell_offload_hybridcolumnar TRUE
_cell_offload_predicate_reordering_enabled FALSE
_cell_offload_timezone TRUE
_cell_range_scan_enabled 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
_check_block_after_checksum TRUE
_check_block_new_invariant_for_flashback FALSE
_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 10.2.0.1.0
_connect_by_use_union_all TRUE
_controlfile_autobackup_delay 300
_controlfile_block_size 0
_controlfile_enqueue_dump FALSE
_controlfile_enqueue_holding_time 120
_controlfile_enqueue_holding_time_tracking_size 10
_controlfile_enqueue_timeout 900
_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
_create_table_in_any_cluster FALSE
_cursor_bind_capture_area_size 400
_cursor_bind_capture_interval 900
_cursor_cache_time 1800
_cursor_db_buffers_pinned 99
_cursor_features_enabled 2
_cursor_plan_enabled TRUE
_cursor_plan_hash_version 1
_cursor_plan_unparse_enabled TRUE
_cursor_stats_bucket 15
_cursor_stats_heap 4
_cvw_enable_weak_checking TRUE
_datafile_cow FALSE
_datafile_write_errors_crash_instance FALSE
_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 55974
_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
_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 131072
_db_block_hash_latches 4096
_db_block_header_guard_level 0
_db_block_hi_priority_batch_size 0
_db_block_known_clean_pct 2
_db_block_lru_latches 8
_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_crx_check FALSE
_db_cache_miss_check_les 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_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 16
_db_file_format_io_buffers 4
_db_file_noncontig_mblock_read_count 11
_db_file_optimizer_read_count 16
_db_flash_cache_keep_limit 80
_db_handles 2750
_db_handles_cached 5
_db_hot_block_tracking FALSE
_db_index_block_checking TRUE
_db_l2_tracing 0
_db_large_dirty_queue 25
_db_lost_write_checking 0
_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 4190016
_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 33489896
_dbrm_quantum
_dbrm_readylist_chk 1
_dbrm_runchk 0
_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_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_log_boundary_ckpt TRUE
_defer_log_count 2
_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_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_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_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
_disable_12751 FALSE
_disable_active_influx_move FALSE
_disable_adaptive_shrunk_aggregation FALSE
_disable_autotune_gtx FALSE
_disable_cell_optimized_backups FALSE
_disable_cpu_check 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_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_sec_ticks FALSE
_disable_selftune_checkpointing FALSE
_disable_streams_pool_auto_tuning FALSE
_disable_sun_rsm TRUE
_disable_system_state 4294967294
_disable_system_state_wait_samples FALSE
_disable_temp_tablespace_alerts FALSE
_disable_thread_internal_disable FALSE
_disable_txn_alert 0
_disable_undo_tablespace_alerts FALSE
_disable_vktm 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_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
_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
_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
_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_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_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_refresh_schedule TRUE
_enable_reliable_latch_waits TRUE
_enable_rlb TRUE
_enable_row_shipping TRUE
_enable_sb_detection TRUE
_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
_enqueue_hash 1729
_enqueue_hash_chain_latches 1
_enqueue_locks 9990
_enqueue_paranoia_mode_enabled FALSE
_enqueue_resources 3944
_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 1
_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
_fifth_spare_parameter
_file_size_increase_increment 52428800
_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_dynamic_enable TRUE
_flashback_dynamic_enable_failure 0
_flashback_format_chunk_mb 4
_flashback_format_chunk_mb_dwrite 16
_flashback_fuzzy_barrier TRUE
_flashback_generation_buffer_size 4194304
_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
_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_standby_barrier_interval 1
_flashback_verbose_info FALSE
_flashback_write_max_loop_limit 10
_flush_redo_to_standby 0
_flush_undo_after_tx_recovery TRUE
_force_arch_compress 0
_force_datefold_trunc FALSE
_force_hsc_compress FALSE
_force_oltp_compress FALSE
_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
_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_cr_server_read_wait TRUE
_gc_defer_ping_index_only TRUE
_gc_defer_time 3
_gc_delta_push_compression 3072
_gc_delta_push_max_level 100
_gc_delta_push_objects 0
_gc_down_convert_after_keep TRUE
_gc_element_percent 110
_gc_flush_during_affinity TRUE
_gc_fusion_compression 1536
_gc_global_checkpoint_scn TRUE
_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_long_query_threshold 0
_gc_max_downcvt 256
_gc_maximum_bids 0
_gc_policy_minimum 1500
_gc_policy_time 10
_gc_read_mostly_flush_check FALSE
_gc_read_mostly_locking 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
_gcs_disable_remote_handles FALSE
_gcs_fast_reconfig TRUE
_gcs_latches 0
_gcs_pkey_history 4000
_gcs_process_in_recovery TRUE
_gcs_res_per_bucket 16
_gcs_resources
_gcs_shadow_locks
_gcs_testing 0
_generalized_pruning_enabled TRUE
_ges_dd_debug 1
_ges_diagnostics TRUE
_ges_diagnostics_asm_dump_level 11
_ges_health_check 1
_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 30
_hang_ignored_hangs_interval 30
_hang_log_incidents FALSE
_hang_long_wait_time_threshold 0
_hang_lws_file_count 5
_hang_lws_file_time_limit 1800
_hang_msg_checksum_enabled TRUE
_hang_output_suspected_hangs FALSE
_hang_resolution_confidence_promotion FALSE
_hang_resolution_policy HIGH
_hang_resolution_scope OFF
_hang_signature_list_output_frequency 25
_hang_statistics_collection_interval 0
_hang_statistics_collection_react_ma_alpha 30
_hang_statistics_collection_react_ma_sum_delta_cnt 15
_hang_statistics_collection_smooth_ma_alpha 8
_hard_protection FALSE
_hash_join_enabled TRUE
_hash_multiblock_io_count 0
_heur_deadlock_resolution_secs 0
_high_priority_process_num_yields_before_sleep 1000
_high_priority_processes LMS*|VKTM
_high_server_threshold 0
_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
_hm_verification_interval 30
_hwm_sync_threshold 10
_idl_conventional_index_maintenance TRUE
_idle_session_kill_enabled TRUE
_idxrb_rowincr 100000000
_ignore_desc_in_index 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_device_type controlfile
_imr_disk_voting_interval 3
_imr_diskvote_implementation auto
_imr_evicted_member_kill TRUE
_imr_evicted_member_kill_wait 20
_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
_in_memory_undo TRUE
_incremental_recovery_ckpt_min_batch 500
_index_join_enabled TRUE
_index_prefetch_factor 100
_index_scan_check_skip_corrupt FALSE
_init_granule_interval 10
_init_sql_file ?/rdbms/admin/sql.bsq
_inject_startup_fault 0
_inline_sql_in_plsql FALSE
_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
_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_caching_enabled TRUE
_kcfis_cell_passthru_enabled FALSE
_kcfis_control1 0
_kcfis_control2 0
_kcfis_control3 0
_kcfis_control4 0
_kcfis_control5 0
_kcfis_control6 0
_kcfis_fault_control 0
_kcfis_max_cached_sessions 10
_kcfis_metadata_io_write_enabled TRUE
_kcfis_oss_io_size 0
_kcfis_rdbms_blockio_enabled FALSE
_kcfis_read_buffer_limit 0
_kcfis_reuse_any_cached_enabled TRUE
_kcfis_stats_level 0
_kcfis_storageidx_diag_mode FALSE
_kcfis_storageidx_disabled FALSE
_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
_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 TRUE
_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_itree_entries 0
_kdli_memory_protect FALSE
_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_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_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
_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_lobcmpadp FALSE
_kdlxp_lobcmplevel 2
_kdlxp_lobcmprciver 1
_kdlxp_lobcompress FALSE
_kdlxp_lobdeduplicate FALSE
_kdlxp_lobdedupvalidate TRUE
_kdlxp_lobencrypt FALSE
_kdlxp_mincmp 20
_kdlxp_minxfm_size 32768
_kdlxp_spare1 0
_kdlxp_xfmcache TRUE
_kdt_buffering TRUE
_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
_kffmap_hash_size 1024
_kffmop_hash_size 2048
_kfm_disable_set_fence FALSE
_kghdsidx_count 1
_kgl_bucket_count 9
_kgl_debug
_kgl_fixed_extents TRUE
_kgl_hash_collision FALSE
_kgl_heap_size 4096
_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_multi_instance_invalidation TRUE
_kgl_multi_instance_lock TRUE
_kgl_multi_instance_pin TRUE
_kgl_mutex_wait_time 0
_kgl_time_to_wait_for_locks 15
_kglsim_maxmem_percent 5
_kgsb_threshold_size 16777216
_kgx_latches 1024
_kgx_spin_count 255
_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_free_cursor_stat_pct 10
_kokli_cache_size 128
_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
_kse_die_timeout 60000
_kse_pc_table_size 256
_kse_signature_entries 0
_kse_signature_limit 7
_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
_ksmb_debug 0
_ksmd_protect_mode off
_ksmg_granule_locking_status 1
_ksmg_granule_size 4194304
_ksmg_lock_check_interval
_ksmg_lock_reacquire_count 5
_kspol_tac_timeout 5
_ksr_unit_test_processes 0
_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_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_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
_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
_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
_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_pga_lim 0
_left_nested_loops_random TRUE
_lgwr_async_broadcasts 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_ta_sim_err 0
_library_cache_advice TRUE
_lightweight_hdrs TRUE
_like_with_bind_as_equality FALSE
_limit_itls 20
_lm_activate_lms_threshold 100
_lm_asm_enq_hashing TRUE
_lm_batch_compression_threshold 0
_lm_better_ddvictim TRUE
_lm_cache_lvl0_cleanup 0
_lm_cache_res_cleanup 25
_lm_cache_res_type TMHWDI
_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_disable 0
_lm_drm_max_requests 100
_lm_drm_object_scan TRUE
_lm_drm_window 0
_lm_drm_xlatch 0
_lm_dynamic_lms FALSE
_lm_dynamic_load TRUE
_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_file_affinity
_lm_global_posts TRUE
_lm_idle_connection_check TRUE
_lm_idle_connection_check_interval 140
_lm_idle_connection_kill TRUE
_lm_kill_fg_on_timeout TRUE
_lm_lmd_waittime 8
_lm_lmon_nowait_latch TRUE
_lm_lms 0
_lm_lms_waittime 8
_lm_locks 12000
_lm_master_weight 1
_lm_max_lms 0
_lm_msg_batch_size 0
_lm_msg_cleanup_interval 3000
_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_rcfg_timeout 489
_lm_rcvinst TRUE
_lm_rcvr_hang_allow_time 70
_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
_lm_share_lock_opt FALSE
_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_validate_pbatch FALSE
_lm_validate_resource_type FALSE
_lm_xids 352
_lmn_compression TRUE
_load_without_compile none
_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_blocks_during_backup TRUE
_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 1
_log_private_mul 5
_log_private_parallelism_mul 10
_log_read_buffer_size 8
_log_read_buffers 8
_log_simultaneous_copies 2
_log_space_errors TRUE
_log_switch_timeout 0
_logout_storm_rate 0
_logout_storm_retrycnt 600
_logout_storm_timeout 5
_longops_enabled TRUE
_low_server_threshold 0
_ltc_trace 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_cr_rollbacks 0
_max_exponential_sleep 0
_max_io_size 1048576
_max_large_io 0
_max_lns_shutdown_archival_time 30
_max_protocol_support 10000
_max_shrink_obj_stats 0
_max_sleep_holding_latch 4
_max_small_io 0
_max_spacebg_slaves 10
_max_spacebg_tasks 1000
_max_temp_overhead 0
_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 1100
_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
_mpmt_enabled FALSE
_multi_instance_pmr TRUE
_multi_join_key_table_lookup TRUE
_multiple_instance_recovery FALSE
_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_pkfk_data_units_opt auto
_mv_refresh_pkfk_relationship_opt TRUE
_mv_refresh_rebuild_percentage 10
_mv_refresh_selections 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_mav_fast_oncommit_enabled TRUE
_new_initial_join_orders TRUE
_new_sort_cost_estimate TRUE
_newsort_enabled TRUE
_newsort_ordered_pct 63
_newsort_type 0
_nlj_batching_enabled 1
_nlj_batching_misses_enabled 1
_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 1
_numa_trace_level 0
_number_cached_attributes 10
_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_function_merge_threshold 529
_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_store_probability 100
_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_large 50000
_olap_dimension_corehash_pressure 90
_olap_dimension_corehash_size 30
_olap_dimension_corehash_small 1000
_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_small_group 400
_olap_parallel_update_small_threshold 1000
_olap_parallel_update_threshold 1000
_olap_sesscache_enabled TRUE
_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
_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
_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_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 224
_optimizer_fast_access_pred_analysis TRUE
_optimizer_fast_pred_transitivity TRUE
_optimizer_feedback_control
_optimizer_filter_pred_pullup TRUE
_optimizer_fkr_index_cost_bias 10
_optimizer_force_CBQT
_optimizer_free_transformation_heap TRUE
_optimizer_group_by_placement TRUE
_optimizer_ignore_hints FALSE
_optimizer_improve_selectivity TRUE
_optimizer_instance_count 0
_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_to_anti_enabled TRUE
_optimizer_percent_parallel 101
_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
_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.1
_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
_outstanding_broadcast_scn_waits 8
_parallel_adaptive_max_users 2
_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_load_bal_unit 0
_parallel_load_balancing TRUE
_parallel_min_message_pool 1076000
_parallel_optimization_phase_for_local FALSE
_parallel_queuing_max_waitingtime
_parallel_recovery_stopat 32767
_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_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 209715200
_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 10
_pmon_dead_blkrs_max_cleanup_attempts 5
_pmon_dead_blkrs_scan_rate_secs 3
_pmon_enable_dead_blkrs FALSE
_pmon_load_constants 300,192,64,3,10,10,0,0
_pqq_debug_txn_act FALSE
_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
_projection_pushdown_debug 0
_prop_old_enabled FALSE
_protect_frame_heaps FALSE
_push_join_predicate TRUE
_push_join_union_view TRUE
_push_join_union_view2 TRUE
_px_async_getgranule FALSE
_px_bind_peek_sharing TRUE
_px_broadcast_fudge_factor 100
_px_buffer_ttl 30
_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_size 1000000
_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_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_proc_constrain TRUE
_px_pwg_enabled TRUE
_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
_qa_lrg_type 0
_query_cost_rewrite TRUE
_query_execution_cache_max_size 65536
_query_mmvrewrite_maxcmaps 20
_query_mmvrewrite_maxdmaps 10
_query_mmvrewrite_maxinlists 5
_query_mmvrewrite_maxintervals 5
_query_mmvrewrite_maxmergedcmaps 50
_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
_readable_standby_sync_timeout 10
_real_time_apply_sim 0
_realfree_heap_max_size 32768
_realfree_heap_mode 0
_realfree_heap_pagesize_hint 65536
_recoverable_recovery_batch_percent 50
_recovery_asserts FALSE
_recovery_percentage 50
_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_max_stall_time 240
_redo_transport_stream_test TRUE
_redo_transport_stream_writes TRUE
_redo_transport_vio_size_req 4294967294
_reduce_sby_log_scan TRUE
_release_insert_threshold 5
_reliable_block_sends FALSE
_remove_aggr_subquery TRUE
_rep_base_path
_replace_virtual_columns TRUE
_resource_manager_always_off FALSE
_resource_manager_always_on TRUE
_restore_maxopenfiles 8
_restore_spfile
_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_global TRUE
_result_cache_timeout 10
_reuse_index_loop 5
_right_outer_hash_enable TRUE
_rm_cluster_interconnects
_rm_numa_sched_enable TRUE
_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
_scn_wait_interface_max_backoff_time_secs 600
_scn_wait_interface_max_timeout_secs 2147483647
_sdiag_crash NONE
_sec_enable_test_rpcs FALSE
_second_spare_parameter
_securefile_timers FALSE
_securefiles_concurrency_estimate 12
_select_any_dictionary_security_enabled FALSE
_selectivity_for_srf_enabled FALSE
_selfjoin_mv_duplicates TRUE
_selftune_checkpoint_write_pct 3
_selftune_checkpointing_lag 300
_send_ast_to_foreground TRUE
_send_close_with_block TRUE
_send_requests_to_pi TRUE
_serial_direct_read FALSE
_serial_recovery FALSE
_serializable FALSE
_serialize_lgwr_sync_io FALSE
_session_allocation_latches 1
_session_cached_instantiations 60
_session_context_size 10000
_session_idle_bit_latches 0
_session_wait_history 10
_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 1
_shmprotect 0
_short_stack_timeout_ms 30000
_shrunk_aggs_disable_threshold 60
_shrunk_aggs_enabled TRUE
_side_channel_batch_size 200
_side_channel_batch_timeout 6
_side_channel_batch_timeout_ms 500
_simple_view_merging TRUE
_simulate_disk_sectorsize 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
_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
_slave_mapping_enabled TRUE
_slave_mapping_group_size 0
_slave_mapping_skew_ratio 2
_small_table_threshold 1119
_smm_advice_enabled TRUE
_smm_advice_log_size 0
_smm_auto_cost_enabled FALSE
_smm_auto_max_io_size 248
_smm_auto_min_io_size 56
_smm_bound 0
_smm_control 0
_smm_freeable_retain 5120
_smm_isort_cap 102400
_smm_max_size 0
_smm_min_size 128
_smm_px_max_size 0
_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 1
_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 20
_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_switchover_timeout 120
_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
_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
_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
_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
_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
_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
_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 FALSE
_use_best_fit FALSE
_use_column_stats_for_function TRUE
_use_ism TRUE
_use_ism_for_pga TRUE
_use_nosegment_indexes FALSE
_use_platform_compression_lib FALSE
_use_realfree_heap FALSE
_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_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
_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
_wait_tracker_interval_secs 10
_wait_tracker_num_intervals 0
_walk_insert_threshold 0
_watchpoint_on FALSE
_wcr_control 0
_windowfunc_optimization_settings 0
_with_subquery OPTIMIZER
_write_clones 3
_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
_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
active_instance_count
aq_tm_processes 0
archive_lag_target 0
asm_diskgroups
asm_diskstring
asm_power_limit 1
asm_preferred_read_failure_groups
audit_file_dest /home/oracle/zxindbf/admin/zxin/adump
audit_sys_operations FALSE
audit_syslog_level
audit_trail NONE
background_core_dump partial
background_dump_dest /home/oracle/zxindbf/diag/rdbms/zxin/zxin/trace
backup_tape_io_slaves FALSE
bitmap_merge_area_size 1048576
blank_trimming FALSE
buffer_pool_keep
buffer_pool_recycle
cell_offload_compaction ADAPTIVE
cell_offload_decryption TRUE
cell_offload_parameters
cell_offload_plan_display AUTO
cell_offload_processing TRUE
cell_partition_large_extents DEFAULT
circuits
client_result_cache_lag 3000
client_result_cache_size 0
cluster_database FALSE
cluster_database_instances 1
cluster_interconnects
commit_logging
commit_point_strength 1
commit_wait
commit_write
compatible 10.2.0.1.0
control_file_record_keep_time 7
control_files /zxindata/oracle/control/control01.ctl, /zxindata/oracle/control/control02.ctl, /zxindata/oracle/con
trol/control03.ctl
_olap_continuous_trace_file false
_olap_dbgoutfile_echo_to_eventlog FALSE
_olap_dimension_corehash_large 50000
_olap_dimension_corehash_pressure 90
_olap_dimension_corehash_size 30
_olap_dimension_corehash_small 1000
_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_small_group 400
_olap_parallel_update_small_threshold 1000
_olap_parallel_update_threshold 1000
_olap_sesscache_enabled TRUE
_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
_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
_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_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 224
_optimizer_fast_access_pred_analysis TRUE
_optimizer_fast_pred_transitivity TRUE
_optimizer_feedback_control
_optimizer_filter_pred_pullup TRUE
_optimizer_fkr_index_cost_bias 10
_optimizer_force_CBQT
_optimizer_free_transformation_heap TRUE
_optimizer_group_by_placement TRUE
_optimizer_ignore_hints FALSE
_optimizer_improve_selectivity TRUE
_optimizer_instance_count 0
_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_to_anti_enabled TRUE
_optimizer_percent_parallel 101
_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
_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.1
_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
_outstanding_broadcast_scn_waits 8
_parallel_adaptive_max_users 2
_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_load_bal_unit 0
_parallel_load_balancing TRUE
_parallel_min_message_pool 1076000
_parallel_optimization_phase_for_local FALSE
_parallel_queuing_max_waitingtime
_parallel_recovery_stopat 32767
_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_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 209715200
_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 10
_pmon_dead_blkrs_max_cleanup_attempts 5
_pmon_dead_blkrs_scan_rate_secs 3
_pmon_enable_dead_blkrs FALSE
_pmon_load_constants 300,192,64,3,10,10,0,0
_pqq_debug_txn_act FALSE
_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
_projection_pushdown_debug 0
_prop_old_enabled FALSE
_protect_frame_heaps FALSE
_push_join_predicate TRUE
_push_join_union_view TRUE
_push_join_union_view2 TRUE
_px_async_getgranule FALSE
_px_bind_peek_sharing TRUE
_px_broadcast_fudge_factor 100
_px_buffer_ttl 30
_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_size 1000000
_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_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_proc_constrain TRUE
_px_pwg_enabled TRUE
_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
_qa_lrg_type 0
_query_cost_rewrite TRUE
_query_execution_cache_max_size 65536
_query_mmvrewrite_maxcmaps 20
_query_mmvrewrite_maxdmaps 10
_query_mmvrewrite_maxinlists 5
_query_mmvrewrite_maxintervals 5
_query_mmvrewrite_maxmergedcmaps 50
_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
_readable_standby_sync_timeout 10
_real_time_apply_sim 0
_realfree_heap_max_size 32768
_realfree_heap_mode 0
_realfree_heap_pagesize_hint 65536
_recoverable_recovery_batch_percent 50
_recovery_asserts FALSE
_recovery_percentage 50
_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_max_stall_time 240
_redo_transport_stream_test TRUE
_redo_transport_stream_writes TRUE
_redo_transport_vio_size_req 4294967294
_reduce_sby_log_scan TRUE
_release_insert_threshold 5
_reliable_block_sends FALSE
_remove_aggr_subquery TRUE
_rep_base_path
_replace_virtual_columns TRUE
_resource_manager_always_off FALSE
_resource_manager_always_on TRUE
_restore_maxopenfiles 8
_restore_spfile
_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_global TRUE
_result_cache_timeout 10
_reuse_index_loop 5
_right_outer_hash_enable TRUE
_rm_cluster_interconnects
_rm_numa_sched_enable TRUE
_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
_scn_wait_interface_max_backoff_time_secs 600
_scn_wait_interface_max_timeout_secs 2147483647
_sdiag_crash NONE
_sec_enable_test_rpcs FALSE
_second_spare_parameter
_securefile_timers FALSE
_securefiles_concurrency_estimate 12
_select_any_dictionary_security_enabled FALSE
_selectivity_for_srf_enabled FALSE
_selfjoin_mv_duplicates TRUE
_selftune_checkpoint_write_pct 3
_selftune_checkpointing_lag 300
_send_ast_to_foreground TRUE
_send_close_with_block TRUE
_send_requests_to_pi TRUE
_serial_direct_read FALSE
_serial_recovery FALSE
_serializable FALSE
_serialize_lgwr_sync_io FALSE
_session_allocation_latches 1
_session_cached_instantiations 60
_session_context_size 10000
_session_idle_bit_latches 0
_session_wait_history 10
_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 1
_shmprotect 0
_short_stack_timeout_ms 30000
_shrunk_aggs_disable_threshold 60
_shrunk_aggs_enabled TRUE
_side_channel_batch_size 200
_side_channel_batch_timeout 6
_side_channel_batch_timeout_ms 500
_simple_view_merging TRUE
_simulate_disk_sectorsize 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
_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
_slave_mapping_enabled TRUE
_slave_mapping_group_size 0
_slave_mapping_skew_ratio 2
_small_table_threshold 1119
_smm_advice_enabled TRUE
_smm_advice_log_size 0
_smm_auto_cost_enabled FALSE
_smm_auto_max_io_size 248
_smm_auto_min_io_size 56
_smm_bound 0
_smm_control 0
_smm_freeable_retain 5120
_smm_isort_cap 102400
_smm_max_size 0
_smm_min_size 128
_smm_px_max_size 0
_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 1
_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 20
_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_switchover_timeout 120
_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
_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
_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
_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
_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
_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
_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 FALSE
_use_best_fit FALSE
_use_column_stats_for_function TRUE
_use_ism TRUE
_use_ism_for_pga TRUE
_use_nosegment_indexes FALSE
_use_platform_compression_lib FALSE
_use_realfree_heap FALSE
_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_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
_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
_wait_tracker_interval_secs 10
_wait_tracker_num_intervals 0
_walk_insert_threshold 0
_watchpoint_on FALSE
_wcr_control 0
_windowfunc_optimization_settings 0
_with_subquery OPTIMIZER
_write_clones 3
_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
_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
active_instance_count
aq_tm_processes 0
archive_lag_target 0
asm_diskgroups
asm_diskstring
asm_power_limit 1
asm_preferred_read_failure_groups
audit_file_dest /home/oracle/zxindbf/admin/zxin/adump
audit_sys_operations FALSE
audit_syslog_level
audit_trail NONE
background_core_dump partial
background_dump_dest /home/oracle/zxindbf/diag/rdbms/zxin/zxin/trace
backup_tape_io_slaves FALSE
bitmap_merge_area_size 1048576
blank_trimming FALSE
buffer_pool_keep
buffer_pool_recycle
cell_offload_compaction ADAPTIVE
cell_offload_decryption TRUE
cell_offload_parameters
cell_offload_plan_display AUTO
cell_offload_processing TRUE
cell_partition_large_extents DEFAULT
circuits
client_result_cache_lag 3000
client_result_cache_size 0
cluster_database FALSE
cluster_database_instances 1
cluster_interconnects
commit_logging
commit_point_strength 1
commit_wait
commit_write
compatible 10.2.0.1.0
control_file_record_keep_time 7
control_files /zxindata/oracle/control/control01.ctl, /zxindata/oracle/control/control02.ctl, /zxindata/oracle/con
trol/control03.ctl
control_management_pack_access DIAGNOSTIC+TUNING
core_dump_dest /home/oracle/zxindbf/admin/zxin/cdump
cpu_count 1
create_bitmap_area_size 8388608
create_stored_outlines
cursor_sharing EXACT
cursor_space_for_time FALSE
db_16k_cache_size 0
db_2k_cache_size 0
db_32k_cache_size 0
db_4k_cache_size 0
db_8k_cache_size 0
db_block_buffers 0
db_block_checking FALSE
db_block_checksum TYPICAL
db_block_size 8192
db_cache_advice ON
db_cache_size 209715200
db_create_file_dest
db_create_online_log_dest_1
db_create_online_log_dest_2
db_create_online_log_dest_3
db_create_online_log_dest_4
db_create_online_log_dest_5
db_domain
db_file_multiblock_read_count 16
db_file_name_convert
db_files 200
db_flash_cache_file
db_flash_cache_size 0
db_flashback_retention_target 1440
db_keep_cache_size 0
db_lost_write_protect NONE
db_name zxin
db_recovery_file_dest
db_recovery_file_dest_size 0
db_recycle_cache_size 0
db_securefile PERMITTED
db_ultra_safe OFF
db_unique_name zxin
db_writer_processes 1
dbwr_io_slaves 0
ddl_lock_timeout 0
deferred_segment_creation TRUE
dg_broker_config_file1 /home/oracle/oracle11g/dbs/dr1zxin.dat
dg_broker_config_file2 /home/oracle/oracle11g/dbs/dr2zxin.dat
dg_broker_start FALSE
diagnostic_dest /home/oracle/zxindbf
disk_asynch_io TRUE
dispatchers
distributed_lock_timeout 60
dml_locks 3724
dst_upgrade_insert_conv TRUE
enable_ddl_logging FALSE
event
fal_client
fal_server
fast_start_io_target 0
fast_start_mttr_target 0
fast_start_parallel_rollback LOW
file_mapping FALSE
fileio_network_adapters
filesystemio_options none
fixed_date
gcs_server_processes 0
global_context_pool_size
global_names FALSE
global_txn_processes 1
hash_area_size 131072
hi_shared_memory_address 0
hs_autoregister TRUE
ifile
instance_groups
instance_name zxin
instance_number 0
instance_type RDBMS
java_jit_enabled TRUE
java_max_sessionspace_size 0
java_pool_size 0
java_soft_sessionspace_limit 0
job_queue_processes 10
large_pool_size 0
ldap_directory_access NONE
ldap_directory_sysauth no
license_max_sessions 0
license_max_users 0
license_sessions_warning 0
listener_networks
local_listener
lock_name_space
lock_sga FALSE
log_archive_config
log_archive_dest
log_archive_dest_1 location=/zxinbak/arch reopen=30
log_archive_dest_10
log_archive_dest_11
log_archive_dest_12
log_archive_dest_13
log_archive_dest_14
log_archive_dest_15
log_archive_dest_16
log_archive_dest_17
log_archive_dest_18
log_archive_dest_19
log_archive_dest_2
log_archive_dest_20
log_archive_dest_21
log_archive_dest_22
log_archive_dest_23
log_archive_dest_24
log_archive_dest_25
log_archive_dest_26
log_archive_dest_27
log_archive_dest_28
log_archive_dest_29
log_archive_dest_3
log_archive_dest_30
log_archive_dest_31
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_state_1 enable
log_archive_dest_state_10 enable
log_archive_dest_state_11 enable
log_archive_dest_state_12 enable
log_archive_dest_state_13 enable
log_archive_dest_state_14 enable
log_archive_dest_state_15 enable
log_archive_dest_state_16 enable
log_archive_dest_state_17 enable
log_archive_dest_state_18 enable
log_archive_dest_state_19 enable
log_archive_dest_state_2 enable
log_archive_dest_state_20 enable
log_archive_dest_state_21 enable
log_archive_dest_state_22 enable
log_archive_dest_state_23 enable
log_archive_dest_state_24 enable
log_archive_dest_state_25 enable
log_archive_dest_state_26 enable
log_archive_dest_state_27 enable
log_archive_dest_state_28 enable
log_archive_dest_state_29 enable
log_archive_dest_state_3 enable
log_archive_dest_state_30 enable
log_archive_dest_state_31 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_dest_state_6 enable
log_archive_dest_state_7 enable
log_archive_dest_state_8 enable
log_archive_dest_state_9 enable
log_archive_duplex_dest
log_archive_format %t_%s_%r.dbf
log_archive_local_first TRUE
log_archive_max_processes 4
log_archive_min_succeed_dest 1
log_archive_start FALSE
log_archive_trace 0
log_buffer 3293184
log_checkpoint_interval 0
log_checkpoint_timeout 1800
log_checkpoints_to_alert FALSE
log_file_name_convert
max_dispatchers
max_dump_file_size 512M
max_enabled_roles 150
max_shared_servers
memory_max_target 0
memory_target 0
nls_calendar
nls_comp BINARY
nls_currency
nls_date_format
nls_date_language
nls_dual_currency
nls_iso_currency
nls_language AMERICAN
nls_length_semantics BYTE
nls_nchar_conv_excp FALSE
nls_numeric_characters
nls_sort
nls_territory AMERICA
nls_time_format
nls_time_tz_format
nls_timestamp_format
nls_timestamp_tz_format
object_cache_max_size_percent 10
object_cache_optimal_size 102400
olap_page_pool_size 0
open_cursors 500
open_links 4
open_links_per_instance 4
optimizer_capture_sql_plan_baselines FALSE
optimizer_dynamic_sampling 2
optimizer_features_enable 11.2.0.1
optimizer_index_caching 0
optimizer_index_cost_adj 100
optimizer_mode ALL_ROWS
optimizer_secure_view_merging TRUE
optimizer_use_invisible_indexes FALSE
optimizer_use_pending_statistics FALSE
optimizer_use_sql_plan_baselines TRUE
os_authent_prefix ops$
os_roles FALSE
parallel_adaptive_multi_user TRUE
parallel_automatic_tuning FALSE
parallel_degree_limit CPU
parallel_degree_policy MANUAL
parallel_execution_message_size 2152
parallel_force_local FALSE
parallel_instance_group
parallel_io_cap_enabled FALSE
parallel_max_servers 100
parallel_min_percent 0
parallel_min_servers 0
parallel_min_time_threshold AUTO
parallel_server FALSE
parallel_server_instances 1
parallel_servers_target 8
parallel_threads_per_cpu 2
permit_92_wrap_format TRUE
pga_aggregate_target 0
plscope_settings IDENTIFIERS:NONE
plsql_ccflags
plsql_code_type INTERPRETED
plsql_debug FALSE
plsql_optimize_level 2
plsql_v2_compatibility FALSE
plsql_warnings DISABLE:ALL
pre_page_sga FALSE
processes 550
query_rewrite_enabled TRUE
query_rewrite_integrity enforced
rdbms_server_dn
read_only_open_delayed FALSE
recovery_parallelism 0
recyclebin on
redo_transport_user
remote_dependencies_mode TIMESTAMP
remote_listener
remote_login_passwordfile NONE
remote_os_authent FALSE
remote_os_roles FALSE
replication_dependency_tracking TRUE
resource_limit FALSE
resource_manager_cpu_allocation 1
resource_manager_plan
result_cache_max_result 5
result_cache_max_size 1048576
result_cache_mode MANUAL
result_cache_remote_expiration 0
resumable_timeout 0
rollback_segments
sec_case_sensitive_logon TRUE
sec_max_failed_login_attempts 10
sec_protocol_error_further_action CONTINUE
sec_protocol_error_trace_action TRACE
sec_return_server_release_banner FALSE
serial_reuse disable
service_names zxin
session_cached_cursors 50
session_max_open_files 10
sessions 847
sga_max_size 595591168
sga_target 595591168
shadow_core_dump partial
shared_memory_address 0
shared_pool_reserved_size 5242880
shared_pool_size 104857600
shared_server_sessions
shared_servers 0
skip_unusable_indexes TRUE
smtp_out_server
sort_area_retained_size 0
sort_area_size 65536
spfile
sql92_security FALSE
sql_trace FALSE
sqltune_category DEFAULT
standby_archive_dest ?/dbs/arch
standby_file_management MANUAL
star_transformation_enabled FALSE
statistics_level TYPICAL
streams_pool_size 0
tape_asynch_io TRUE
thread 0
timed_os_statistics 0
timed_statistics TRUE
trace_enabled TRUE
tracefile_identifier
transactions 931
transactions_per_rollback_segment 5
undo_management AUTO
undo_retention 900
undo_tablespace UNDOTBS1
use_indirect_data_buffers FALSE
user_dump_dest /home/oracle/zxindbf/diag/rdbms/zxin/zxin/trace
utl_file_dir /home/oracle
workarea_size_policy MANUAL
xml_db_events enable
core_dump_dest /home/oracle/zxindbf/admin/zxin/cdump
cpu_count 1
create_bitmap_area_size 8388608
create_stored_outlines
cursor_sharing EXACT
cursor_space_for_time FALSE
db_16k_cache_size 0
db_2k_cache_size 0
db_32k_cache_size 0
db_4k_cache_size 0
db_8k_cache_size 0
db_block_buffers 0
db_block_checking FALSE
db_block_checksum TYPICAL
db_block_size 8192
db_cache_advice ON
db_cache_size 209715200
db_create_file_dest
db_create_online_log_dest_1
db_create_online_log_dest_2
db_create_online_log_dest_3
db_create_online_log_dest_4
db_create_online_log_dest_5
db_domain
db_file_multiblock_read_count 16
db_file_name_convert
db_files 200
db_flash_cache_file
db_flash_cache_size 0
db_flashback_retention_target 1440
db_keep_cache_size 0
db_lost_write_protect NONE
db_name zxin
db_recovery_file_dest
db_recovery_file_dest_size 0
db_recycle_cache_size 0
db_securefile PERMITTED
db_ultra_safe OFF
db_unique_name zxin
db_writer_processes 1
dbwr_io_slaves 0
ddl_lock_timeout 0
deferred_segment_creation TRUE
dg_broker_config_file1 /home/oracle/oracle11g/dbs/dr1zxin.dat
dg_broker_config_file2 /home/oracle/oracle11g/dbs/dr2zxin.dat
dg_broker_start FALSE
diagnostic_dest /home/oracle/zxindbf
disk_asynch_io TRUE
dispatchers
distributed_lock_timeout 60
dml_locks 3724
dst_upgrade_insert_conv TRUE
enable_ddl_logging FALSE
event
fal_client
fal_server
fast_start_io_target 0
fast_start_mttr_target 0
fast_start_parallel_rollback LOW
file_mapping FALSE
fileio_network_adapters
filesystemio_options none
fixed_date
gcs_server_processes 0
global_context_pool_size
global_names FALSE
global_txn_processes 1
hash_area_size 131072
hi_shared_memory_address 0
hs_autoregister TRUE
ifile
instance_groups
instance_name zxin
instance_number 0
instance_type RDBMS
java_jit_enabled TRUE
java_max_sessionspace_size 0
java_pool_size 0
java_soft_sessionspace_limit 0
job_queue_processes 10
large_pool_size 0
ldap_directory_access NONE
ldap_directory_sysauth no
license_max_sessions 0
license_max_users 0
license_sessions_warning 0
listener_networks
local_listener
lock_name_space
lock_sga FALSE
log_archive_config
log_archive_dest
log_archive_dest_1 location=/zxinbak/arch reopen=30
log_archive_dest_10
log_archive_dest_11
log_archive_dest_12
log_archive_dest_13
log_archive_dest_14
log_archive_dest_15
log_archive_dest_16
log_archive_dest_17
log_archive_dest_18
log_archive_dest_19
log_archive_dest_2
log_archive_dest_20
log_archive_dest_21
log_archive_dest_22
log_archive_dest_23
log_archive_dest_24
log_archive_dest_25
log_archive_dest_26
log_archive_dest_27
log_archive_dest_28
log_archive_dest_29
log_archive_dest_3
log_archive_dest_30
log_archive_dest_31
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_state_1 enable
log_archive_dest_state_10 enable
log_archive_dest_state_11 enable
log_archive_dest_state_12 enable
log_archive_dest_state_13 enable
log_archive_dest_state_14 enable
log_archive_dest_state_15 enable
log_archive_dest_state_16 enable
log_archive_dest_state_17 enable
log_archive_dest_state_18 enable
log_archive_dest_state_19 enable
log_archive_dest_state_2 enable
log_archive_dest_state_20 enable
log_archive_dest_state_21 enable
log_archive_dest_state_22 enable
log_archive_dest_state_23 enable
log_archive_dest_state_24 enable
log_archive_dest_state_25 enable
log_archive_dest_state_26 enable
log_archive_dest_state_27 enable
log_archive_dest_state_28 enable
log_archive_dest_state_29 enable
log_archive_dest_state_3 enable
log_archive_dest_state_30 enable
log_archive_dest_state_31 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_dest_state_6 enable
log_archive_dest_state_7 enable
log_archive_dest_state_8 enable
log_archive_dest_state_9 enable
log_archive_duplex_dest
log_archive_format %t_%s_%r.dbf
log_archive_local_first TRUE
log_archive_max_processes 4
log_archive_min_succeed_dest 1
log_archive_start FALSE
log_archive_trace 0
log_buffer 3293184
log_checkpoint_interval 0
log_checkpoint_timeout 1800
log_checkpoints_to_alert FALSE
log_file_name_convert
max_dispatchers
max_dump_file_size 512M
max_enabled_roles 150
max_shared_servers
memory_max_target 0
memory_target 0
nls_calendar
nls_comp BINARY
nls_currency
nls_date_format
nls_date_language
nls_dual_currency
nls_iso_currency
nls_language AMERICAN
nls_length_semantics BYTE
nls_nchar_conv_excp FALSE
nls_numeric_characters
nls_sort
nls_territory AMERICA
nls_time_format
nls_time_tz_format
nls_timestamp_format
nls_timestamp_tz_format
object_cache_max_size_percent 10
object_cache_optimal_size 102400
olap_page_pool_size 0
open_cursors 500
open_links 4
open_links_per_instance 4
optimizer_capture_sql_plan_baselines FALSE
optimizer_dynamic_sampling 2
optimizer_features_enable 11.2.0.1
optimizer_index_caching 0
optimizer_index_cost_adj 100
optimizer_mode ALL_ROWS
optimizer_secure_view_merging TRUE
optimizer_use_invisible_indexes FALSE
optimizer_use_pending_statistics FALSE
optimizer_use_sql_plan_baselines TRUE
os_authent_prefix ops$
os_roles FALSE
parallel_adaptive_multi_user TRUE
parallel_automatic_tuning FALSE
parallel_degree_limit CPU
parallel_degree_policy MANUAL
parallel_execution_message_size 2152
parallel_force_local FALSE
parallel_instance_group
parallel_io_cap_enabled FALSE
parallel_max_servers 100
parallel_min_percent 0
parallel_min_servers 0
parallel_min_time_threshold AUTO
parallel_server FALSE
parallel_server_instances 1
parallel_servers_target 8
parallel_threads_per_cpu 2
permit_92_wrap_format TRUE
pga_aggregate_target 0
plscope_settings IDENTIFIERS:NONE
plsql_ccflags
plsql_code_type INTERPRETED
plsql_debug FALSE
plsql_optimize_level 2
plsql_v2_compatibility FALSE
plsql_warnings DISABLE:ALL
pre_page_sga FALSE
processes 550
query_rewrite_enabled TRUE
query_rewrite_integrity enforced
rdbms_server_dn
read_only_open_delayed FALSE
recovery_parallelism 0
recyclebin on
redo_transport_user
remote_dependencies_mode TIMESTAMP
remote_listener
remote_login_passwordfile NONE
remote_os_authent FALSE
remote_os_roles FALSE
replication_dependency_tracking TRUE
resource_limit FALSE
resource_manager_cpu_allocation 1
resource_manager_plan
result_cache_max_result 5
result_cache_max_size 1048576
result_cache_mode MANUAL
result_cache_remote_expiration 0
resumable_timeout 0
rollback_segments
sec_case_sensitive_logon TRUE
sec_max_failed_login_attempts 10
sec_protocol_error_further_action CONTINUE
sec_protocol_error_trace_action TRACE
sec_return_server_release_banner FALSE
serial_reuse disable
service_names zxin
session_cached_cursors 50
session_max_open_files 10
sessions 847
sga_max_size 595591168
sga_target 595591168
shadow_core_dump partial
shared_memory_address 0
shared_pool_reserved_size 5242880
shared_pool_size 104857600
shared_server_sessions
shared_servers 0
skip_unusable_indexes TRUE
smtp_out_server
sort_area_retained_size 0
sort_area_size 65536
spfile
sql92_security FALSE
sql_trace FALSE
sqltune_category DEFAULT
standby_archive_dest ?/dbs/arch
standby_file_management MANUAL
star_transformation_enabled FALSE
statistics_level TYPICAL
streams_pool_size 0
tape_asynch_io TRUE
thread 0
timed_os_statistics 0
timed_statistics TRUE
trace_enabled TRUE
tracefile_identifier
transactions 931
transactions_per_rollback_segment 5
undo_management AUTO
undo_retention 900
undo_tablespace UNDOTBS1
use_indirect_data_buffers FALSE
user_dump_dest /home/oracle/zxindbf/diag/rdbms/zxin/zxin/trace
utl_file_dir /home/oracle
workarea_size_policy MANUAL
xml_db_events enable
2399 rows selected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27573546/viewspace-761752/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27573546/viewspace-761752/