Parameter Name Parameter Value
_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
_UTL_FILE_FOLLOW_SYMLINKS FALSE
__db_cache_size 314572800
__dg_broker_service_names pdb11_XPT
__java_pool_size 20971520
__large_pool_size 4194304
__oracle_base /u01/app/oracle
__pga_aggregate_target 209715200
__sga_target 629145600
__shared_io_pool_size 0
__shared_pool_size 281018368
__streams_pool_size 0
_abort_recovery_on_join FALSE
_accept_versions
_active_standby_fast_reconfiguration TRUE
_adaptive_direct_read TRUE
_adaptive_fetch_enabled TRUE
_add_col_optim_enabled TRUE
_add_stale_mv_to_dependency_list TRUE
_addm_auto_enable TRUE
_addm_skiprules
_addm_version_check TRUE
_adjust_literal_replacement FALSE
_affinity_on TRUE
_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_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_sage_attr TRUE
_allow_terminal_recovery_corruption FALSE
_alternate_iot_leaf_block_split_points TRUE
_always_anti_join CHOOSE
_always_semi_join CHOOSE
_always_star_transformation FALSE
_app_ctx_vers FALSE
_aq_tm_scanlimit 0
_arch_corrupted_redo_log 0
_arch_io_slaves 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_allow_only_raw_disks TRUE
_asm_allow_resilver_corruption FALSE
_asm_ausize 1048576
_asm_blksize 4096
_asm_compatibility 10.1
_asm_dbmsdg_nohdrchk FALSE
_asm_disk_repair_time 14400
_asm_emulmax 10000
_asm_emultimeout 0
_asm_kfdpevent 0
_asm_kfioevent 0
_asm_libraries ufs
_asm_maxio 1048576
_asm_repairquantum 60
_asm_runtime_capability_volume_support FALSE
_asm_skip_resize_check FALSE
_asm_stripesize 131072
_asm_stripewidth 8
_asm_wait_time 18
_asmlib_test 0
_asmsid asm
_assm_default TRUE
_async_recovery_claims TRUE
_async_recovery_reads TRUE
_async_ts_threshold 1
_auto_assign_cg_for_sessions FALSE
_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
_aw_row_source_enabled TRUE
_awr_corrupt_mode FALSE
_awr_disabled_flush_tables
_awr_flush_threshold_metrics TRUE
_awr_flush_workload_metrics FALSE
_awr_mmon_cpuusage TRUE
_awr_restrict_mode FALSE
_awr_sql_child_limit 200
_b_tree_bitmap_plans TRUE
_backup_disk_io_slaves 0
_backup_encrypt_opt_mode 4294967294
_backup_io_pool_size 1048576
_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 0
_backup_ksfq_bufsz 0
_backup_max_gap_size 4294967294
_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_change_tracking TRUE
_blocking_sess_graph_cache_size
_blocks_per_cache_server 64
_bloom_filter_debug 0
_bloom_filter_enabled TRUE
_bloom_predicate_enabled FALSE
_bloom_pruning_enabled TRUE
_bloom_vector_elements 0
_bsln_adaptive_thresholds_enabled TRUE
_bt_mmv_query_rewrite_enabled TRUE
_buffer_busy_wait_timeout 100
_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
_cgs_reconfig_timeout 1000
_cgs_send_timeout 300
_cgs_tickets 1000
_check_block_after_checksum TRUE
_check_block_new_invariant_for_flashback FALSE
_check_ts_threshold 0
_cleanup_rollback_entries 100
_client_result_cache_bypass FALSE
_close_cached_open_cursors 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 50
_controlfile_block_size 0
_controlfile_enqueue_dump FALSE
_controlfile_enqueue_holding_time 780
_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_server_log_flush TRUE
_cursor_bind_capture_area_size 400
_cursor_bind_capture_interval 900
_cursor_db_buffers_pinned 178
_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
_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 27060
_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_corruption_recovery_threshold 5
_db_block_do_full_mbreads FALSE
_db_block_hash_buckets 65536
_db_block_hash_latches 2048
_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_batch_size 128
_db_cache_advice_sample_factor 4
_db_cache_crx_check FALSE
_db_cache_pre_warm TRUE
_db_cache_process_cr_pin_max
_db_change_notification_enable TRUE
_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 128
_db_file_format_io_buffers 4
_db_file_noncontig_mblock_read_count 11
_db_file_optimizer_read_count 8
_db_handles 750
_db_handles_cached 5
_db_hot_block_tracking FALSE
_db_index_block_checking TRUE
_db_large_dirty_queue 25
_db_lost_write_checking 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_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 2293760
_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
_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
_delay_index_maintain TRUE
_desired_readmem_rate 70
_diag_adr_auto_purge TRUE
_diag_adr_enabled TRUE
_diag_adr_test_param 0
_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_hm_rc_enabled TRUE
_diag_hm_tc_enabled FALSE
_diag_uts_control 0
_dimension_skip_null TRUE
_direct_path_insert_features 0
_disable_12751 FALSE
_disable_adaptive_shrunk_aggregation FALSE
_disable_autotune_gtx 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_health_check FALSE
_disable_highres_ticks FALSE
_disable_image_check FALSE
_disable_incremental_checkpoints FALSE
_disable_incremental_recovery_ckpt FALSE
_disable_index_block_prefetching 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_read_only_open_dict_check FALSE
_disable_rebalance_space_check FALSE
_disable_recoverable_recovery 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_thread_internal_disable FALSE
_disable_txn_alert 0
_disable_vktm FALSE
_disable_wait_stack FALSE
_discrete_transactions_enabled 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_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 TRUE
_drop_table_granule 256
_drop_table_optimization_enabled TRUE
_ds_iocount_iosize 6553664
_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
_edition_based_redefinition FALSE
_eliminate_common_subexpr TRUE
_emon_regular_ntfn_slaves 4
_enable_NUMA_optimization TRUE
_enable_automatic_maintenance 1
_enable_automatic_sqltune TRUE
_enable_block_level_transaction_recovery TRUE
_enable_cscn_caching FALSE
_enable_ddl_wait_lock TRUE
_enable_default_affinity 0
_enable_dml_lock_escalation TRUE
_enable_exchange_validation_using_check TRUE
_enable_fast_ref_after_mv_tbs FALSE
_enable_hash_overflow FALSE
_enable_hwm_sync TRUE
_enable_list_io FALSE
_enable_midtier_affinity 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_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_time_sec 5
_enqueue_debug_multi_instance FALSE
_enqueue_hash 375
_enqueue_hash_chain_latches 1
_enqueue_locks 2260
_enqueue_resources 968
_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 4
_fast_dual_enabled TRUE
_fast_full_scan_enabled TRUE
_fastpin_enable 1
_fbda_busy_percentage 0
_fbda_inline2_percentage 0
_fbda_inline_percentage 0
_fg_iorm_slaves 1
_fg_log_checksum TRUE
_fic_algorithm_set automatic
_fic_area_size 131072
_fic_max_length 20
_fic_min_bmsize 1024
_fic_outofmem_candidates FALSE
_fifth_spare_parameter
_filemap_dir
_first_k_rows_dynamic_proration TRUE
_first_spare_parameter
_fix_control
_flashback_allow_noarchivelog FALSE
_flashback_archiver_partition_size 0
_flashback_barrier_interval 1800
_flashback_copy_latches 10
_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_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 900
_flashback_n_log_per_thread 128
_flashback_standby_barrier_interval 1800
_flashback_verbose_info FALSE
_flashback_write_max_loop_limit 10
_force_datefold_trunc FALSE
_force_hsc_compress FALSE
_force_oltp_compress FALSE
_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
_full_pwise_join_enabled TRUE
_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_defer_time 3
_gc_dissolve_undo_affinity FALSE
_gc_element_percent 110
_gc_global_checkpoint_scn TRUE
_gc_global_lru AUTO
_gc_initiate_undo_affinity TRUE
_gc_integrity_checks 1
_gc_keep_recovery_buffers TRUE
_gc_latches 8
_gc_long_query_threshold 0
_gc_maximum_bids 0
_gc_policy_minimum 1500
_gc_policy_time 10
_gc_read_mostly_locking TRUE
_gc_statistics TRUE
_gc_transfer_ratio 2
_gc_undo_affinity TRUE
_gc_undo_block_disk_reads TRUE
_gc_use_cr TRUE
_gc_vector_read TRUE
_gc_voluntary_down_convert_obj 0
_gcs_fast_reconfig TRUE
_gcs_latches 0
_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_health_check 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 60
_hang_resolution FALSE
_hard_protection FALSE
_hash_join_enabled TRUE
_hash_multiblock_io_count 0
_heur_deadlock_resolution_secs 0
_high_priority_processes LMS*|VKTM
_high_server_threshold 0
_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_log_incidents FALSE
_hm_verification_interval 60
_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_evicted_member_kill TRUE
_imr_evicted_member_kill_wait 20
_imr_highload_threshold
_imr_max_reconfig_delay 300
_imr_splitbrain_res_wait 600
_imr_systemload_check TRUE
_imu_pools 3
_in_memory_undo TRUE
_incremental_recovery_ckpt_min_batch 30
_index_join_enabled TRUE
_index_prefetch_factor 100
_init_granule_interval 10
_init_sql_file ?/rdbms/admin/sql.bsq
_inject_startup_fault 0
_inline_sql_in_plsql FALSE
_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
_job_queue_interval 5
_k2q_latches 0
_kcfis_fault_control 0
_kcfis_max_appliances 40
_kcfis_oss_io_size 0
_kcfis_read_buffer_limit 0
_kcfis_trace_level 0
_kcfis_work_set_appliances 6
_kcl_commit TRUE
_kcl_conservative_log_flush FALSE
_kcl_debug TRUE
_kcl_index_split TRUE
_kdbl_enable_post_allocation FALSE
_kdi_avoid_block_checking 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_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_force_cr TRUE
_kdli_force_cr_meta TRUE
_kdli_force_storage none
_kdli_full_readahead_threshold 0
_kdli_inject_assert 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 nodsync
_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 auto
_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_prefix_threshold 1048576
_kdlxp_lobcompress FALSE
_kdlxp_lobdeduplicate FALSE
_kdlxp_lobdedupvalidate TRUE
_kdlxp_lobencrypt FALSE
_kdlxp_min_xfm_size 32768
_kdlxp_mincmp 20
_kdlxp_spare1 0
_kdlxp_xfmcache TRUE
_kdt_buffering 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_features_enabled 2
_kgl_fixed_extents TRUE
_kgl_hash_collision FALSE
_kgl_heap_size 1024
_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_so_stack_depth 16
_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
_kkdlgon_max_iter 20000
_kkfi_trace FALSE
_kks_free_cursor_stat_pct 10
_kks_use_mutex_pin TRUE
_kokli_cache_size 32
_kolfuseslf FALSE
_kql_subheap_trace 0
_ksb_disable_diagpid FALSE
_ksb_restart_clean_time 30000
_ksb_restart_policy_times 0, 60, 120, 240
_ksd_test_param 999
_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
_ksfd_verify_write FALSE
_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_max_spawn_fail_limit 5
_ksv_pool_hang_kill_to 0
_ksv_pool_wait_timeout 600
_ksv_spawn_control_all FALSE
_ksvppktmode 0
_ksxp_diagmode OFF
_ksxp_disable_dynamic_loading FALSE
_ksxp_disable_ipc_stats FALSE
_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_library_path
_ksxp_stats_mem_lmt 0
_ksxp_testing 0
_ksxp_unit_test_byte_transformation FALSE
_ktc_debug 0
_ktc_latches 0
_ktslj_segext_warning 10
_ktspsrch_maxsc 32
_kttext_warning 5
_ktu_latches 0
_ku_trace none
_large_pool_min_alloc 16000
_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
_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
_lm_activate_lms_threshold 100
_lm_asm_enq_hashing TRUE
_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_contiguous_res_count 128
_lm_dd_interval 10
_lm_dd_max_search_time 180
_lm_dd_scan_interval 5
_lm_dd_search_cnt 3
_lm_drm_max_requests 100
_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_freelist 3
_lm_file_affinity
_lm_global_posts TRUE
_lm_idle_connection_check TRUE
_lm_idle_connection_check_interval 10
_lm_idle_connection_kill FALSE
_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_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_proc_freeze_timeout 300
_lm_process_batching TRUE
_lm_procs 320
_lm_psrcfg FALSE
_lm_rcfg_timeout 1260
_lm_rcvr_hang_allow_time 200
_lm_rcvr_hang_check_frequency 60
_lm_rcvr_hang_kill FALSE
_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_sq_batch_factor 2
_lm_sq_batch_type auto
_lm_sq_batch_waittick 3
_lm_sync_timeout 420
_lm_ticket_active_sendback
_lm_tickets 1000
_lm_tx_delta 16
_lm_validate_resource_type FALSE
_lm_xids 352
_lmn_compression FALSE
_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_compress_enable FALSE
_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_io_size 0
_log_parallelism_dynamic TRUE
_log_parallelism_max 1
_log_private_mul 5
_log_private_parallelism FALSE
_log_private_parallelism_mul 10
_log_read_buffers 4
_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_arch_lns_wait 120
_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 128
_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_management_tracing 0
_memory_nocancel_defsgareq FALSE
_memory_sanity_check 0
_messages 300
_midtier_affinity_clusterwait_threshold 100
_midtier_affinity_goodness_threshold 2000
_midtier_affinity_timeout 30000
_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
_multi_instance_pmr TRUE
_multi_join_key_table_lookup TRUE
_multiple_instance_recovery FALSE
_mv_refresh_ana 0
_mv_refresh_costing rule
_mv_refresh_delta_fraction 10
_mv_refresh_eut TRUE
_mv_refresh_force_parallel_query 0
_mv_refresh_new_setup_disabled FALSE
_mv_refresh_rebuild_percentage 10
_mv_refresh_selections 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
_notify_crs FALSE
_ns_max_flush_wt 1
_ns_max_send_delay 15
_num_longop_child_latches 1
_number_cached_attributes 10
_object_reuse_bast 2
_object_statistics TRUE
_object_stats_max_entries 3072
_offline_rollback_segments
_ogms_home
_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)
Dim Source Basis %-8d %-
8s %-8b Description -------
_olap_allocate_errorlog_header - -------- -------- -----------
_olap_analyze_max 10000
_olap_continuous_trace_file FALSE
_olap_dbgoutfile_echo_to_eventlog FALSE
_olap_dimension_corehash_class 1
_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 2
_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_poutlog_echo_to_eventlog FALSE
_olap_sesscache_enabled TRUE
_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_choose_permutation 0
_optimizer_complex_pred_selectivity TRUE
_optimizer_compute_index_stats TRUE
_optimizer_connect_by_combine_sw TRUE
_optimizer_connect_by_cost_based 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_elimination TRUE
_optimizer_dyn_smp_blks 32
_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 240
_optimizer_filter_pred_pullup TRUE
_optimizer_fkr_index_cost_bias 10
_optimizer_free_transformation_heap TRUE
_optimizer_group_by_placement TRUE
_optimizer_ignore_hints FALSE
_optimizer_improve_selectivity TRUE
_optimizer_invalidation_period 18000
_optimizer_join_elimination_enabled 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_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_trace none
_optimizer_transitivity_retain TRUE
_optimizer_undo_changes FALSE
_optimizer_undo_cost_change 11.1.0.6
_optimizer_use_subheap TRUE
_or_expand_nvl_predicate TRUE
_oradbg_pathname
_oradebug_force FALSE
_ordered_nested_loop TRUE
_ordered_semijoin TRUE
_orph_cln_interval 1200
_os_sched_high_priority 1
_other_wait_event_exclusion
_other_wait_threshold 0
_outline_bitmap_tree TRUE
_parallel_adaptive_max_users 2
_parallel_broadcast_enabled TRUE
_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 206592
_parallel_policy MANUAL
_parallel_recovery_stopat 32767
_parallel_replay_msg_limit 4000
_parallel_server_idle_time 30000
_parallel_server_sleep_time 10
_parallel_slave_acquisition_wait 1
_parallel_time_threshold 10
_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
_ping_level 3
_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_minimum_cache_hit_percent 20
_plsql_nvl_optimize FALSE
_pmon_load_constants 300,192,64,3,10,10,0,0
_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_granule_size 100000
_px_index_sampling 200
_px_io_process_bandwidth 200
_px_io_system_bandwidth 0
_px_kxib_tracing 0
_px_load_publish_interval 200
_px_loc_msg_cost 1000
_px_max_granules_per_slave 100
_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_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
_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_mode SLFLUSH
_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_verify_writes FALSE
_recursive_imu_transactions FALSE
_redo_compatibility_check FALSE
_redo_read_from_memory TRUE
_redo_transport_compress_all FALSE
_release_insert_threshold 5
_reliable_block_sends FALSE
_remove_aggr_subquery TRUE
_replace_virtual_columns TRUE
_resource_manager_always_off FALSE
_resource_manager_always_on TRUE
_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_timeout 60
_reuse_index_loop 5
_right_outer_hash_enable TRUE
_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
_rtc_infeasible_threshold 10
_sage_enabled 1
_sage_fcre TRUE
_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
_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
_session_cached_instantiations 60
_session_context_size 10000
_session_idle_bit_latches 0
_session_idle_check_interval 60
_session_kept_cursor_pins 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
_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_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_reaping 1000
_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
_skip_assume_msg TRUE
_slave_mapping_enabled TRUE
_slave_mapping_group_size 0
_small_table_threshold 541
_smm_advice_enabled TRUE
_smm_advice_log_size 0
_smm_auto_cost_enabled TRUE
_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 40960
_smm_min_size 204
_smm_px_max_size 102400
_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
_space_align_size 1048576
_spin_count 1
_spr_max_rules 10000
_spr_push_pred_refspr TRUE
_spr_use_AW_AS TRUE
_spr_use_hash_table FALSE
_sql_analyze_parse_model 2
_sql_connect_capability_override 0
_sql_connect_capability_table
_sql_hash_debug 0
_sql_model_unfold_forloops RUN_TIME
_sql_plan_baseline_capture_on_1_exec FALSE
_sqlexec_progression_cost 1000
_sqlmon_max_plan 20
_sqlmon_max_planlines 300
_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
_static_backgrounds
_statistics_based_srf_enabled TRUE
_step_down_limit_in_pct 1
_stn_trace 0
_storage_predicate_access_predicate 0
_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_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
_target_rba_max_lag_percentage 90
_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
_test_spacebg 0
_third_spare_parameter
_threshold_alerts_enable 1
_timemodel_collection TRUE
_timeout_actions_enabled TRUE
_timer_precision 20
_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
_truncate_optimization_enabled TRUE
_tsenc_tracing 0
_tsm_connect_string
_tsm_disable_auto_cleanup 1
_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_best_fit FALSE
_use_column_stats_for_function TRUE
_use_ism TRUE
_use_ism_for_pga TRUE
_use_nosegment_indexes FALSE
_use_realfree_heap TRUE
_use_seq_process_cache TRUE
_use_vector_post TRUE
_use_zero_copy_io TRUE
_validate_flashback_database FALSE
_vendor_lib_loc
_verify_flashback_redo TRUE
_verify_undo_quota FALSE
_very_large_partitioned_table 1024
_virtual_column_overload_allowed TRUE
_wait_breakup_threshold_csecs 600
_wait_breakup_time_csecs 300
_wait_for_sync TRUE
_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 FALSE
_xsolapi_fetch_type PARTIAL
_xsolapi_fix_vptrs FALSE
_xsolapi_generate_with_clause FALSE
_xsolapi_hierarchy_value_type unique
_xsolapi_load_at_process_start NEVER
_xsolapi_materialization_rowcache_min_rows_for_us
e 1
_xsolapi_materialize_sources TRUE
_xsolapi_metadata_reader_mode 11_ONLY
_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
_yield_check_interval 100000
Description
bitvec to specify dumps prior to 4031 error
Dump 4031 error once for each n-second interval
Maximum number of 4031 dumps for this process
Dump 4031 SGA heapdump error once for each n-second interval
Maximum number of SGA heapdumps
Set of nodes that this instance should run on
aggregate size in bytes of NUMA pool
Use Large Pool as source of PX buffers
UTL_FILE backout event which allows UTL_FILE to open symlinks
Actual size of DEFAULT buffer pool for standard block size buffers
service names for broker use
Actual size in bytes of java pool
Actual size in bytes of large pool
ORACLE_BASE
Current target size for the aggregate PGA memory consumed
Actual size of SGA
Actual size of shared IO pool
Actual size in bytes of shared pool
Actual size in bytes of streams pool
if TRUE, abort recovery on join reconfigurations
List of parameters for rolling operation
if TRUE optimize dlm reconfiguration for active/standby OPS
Adaptive Direct Read
enable/disable adaptive fetch in parallel group by
Allows new add column optimization
add stale mv to dependency list
governs whether ADDM gets run automatically after every AWR
snapshot
comma-separated list of ADDM nodes to skip
governs whether ADDM checks the input AWR snapshot version
If TRUE, we will adjust the SQL/PLUS output
enable/disable affinity at run time
Number of aiowait timeouts before error is reported
seconds before an alert message is moved to exception queue
Enable Alert Message Cleanup
Enable Alert Message Purge
Enable Background Alert Posting
treat all dblinks as shared
should files be examined in creation order during allocation
interval at which successful search in L1 should be updated
allow for commutativity of +, * when comparing expressions
Allow dropping snapshot standby guaranteed restore point
Allow error simulation for testing
allow level without connect by
allow read-only open even if database is corrupt
allow resetlogs even if it will cause corruption
Allow checking Disk Group SAGE Attr
Finish terminal recovery even if it may cause corruption
enable alternate index-organized table leaf-block split-points
always use this method for anti-join when possible
always use this method for semi-join when possible
always favor use of star transformation
enable app ctx versioning
scan limit for Time Managers to clean up IOT
Variable to simulate corruption errors during archivals
ARCH I/O slaves
Enable array update vector read
Ratio of the number of in-memory samples to the number of samples
actually written to disk
To enable or disable Active Session History flushing
Oracle internal dummy ASH parameter used ONLY for testing!
The percentage above which if the in-memory ASH is full the
emergency flusher will be triggered
To enable or disable Active Session sampling and flushing
Minimum Time interval passed to consider MMNL Dump
To enable or disable sampling every connected session including ones
waiting for idle waits
Time interval between two successive Active Session samples in
millisecs
To set the size of the in-memory Active Session History buffers
initial ACD chunks created
Discovery only raw devices
Enable disk resilvering for external redundancy
allocation unit size
metadata block size
default ASM compatibility level
dbms_diskgroup.checkfile does not check block headers
seconds to wait before dropping a failing disk
max number of concurrent disks to emulate I/O errors
timeout before emulation begins (in 3s ticks)
KFDP event
KFIO event
library search order for discovery
Maximum size of individual I/O request
quantum (in 3s) used to compute elapsed time for disk drop
runtime capability for volume support returns supported
skip the checking of the clients for s/w compatibility for resize
ASM file stripe size
ASM file stripe width
Max/imum time to wait before asmb exits
Osmlib test event
ASM instance id
ASSM default
if TRUE, issue recovery claims asynchronously
if TRUE, issue recovery reads asynchronously
check tablespace thresholds asynchronously
auto assign CGs for sessions
Enable AUTOTASK Test Mode
memory broker statistics gathering interval for auto memory
Maximum Logical Maintenance Window Length in minutes
Minimum Maintenance Window Length in minutes
idle time to trigger auto-shutdown a gtx background process
interval to autotune global transaction background processes
auto-tune threshold for degree of global transaction concurrency
if TRUE, do not prepare a buffer when the master is local
Enables AW Row Source instead of collection iterator
AWR Corrupt Mode
Disable flushing of specified AWR tables
Enable/Disable Flushing AWR Threshold Metrics
Enable/Disable Flushing AWR Workload Metrics
Enable/disable AWR MMON CPU Usage Tracking
AWR Restrict Mode
Setting for AWR SQL Child Limit
enable the use of bitmap plans for tables w. only B-tree indexes
BACKUP Disk I/O slaves
specifies encryption block optimization mode
memory to reserve from the large pool
specifies buffer size to be used by BZIP2 compression
specifies memory level for ZLIB compression
specifies number of iterations done by BZIP2 compression
specifies compression (performance) level for ZLIB compression
specifies compression scheme
specifies compression type used by kgc BZIP2 compression
specifies window size for ZLIB compression
number of the ksfq buffers used for backup/restore
maximum number of the ksfq buffer used for backup/restore
size of the ksfq buffer used for backup/restore
largest gap in an incremental/optimized backup buffer, in bytes
number of bitmaps to store for each datafile
maximum size of all change tracking buffer allocations, in bytes
mininum number of extents to allocate per buffer allocation
size of one change tracking buffer allocation, in bytes
change tracking datafile chunk size, in bytes
change tracking reserved crash recovery SGA space, in bytes
block size of change tracking file, in bytes
extent size of change tracking file, in bytes
change tracking file for fixed tables
initial number of entries in the private change tracking dba buffers
total size of all public change tracking dba buffers, in bytes
controls extensions to partition pruning for general predicates
change tracking possible
blocking session graph cache size in bytes
number of consecutive blocks per global cache server
debug level for bloom filtering
enables or disables bloom filter
enables or disables bloom filter predicate pushdown
Enable partition pruning using bloom filtering
number of elements in a bloom filter vector
Adaptive Thresholds Enabled
allow rewrites with multiple MVs and base tables
buffer busy wait time in centiseconds
Flow control threshold for buffered publishers except capture
Stop enforcing flow control for buffered queues
DEFERRED MV creation skipping MV log setup update
how many blocks should we allocate per free list on advancing HWM
if TRUE, generate a BWR for a flushed PI
if TRUE, enable cache stats monitoring
To set the size of the PGA I/O recording buffers
Flow control threshold for capture publishers
case sensitive logon enabled
CGS reconfiguration timeout interval
CGS send timeout value
CGS messaging tickets
perform block check after checksum if both are turned on
check block new invariant for flashback
check tablespace thresholds
no. of undo entries to apply per transaction cleanup
bypass the client result cache
close cursors cached by PL/SQL at each commit
cluster library selection
enable/disable clusterwide global transactions
collapse wait history
Collect Statistics v$undostat
Column compression ratio
turn off predicate-only column elimination
column usage tracking
Size of the compilation call heaps extents
enable complex view merging
number of recompression above cache for sanity check
Compression advisor
percentage of chained rows allowed for Compression
control file block size in bytes
dump the system states after controlfile enqueue timeout
control file enqueue max holding time in seconds
control file enqueue timeout in seconds
control file initial section size
control file max expansion rate
controlfile update sanity check
enables conversion of set operator to join
parallel recovery coordinator side extra message buffer size
corrupted undo segment list
enables costing of equality semi-join
connection pool number of hash latches
divisor for converting CPU cost to I/O cost
if TRUE, grant lock for CR requests when block is in global role
turn 3-way CR grants off, make it automatic, or turn it on
if TRUE, flush redo log before serving a CR buffer
maximum size of the cursor bind capture area
interval (in seconds) between two bind capture for a cursor
additional number of buffers a cursor can pin at once
Shared cursor features enabled bits.
enable collection and display of cursor plans
version of cursor plan hash value
enables/disables using unparse to build projection/predicates
Hash table buckets for cursor stats (2^).
Heaps/latches for cursor stats.
enable weak view checking
Touch count set when buffer cooled
Make CR buffers always be too cold to keep in cache
Touch count which sends a buffer to head of replacement list
Touch count set when buffer moved to head of replacement list
Touch count which sends a buffer to head of replacement list
Always perform block check and checksum for System tablespace
adjacent cache buffer checks - low blkchk overwrite parameter
adjacent cache buffer check level
Align Direct Reads
enable bad write checks
Number of database blocks cached in memory: hidden parameter
Always clone data blocks on get (for debugging)
buffer header tracing (non-zero only when debugging)
buffer header tracing level
number of unmapped buffers (for tracking swap calls on blocks)
protect database blocks (true only when debugging)
protect database blocks (for strictly internal use only)
Check more and dump block before image for debugging
check objd and typ on cache disk read
threshold number of block recovery attempts
do full block read even if some blocks are in cache
Number of database block hash buckets
Number of database block hash latches
number of extra buffer headers to use as guard pages
Fraction of writes for high priority reasons
Initial Percentage of buffers to maintain known clean
number of lru latches
Maximum Allowed Number of CR buffers per dba
Percentage of buffers to inspect when looking for free
Fraction of writes for medium priority reasons
Number of NUMA nodes
Batched IO enable fast longjumps
Prefetch limit in blocks
Prefetch force override in blocks
Batched IO enable private cache
Prefetch quota as a percent of cache size
Batched IO enable skip reading buffers
Size of shared table scan read buffer
generate redo for temp blocks
trace buffer protect calls
check of rvlm mapping leaks (for debugging)
Threshold for allowable vlm leaks
Number of blocks per hash latch
cache advisory simulation batch size
cache advisory sampling factor
check for costly crx examination functions
Buffer Cache Pre-Warm Enabled : hidden parameter
maximum number of cr pins a process may have
enable db change notification
Diable Temp Encryption for Spills
enable fast object drop sanity check
enable fast object checkpoint
enable fast object truncate
Sequential I/O buf size
multiblock read count for regular clients
Block formatting I/O buf count
number of noncontiguous db blocks to be prefetched
multiblock read count for regular clients
System-wide simultaneous buffer operations
Buffer handles cached each process
track hot blocks for hash latch contention
index block checking override parameter
Number of buffers which force dirty queue to be written
Enable scn based lost write detection mechanism
MTTR advisory
number of partitions for MTTR advisory
MTTR simulation sampling factor
MTTR simulation targets
MTTR simulation trace size
dump trace entries to alert file
Image redo logging (NOARCHIVEMODE)
number of evict wait events
enable ksr in object checkpoint/reuse
Percent of default buffer pool considered hot
Percent of keep buffer pool considered hot
Percent of recycle buffer pool considered hot
size of cache created per cpu in deferred cache create
default database recovery temporal file location
percent of fairshare a processor group should always use
row overlap checking override parameter for data/index blocks
buffer cache deferred create
Number of writes DBWR should wait for
Size of memory allocated to dbwriter for coalescing writes
Limit on size of coalesced write
If FALSE, DBWR will not downgrade IMU txns for AGING
maintain dbwr histogram statistics in x$kcbbhs
Max number of outstanding DB Writer IOs
Enable DBWR no-memcopy coalescing
Enable lost write detection mechanism
debug process startup
Security level in DBMS_SQL
Enable dbwriter asynchronous writes
dbwriter scan interval
Enable dbwriter tracing
Initialize Flood Control at database open
PMON dead process scan interval
automatic deadlock resolution diagnostics level
create incidents during deadlock resolution
automatic deadlock resolution level
the minimum wait timeout required for deadlock resolution
the amount of time given to process a deadlock resolution signal
dedicated server poll count
dedicated server post/wait
dedicated server post/wait call
default encryption algorithm
sanity check on default selectivity for like/range predicate
defer media recovery checkpoint at log boundary
Number of log boundaries media recovery checkpoint lags behind
delays index maintenance until after MV is refreshed
The desired percentage of redo reading from memory
Enable/disable ADR MMON Auto Purging
Parameter to enable/disable Diag ADR
Test parameter for Diagnosability
Backward Compatibility for Diagnosability
Parameter to enable/disable Diag Call Context
Parameter to enable/disable Diag Configuration Capture
start DIAG daemon
diag dde async actions: message age limit (in seconds)
diag dde async actions: action cputime limit (in seconds)
diag dde async actions: dispatch mode
diag dde async actions: message buffer capacity
diag dde async actions: number of preallocated message buffers
diag dde async actions: message processing rate - per loop
diag dde async actions: action runtime limit (in seconds)
diag dde async actions: max number of concurrent slave processes
enable DDE handling of critical errors
Parameter to enable/disable Diag Flood Control
Override Implicit Error Flood Control time parameter
Override Macro Error Flood Control time parameter
The minimum delay between two MMON incident sweeps (minutes)
Turn off diag diagnostics
timeout parameter for SYNC dump
Parameter to enable/disable Diag HM Reactive Checks
Parameter to enable/disable Diag HM Test(dummy) Checks
UTS control parameter
control dimension skip when null feature
disable direct path insert features
disable policy timeout error (ORA-12751)
adaptive shrunk aggregation
disable autotune global transaction background processes
disable datalayer sampling
Turn off connection duplexing
fast aggregation
disable PL/SQL fast validation
Do Not Use Fastopen
disable flashback archiver query rewrite
disable flashback archiver wait for prepared transactions
disable file locks for control, data, redo log files
disable flashback archiver
Disable flashback wait callback
disable function-based index matching
Disable Health Check
disable high-res tick counter
Disable Oracle executable image checking
Disable incremental checkpoints for thread recovery
Disable incremental recovery checkpoint mechanism
disable index block prefetching
disable instance type check for ksp
disable interface checking at startup
Disable KCB flashback block new optimization
disable kcbh(c)xor OSD functionality
Disable KCBL flashback block new optimization
disable latch-free SCN writes using 32-bit compare & swap
disable latch-free SCN writes using 64-bit compare & swap
Disable logging
Disable Metrics Group (or all Metrics Groups)
disable multiple block size support (for debugging)
disable odm feature
Disable parallel conventional loads
Disable read-only open dictionary check
disable space usage checks for storage reconfiguration
Disable the new recoverable recovery mechanism
Disable the read optimization during media recovery
disable row sampling IO optimization
disable the fix for bug 1402161
disable low-res (sec) counter
Disable self-tune checkpointing
disable streams pool auto tuning
Disable IPC OSD support for Sun RSMAPI
disable system state dump
Disable thread internal disable feature
disable txn layer alert
disable vktm process
Disable wait stack
enable OLTP mode
DiSKMon skgznp pipe name
scale to display rate statistic (100ths of a second)
time-to-live for rate statistic (100ths of a second)
enables unnesting of in subquery into distinct view
number of seconds RECO holds outbound connections open
Trace string of global enqueue type(s)
max percentage of the shared pool to use for a mining model
enable modification monitoring
maximum number of rows from one call to domain index fetch
routine
maximum number of rows for one call to domain index dml routines
Maximum number of BMRs that can be done to a file
Maximum percentage of blocks in a file that can be BMR-ed
Enable the periodic creation of the offline dictionary for DRA
drop_table_granule
reduce SGA memory use during drop of a partitioned table
Dynamic Sampling Service defaults: #IOs and IO Size
enable full cache flush for parallel execution
size of Decision Tree Classification work area
Decision Tree Binning Enabled
Decision Tree Binning Test ID
Decision Tree Using Compressed Bitmaps Enabled
maximum number of surrogates
Decision Tree Pruning Enabled
dummy instance started by RMAN
dump common subexpressions
dump connect by loop error message into trc file
dump comp/exec heap sizes to tryace file
trace dump time interval limit (in seconds)
max number of dump within dump interval
dump top level query parse tree to trace
if TRUE enables IPC dump at instance eviction time
scope of sysstate dump during instance termination
scope of trace dump during a process crash
rls policies are dynamic
delay threshold (in seconds) between sending statistics messages
enable edition based redefinition
enables elimination of common sub-expressions
number of EMON slaves doing regular database notifications
Enable NUMA specific optimizations
if 1, Automated Maintenance Is Enabled
Automatic SQL Tuning Advisory enabled parameter
enable block level recovery
enable commit SCN caching for all transactions
use this to turn off ddls with wait semantics
to enable default implementation of affinity osds
enable dml lock escalation against partitioned tables if TRUE
use check constraints on the table for validation
enable fast refresh after move tablespace
TRUE - enable hash cluster overflow based on SIZE
enable HWM synchronization
Enable List I/O
enable midtier affinity metrics processing
Enable skgxp driver usage for native net
enable object queues
Allow online index creation algorithm without S DML lock
mv rewrite on remote table/view
enable or disable MV refresh scheduling (revert to 9.2 behavior)
Enable reliable latch waits
enable RLB metrics processing
use the row shipping optimization for wide table selects
use this to turn off scn wait interface in kta
enable/disable separable transactions
temporary to disable/enable kgh policy
Enable shared server vector I/O
enable space pre-allocation
enable space management background task
enable tablespace alerts
enable type dependent selectivity estimates
chunk comment for selective overrun protection
heap comment for selective overrun protection
selective overrun protection for subeheaps
requests with timeout nocache read (0 disables heuristic)
maximum #entries in inode cache
verify cached inode via deserialization
minimum lob size for cache->nocache write (0 disables heuristic)
minimum lob length for inode cacheability
force CR when reading data blocks of direct-write lobs
force CR when reading metadata blocks of direct-write lobs
force storage settings for all lobs
maximum lob size for full readahead
inject asserts into the inode
inject crashes into the inode
allow inline transformed lobs
inline inode evolution preference (data, headless, lhb)
#entries in lhb/itree blocks (for testing only)
trace accesses to inode memory outside kdli API functions
#entries in RCI lobmap before migration to lhb
shared/cached IO readahead limit
shared/cached IO readahead strategy
use recent (not dependent) scns for block format/allocation
reshape an inode to inline or headless on length truncation
invoke inode read/write callbacks safely
asynchronous shared IO
use exponential backoff when attempting SIOP allocations
maximum blocks per IO slot
degree-of-parallelism in the SIO keep pool
reap asynchronous IO in the foreground
shared IO fileopen mode: datasync vs nodatasync vs async
enable shared IO pool operations
free IO buffers when not in active use
shared IO pool read threshold
shared IO pool write threshold
maximum #IO buffers to allocate per session
maximum #IO descriptors to allocate per session
enable shared IO pool operations
use PGA allocations for direct IO
PGA allocations come from toplevel PGA heap
shared IO strategy: block vs. extent
size limit of small inode cache
sort dbas during chunkification
maximum size of the space cache in #blocks
compact lobmap extents with contiguous dbas
dump inode timers on session termination
trace inode timers to uts/tracefile
inode trace level
UTS kdlu bucket size
UTS kdlu bucket size for mts
UTS kdlu per-layer trace level
UTS session dump
UTS system dump
enable ksi locking for lobs
enable lob write gathering for sql txns
WGC flush threshold in bytes
size of compression sub-unit in bytes
deduplication flush threshold in bytes
secure hash algorithm for deduplication - only on SecureFiles
deduplication prefix hash threshold in bytes
enable lob compression - only on SecureFiles
enable lob deduplication - only on SecureFiles
enable deduplicate validate - only on SecureFiles
enable lob encryption - only on SecureFiles
minimum transformation size in bytes
minimum comp ratio in pct - only on SecureFiles
deduplication spare 1
enable xfm cache - only on SecureFiles
control kdt buffering for conventional inserts
kebm # strikes to auto suspend an action
kebm auto suspension time in seconds
remote column size does not get modified
kernel message network driver
size of kffmap_hash table
size of kffmop_hash table
disable set fence calls and revert to default (process fence)
max kghdsidx count
index to the bucket count array
Library cache debugging
Library cache features enabled bits
fixed extent size for library cache memory allocations
whether KGL hash collision is possible
extent size for library cache heap 0
capture stacks for library and row cache state objects
maximum heap size before KGL writes warnings to the alert log
number of library cache latches
RAC message lock count
Minimum cached SO count. If > 1 can help find SO corruptions
whether KGL to support multi-instance invalidations
whether KGL to support multi-instance locks
whether KGL to support multi-instance pins
The depth of the stack capture for SO get or free
time to wait for locks and pins before timing out
max percentage of shared pool size to be used for KGL advice
threshold size for base allocator
# of mutex latches if CAS is not supported.
third spare parameter - integer
enable killing controlfile enqueue blocker on timeout
timeout delay in seconds before killing enqueue blocker
if greater than 0 enables killing enqueue blocker
Kill Java threads and do sessionspace migration at end of call
Process dump on kill session immediate
kkdlgon maximum number of iterations
trace expression substitution
percentage of cursor stats buckets to scan on each load, in 1/10th of
a percent
Turning on this will make KKS use mutex for cursor pins.
Size limit of Materialized View and Object Table Lookup Cache
allow kolf to use slffopen
tracing level for library cache subheap level pins
disable the call to ksb_diagpid
process uptime for restarts
process restart policy times in seconds
KSD test parmeter
default timeout for internal oradebug commands
if TRUE ksdxdocmd* invocations are enabled
ksdxw context initialization flag
ksdxw number of buffers in buffered mode
number of watchpoints on a per-process basis
number of watchpoints to be shared by all processes
number of PCs to collect in the stack when watchpoint is hit
amount of time a dying process is spared by PMON (in centi-secs)
kse pc table cache size
number of entries in the kse stack signature cache
number of stack frames to cache per kse signature
ring buffer to debug internal error 17090
verify asynchronous writes issued through ksfd
KSI trace string of lock type(s)
memory tracing: use ksi-private or rdbms-shared bucket
size of the KSI trace bucket
ksmb debug flags
KSMD protect mode for catching stale access
granule locking status
granule size in bytes
timeout action interval in minutes
repeat count for acquisition of locks
timeouts for TAC registerd by kspol
number of ksr unit test processes
if TRUE access violations during kss dumps are not recorded
number of seconds ksuitm waits before killing diag
command to execute when dead processes don't go away
delay inst. termination to allow processes to dump
bg slave spawn failure limit
bg slave pool terminate timeout
bg slave pool wait limit
control all spawning of background slaves
ksv internal pkt test
set to OFF to disable automatic slowsend diagnostics
disable dynamic loadin of lib skgxp
disable ipc statistics
initial number arrays for ipc statistics
max. arrays for ipc statistics
disable dynamic loadin of lib skgxp
max. arrays for ipc statistics
tune ksxp layer reaping limit
reporting process for KSXP
set timeout for sends queued with the inter-instance IPC
over-ride default location of lib skgxp compat
over-ride default location of lib skgxp
limit ipc statistics memory. this parameter is a percentage value
KSXP test parameter
enable byte transformation unit test
for ktc debug
number of ktc latches
segment pre-extension warning threshold in percentage
maximum segments supported by space search cache
tablespace pre-extension warning threshold in percentage
number of KTU latches
datapump trace parameter
minimum allocation size in bytes for the large allocation pool
period over which an instance can retain an active level1 bitmap
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 override
Sid of process for which to collect latch stats
align latch recovery structures
size of write IOs used during a load operation
enable random distribution method for left of nestedloops
LGWR Asynchronous Broadcasts enabling boolean flag
LGWR write delay for debugging
LGWR I/O slaves
Maximum wait time for lgwr to allow NetServer to progress
Variable to simulate network latency or buffer threshold
Variable to simulate network latency or buffer threshold
Variable to simulate errors lgwrns
Variable to simulate errors lgwr true async
whether KGL advice should be turned on
Lightweight headers for redo
treat LIKE predicate with bind as an equality predicate
threshold value to activate an additional lms
if TRUE makes ASM use enqueue master hashing for fusion locks
GES better deadlock victim
how often to cleanup level 0 cache res (in sec)
percentage of cached resources should be cleanup
cache resource: string of lock types(s)
GES checksum batch messages
number of contiguous blocks that will hash to the same HV bucket
dd time interval in seconds
max dd search time per token
dd scan interval in seconds
number of dd search per token get
dynamic remastering maximum affinity requests processed together
dynamic remastering bucket window size
dynamic remastering forced exclusive latches
dynamic lms invocation
dynamic load adjustment
Number of ges enqueue element freelist
if TRUE enables enqueue reconfiguration
Number of enqueue freelist
mapping between file id and master instance number
if TRUE deliver global posts to remote nodes
GES idle connection check
GES idle connection check interval time
GES idle connection kill
default wait time for lmd in centiseconds
if TRUE makes lmon get nowait latches with timeout loop
number of background gcs server processes to start
default wait time for lms in centiseconds
number of enqueues configured for cluster database
master resource weight for this instance
max. number of background global cache server processes
GES batch message size
GES message buffer cleanup interval time
cluster database node join optimization in reconfig
disable cluster database fault-tolerance mode
number of buckets in the object affinity hash table
number of latches in the object affinity hash table
postevent buffer size
reconfiguration: process freeze timeout
GES implicit process batching for IPC messages
number of client processes configured for cluster database
enable pseudo reconfiguration
Reconfiguration timeout
receiver hang allow time in seconds
receiver hang check frequency in seconds
to kill receiver hang
number of resource hash buckets
number of resource partition configured for gcs
number of resources configured for cluster database
GES send mode
GES send queue message batching
GES send queue maximum length
GES percentage of send proxy reserve of send tickets
if TRUE enables share lock optimization
GES send queue minimum batching factor
GES send queue batching mechanism
GES send queue batching waittime in tick
Synchronization timeout for DLM reconfiguration steps
Flow control ticket active sendback threshold
GES messaging tickets
TX lock localization delta
if TRUE enables resource name validation
number of transaction IDs configured for cluster database
suppl logging for compression enabled
Load PL/SQL or Database objects without compilation
enable local communication costing when TRUE
set the ratio between global and local communication (0..100)
the interval at which local hang analysis is run
Lock specified areas of the SGA in physical memory
log archive avoid memcpy
Number of buffers to allocate for archiving
archival callout
Bypass database rules for enabling archivelog compression
Log archive network redo buffer size used by ARCH
log archive protection auto demotion
log archive security enabled
log archive security strong auth
log block images when changed during backup
corrupt redo buffers before write
debug redo buffers (slows things down)
# redo blocks to verify after checkpoint
Log commit-time block cleanout
archivelog deletion policy for mandatory/all destination
number of the log writer event queues
automatically initiate log write if this many redo blocks in buffer
Enable dynamic strands
Maximum number of log buffer strands
Private strand multiplier for log space preallocation
Number of private log buffer strands for zero-copy redo
Active sessions multiplier to deduce number of private strands
Number of log read buffers for media recovery
number of simultaneous copies into redo buffer(# of copy latches)
should we report space errors to alert log
Maximum number of seconds redos in the current log could span
number of processes that can logout in a second
maximum retry count for logouts
timeout in centi-seconds for time to wait between retries
longops stats enabled
low server thresholds
tracing level for load table conventional
direct sends for messages from master (DFS)
refresh materialized views using consistent read snapshot
materialized view MAV refreshes avoid double counting
optimizations during refresh of materialized views
# tables for union all expansion during materialized view refresh
Maximum wait by ARCH to allow NetServer to complete archival
max sleep during exponential backoff
Maximum I/O size in bytes for sequential file accesses
IORM:max number of large I/O's to issue
Maximum time spent by LNS to archive last log during shutdown
Max occurrence protocols supported in a process
number of segments for which shrink stats will be maintained
max time to sleep while holding a latch
IORM:max number of small I/O's to issue
maximum space management background slaves
maximum space management background tasks
max tempspc overhead
media recovery block read batch
private memory annotation collection level
memory annotation pre-allocation scaling
shared memory annotation collection level
memory annotation in-memory store
standard extent size for fixed-size-extent heaps
memory broker num stat entries
Marginal Utility threshold pct for bc
Marginal Utility threshold pct for sp
memory broker allow policy to shrink shared pool
memory broker allow policy to shrink java pool
memory broker allow policy to shrink streams pool
memory broker policy to timeout shrink shared/java pool
memory broker statistics gathering interval for auto sga
trace memory management activity
do not cancel deferred sga reqs with auto-memory
partial granule sanity check
message queue resources - dependent on # processes & # buffers
cluster wait threshold to enter affinity
goodness gradient threshold to dissolve affinity
default timeout for midtier affinity processing
max percentage of block space + minfree before we mark block full
prohibit stats aggregation at compile/partition maintenance time
minimum number freeable blocks for shrink to be present
Minimum flashback retention
minimum number freeable extents for shrink to be present
Minimum SCN to start with in 2^30 units
Save buffers for debugging redo corruptions
allow rewrites with multiple MVs and/or base tables
force multi instance or single instance parallel recovery
TRUE iff multi-join-key table lookup prefetch is enabled
use multiple instances for media recovery
what percent to analyze after complete/PCT refresh
refresh decision based on cost or on rules
delta mv as fractional percentage of size of mv
refresh materialized views using EUT(partition)-based algorithm
force materialized view refreshes to use parallel query
materialized view MV refresh new setup disabling
minimum percentage change required in MV to force an indexrebuild
create materialized views with selections and fast refresh
pass cardinality hints to refresh queries
proportionality constant for dop vs. time in MV refresh
create/alter mv uses rolling cursor invalidation instead of immediate
Enable/disable Maintenance Window Schedules
NLS allow Implicit Conversion between CHAR and NCHAR
should implicit conversion bewteen clob and nclob be allowed
enable multi-block readahead for an index scan
turn on multi-block readahead tracing
native compilation shared objects dir
nested loop fudge
nested MAV refresh fast on commit allowed
enable initial join orders based on new ordering heuristics
enables the use of new cost estimate for sort
controls whether new sorts can be used as system sort
controls when new sort avoids sorting ordered input
specifies options for the new sort algorithm
enable batching of the RHS IO in NLJ
enable exceptions for buffer cache misses
no object features are used
OR expansion during optimization disabled
no recovery through this resetlogs operation
notify cluster ready services of startup and shutdown
Flush wait time for NetServer to flush oustanding writes
Data Loss Time Bound for NetServer
number of child latches for long op array
maximum number of cached attributes per instance
if 1 or higher, handle object reuse
enable the object level statistics collection
Maximum number of entries to be tracked per stat
offline undo segment list
GMS home directory
OLAP Aggregate max buffer size
OLAP Aggregate debug flags
OLAP Aggregate function cache enabler
OLAP Aggregate function merge threshold
OLAP Aggregate max thread tuples creation
OLAP Aggregate min buffer size
OLAP Aggregate minimum cardinality of dimensions for thread
OLAP Aggregate Multi-path Hierarhies enabled
OLAP Aggregate status array usage threshold
OLAP Aggregate function storeback probability
OLAP Aggregate max work parents
OLAP Aggregate max worklists generated at once
OLAP Allocate Errorlog Format
OLAP Allocate Errorlog Header format
OLAP DML ANALYZE command max cells to analyze
Specify TRUE to enable continuous OLAP tracing - otherwise only
exceptional events will be logged
OLAP DbgOutfile copy output to event log (tracefile)
OLAP Dimension In-Core Hash Table Class
OLAP Dimension In-Core Hash Table Large Threshold
OLAP Dimension In-Core Hash Table Pressure Threshold
OLAP Dimension In-Core Hash Table Maximum Memory Use
OLAP Dimension In-Core Hash Table Small Threshold
OLAP EIF Export BLOB size
Limitmap generator dimension column size
Limitmap generator measure column size
OLAP Object Hash Table Class
OLAP Page Pool Expand Rate
OLAP Page Pool High Watermark
OLAP Page Pool Hit Target
OLAP Page Pool Low Watermark
OLAP Page Pool Pressure Threshold
OLAP Page Pool Shrink Rate
OLAP parallel update pagespace by group
OLAP parallel update threshold for number of small pagespaces
OLAP parallel update threshold in pages
OLAP POutLog copy output to event log (tracefile)
OLAP Session Cache knob
OLAP Sort Buffer Size
OLAP Status Boolean max incore bits
OLAP Status Boolean CBM threshold
Specify TRUE to output OLAP table function timed statistics trace
Wrap error messages to OLAP outfile
enable olapi history retention
enable olapi interface object history collection
enable olapi interface object history retention
enable olapi interface operation history retention
enable olapi interface operation history collection
enable olapi memory alloc/free history collection
enable olapi memory alloc/free history collection pausing
enable olapi memory operation history retention
enable olapi session history collection
enable olapi session history retention
enable/disable old connect by
Clean up unnecessary entries in OLS sessinfo table
oltp compression enabled
oltp compression gain
enable/disable OMF
sanity check on default selectivity for like/range predicate
disable check for function on stack for online patches
adjust stats for skews across partitions
enable/disable dictionary stats gathering at db create/upgrade
TRUE to enable index [fast] full scan more often
improves the way default equijoin selectivity are computed
enable peeking of user binds
optimizer adaptive cursor sharing
adjust selectivity for null values
enable/disable auto stats collection job
Enables AW Join Push optimization
Enables statistcs on AW olap_table table function
enable improved costing of index access using in-list(s)
standard block size used by optimizer
cost with cache statistics
optimizer cartesian join enabled
cost factor for cost-based query transformation
disable cost based transformation query size restriction
CEIL cost in CBO
force the optimizer to use the specified permutation
enable selectivity estimation for builtin functions
force index stats collection on index creation/rebuild
combine no filtering connect by and start with
use cost-based transformation for connect by
force correct computation of subquery selectivity
enables cost-based query transformation
enables costing of filter predicates in IO cost model
add cost of generating result set when #rows per key > 1
optimizer cost model
force the optimizer to use the same degree of parallelism
use join selectivity in choosing star transformation dimensions
disable star transformation sanity checks
Eliminates redundant SELECT DISTNCT's
number of blocks for optimizer dynamic sampling
use improved density computation for selectivity estimation
use extended statistics for selectivity estimation
push filters before trying cost-based query transformation
join pred pushdown on group-by, distinct, semi-/anti-joined view
optimizer extended cursor sharing
optimizer extended cursor sharing for relational operators
controls the optimizer usage of extended stats
use cost-based flter predicate pull up transformation
Optimizer index bias over FTS/IFFS under first K rows mode
free transformation subheap after each transformation
consider group-by placement optimization
enables the embedded hints to be ignored
improve table and partial overlap join selectivity computation
time window for invalidation of cursors of analyzed objects
optimizer join elimination enabled
controls the optimizer join order search algorithm
enable/disable sanity check for multi-column join selectivity
optimizer maximum join permutations per query block
set minimum cached blocks
enable merge join cartesian
force setting of optimizer mode for user recursive SQL also
consider join-predicate pushdown that requires multi-level pushdown
to base table
generate and run plans using several compilation environments
execute full outer join using native implementaion
number of groups above which we use nested rollup exec for gset
compute join cardinality using non-rounded input values
null-aware antijoin parameter
control or expansion approach used
Use subheap for optimizer or-expansion
Eliminates order bys from views before query transformation
Enable transformation of outer-join to anti-join if possible
optimizer percent parallel
push down distinct from query block to table
use cost-based query transformation for push pred optimization
optimizer seed value for random plans
reuse cost annotations during cost-based query transformation
Default value to use for rownum bind
enable the use of first K rows due to rownum predicate
enable/disable saving old versions of optimizer stats
optimizer search limit
account for self-induced caching
enable/disable index skip scan
consider index skip scan for predicates with guessed selectivity
enable/disable sort-merge join method
enable/disable sort-merge join using inequality predicates
enables unnesting of subquery in a bottom-up manner
enable/disable star transformation in with clause queries
optimizer star transformation minimum cost
optimizer star transformation minimum ratio
optimizer star plan enabled
system statistics usage
optimizer trace parameter
retain equi-join pred upon transitive equality pred generation
undo changes to query optimizer
optimizer undo cost change
Enables physical optimizer subheap
enable OR expanded plan for NVL/DECODE predicate
path of oradbg script
force target processes to execute oradebug commands?
enable ordered nested loop costing
enable ordered semi-join subquery
qmon periodic interval for removed subscriber messages cleanup
OS high priority level
exclude event names from _other_wait_threshold calculations
threshold wait percentage for event wait class Other
BITMAP_TREE hint enabled in outline
maximum number of users running with default DOP
enable broadcasting of small inputs to hash and sort merge joins
default maximum number of instances for parallel query
Alignment of PX buffers to OS page boundary
fake db-scheduler percent used for testing
Number of buckets for each round of fix write
number of threads to allocate per instance
parallel execution load balanced slave allocation
minimum size of shared pool memory to reserve for pq servers
policy used to compute the degree of parallelism
(MANUAL/LIMITED/AUTO)
stop at -position- to step through SMON
Number of messages for each round of parallel replay
idle time before parallel query server dies (in 1/100 sec)
sleep time between dequeue timeouts (in 1/100ths)
time(in seconds) to wait before retrying slave acquisition
threshold above which a plan is a candidate for parallelization (in
seconds)
unit of work used to derive the degree of parallelism (in seconds)
enable parallel_txn hint with updates and deletes
set the parallelism cost fudge factor
parameter table block size
enable partial partition-wise join when TRUE
enable/disable partitioned views
password file enqueue timeout in seconds
materialized view PCT refreshes avoid double counting
control separation of global index maintenance for PDML
slaves start on different index when doing index maint
slaves start on different partition when doing index maint
Percent of flashback buffer filled to be considered partial full
PGA large extent size
Maximum size of the PGA memory for one process
fusion ping level
pivot implementation method
enable progressive kill test
PMON process clean-up interval (cs)
start progressive kill test instrumention
explain plan outline data enabled
Performance improvement criterion for evolving plan baselines
Local time limit to use for an individual plan verification
PL/SQL anonymous block code-type
PL/SQL Function Cache Enabled
conditions upon which the PL/SQL circular buffer is dumped
plsql minimum cache hit percentage required to keep caching active
PL/SQL NVL optimize
server load balancing constants (S,P,D,I,L,C,M)
push predicates into views before rewrite
precompute gid values and copy them before returning a row
enables predicate move-around
allow predicate elimination if set to TRUE
presume commit of IMU transactions
enable dbms_output of materialized view refresh schedule
Start address of large extent memory segment
enable projecting out unreferenced columns of a view
projection pushdown
level for projection pushdown debugging
Shift to pre 11g propagation behaviour
Protect cursor frame heaps
enable pushing join predicate inside a view
enable pushing join predicate inside a union all view
enable pushing join predicate inside a union view
asynchronous get granule in the slave
enables sharing of px cursors that were built using bind peeking
set the tq broadcasting fudge factor percentage
ttl for px mesg buffers in seconds
debug level for parallel compilation
tracing level for parallel compilation
enables or disables tracing of 12805 signal source
turn off/on restartable qerpx dynamic optimization
num of samples for restartable qerpx dynamic optimization
enable service-based constraint of px slave allocation
default size of a rowid range granule (in KB)
parallel query sampling for index create (100000 = 100%)
IO process bandwidth in MB/sec for computing DOP
total IO system bandwidth in MB/sec for computing DOP
turn on kxib tracing
interval at which LMON will check whether to publish PX load
CPU cost to send a PX message via shared memory
maximum number of rowid range granules to generate per slave
minimum number of rowid range granules to generate per slave
enables pq for minus/interect operators
CPU cost to send a PX message over the internconnect
prevent parallel partition granules to be sorted on size
prevent parallel granule stealing in shared nothing environment
enables or disables NSS Plan B reparse with outline
reduce parallel_max_servers if greater than (processes - fudge)
parallel partition wise group by enabled
turn off/on parallel rownum pushdown optimization
IPC message send timeout value in seconds
slaves share cursors with QC
px trace parameter
enables new pq for UNION operators
default size of a external table granule (in KB)
Oracle internal parameter to control QA
Oracle internal parameter to specify QA lrg type
perform the cost based rewrite with materialized views
max size of query execution cache
query mmv rewrite maximum number of cmaps per dmap in query
disjunct
query mmv rewrite maximum number of dmaps per query disjunct
query mmv rewrite maximum number of in-lists per disjunct
query mmv rewrite maximum number of intervals per disjunct
query mmv rewrite maximum number of merged cmaps
query mmv rewrite maximum number of predicates per disjunct
query mmv rewrite maximum number of query in-list values
query mmv rewrite maximum number of region permutations
perform query rewrite before&after or only before view merging
perform query rewrite before&after or only after view merging
mv rewrite and drop redundant joins
rewrite with cannonical form for expressions
mv rewrite fresh partition containment
cost based query rewrite with MVs fudge factor
mv rewrite with jg migration
query rewrite max disjuncts
allow query rewrite, if referenced tables are not dataless
perform general rewrite using set operator summaries
prune frocol chain before rewrite after view-merging
if TRUE enables parallel fixwrite at reconfiguration
if TRUE enables parallel replay and cleanup at reconfiguration
if TRUE enables parallel verify at reconfiguration
default RDBMS compatibility level
enable SAGE FPLIB filtering within rdbms
enable reraising of any exceptions in SAGE FPLIB
readable standby mode
readable standby query scn sync timeout
Simulation value with real time apply
minimum max total heap size, in Kbytes
mode flags for real-free heap
hint for real-free page size in bytes
Recoverable recovery batch size (percentage of buffer cache)
if TRUE, enable expensive integrity checks
recovery buffer cache percentage
enable thread recovery write verify
recursive transactions may be IMU
general and redo/undo compatibility sanity check
Enable reading redo from memory
Is ASYNC LNS compression allowed?
maximum number of unusable blocks to unlink from freelist
if TRUE, block sends across interconnect are reliable
enables removal of subsumed aggregated subquery
replace expressions with virtual columns
disable the resource manager always
enable the resource manager always
restore spfile to this location
result cache auto execution threshold
result cache auto max size allowed
result cache auto time distance
result cache auto time threshold
result cache block size
maximum time (sec) a session waits for a result
number of blocks being examine for index block reuse
Right Outer/Semi/Anti Hash Enabled
priority at which rman backup i/o's are done
RMAN restore through link
number of undo segments
starting undo segment number
stop at -position to step rollback
number of cached cursors for row cache management
enable row cr for all sql
row-locking
enable row shipping explain plan support
row shipping column selection threshold
if TRUE, Oracle will collect rowsource statistics
if TRUE, Oracle will capture active row sources in
v$active_session_history
frequency of rowsource statistic sampling (must be a power of 2)
Row source tree tracing level
Redo Transport Compression infeasible threshold
enable real SAGE functionality
Allow optimized file creation path for SAGE
number of rows per block used for sampling IO optimization
if TRUE, gcs resources are scattered uniformly across sub pools
if TRUE, gcs shadows are scattered uniformly across sub pools
max exponential backoff time for scn wait interface in kta
max timeout for scn wait interface in kta
sql diag crash
Whether to enable the test RPCs
second spare parameter - integer
collect kdlu timers and accumulate per layers
enable/disable selectivity for storage reduction factor
control rewrite self-join algorithm
Percentage of total physical i/os for self-tune ckpt
Self-tune checkpointing lag the tail of the redo log
if TRUE, send ast message to foreground
if TRUE, send close with block even with direct sends
if TRUE, try to send CR requests to PI buffers
enable direct read in serial
force serial recovery or parallel recovery
serializable
Number of pl/sql instantiations to cache in a session.
session app context size
one latch per session or a latch per group of sessions
Resource Manager session idle limit check interval in seconds
Number of cursors pins to keep in a session
enable session wait history collection
seventh spare parameter - string list
Allow dumping encrypted blocks in clear for debugging
sga early trace event
sga granule locking state
Shared IO pool buffer size
trace kcbi debug info to tracefile
Size of shared IO pool
shared io pool size set internal value - overwrite zero user size
maximum shared io pool size
shared pool maximum size when auto SGA enabled
shared pool minimum size when auto SGA enabled
minimum allocation size in bytes for reserved area of shared pool
percentage memory of the shared pool allocated for the reserved
area
shared server load balance
number of shared server common queues
short stack timeout in ms
percentage of exceptions at which to switch to full length aggs
enable use of variable sized buffers for non-distinct aggregates
number of messages to batch in a side channel message (DFS)
timeout before shipping out the batched side channelmessages in
seconds
timeout before shipping out the batched side channelmessages in
milliseconds
control simple view merging performed by the optimizer
simulate auto memory sga/pga transfers
LRU bucket minimum delta
simulator internal bound percent
LRU list rebalance threshold (size)
LRU list rebalance threshold (count)
LRU scan count
maximum count of invalid chunks on pin list
simulator reserved heap count
simulator reserved object count
sampling factor for the simulator
upper bound multiple of pool size
run without detached processes
Shared IO pool flashback io completion scan depth
sixth spare parameter - string list
tune skgxp OSD reaping limit
time in minutes before idle ach's are reaped
Enables delayed acks
Enables dynamic credit management
ach hiwat mark warning interval
time in seconds between interface detection checks
connection idle time in seconds before keep alive is initiated. min: 30
sec max: 1800 sec default: 300 sec
MTU size for UDP LMP testing
enable UDP long message protection
diagnostic log buffering space (in bytes) for timed wait (0 means
unbufferd
time in seconds before timed wait is invoked
disable use of high speek timer
if TRUE, skip assume message for consigns at the master
enable slave mapping when TRUE
force the number of slave group in a slave mapper
threshold level of table size for direct reads
if TRUE, enable v$pga_advice
overwrites default size of the PGA advice workarea history log
if TRUE, use the AUTO size policy cost functions
Maximum IO size (in KB) used by sort/hash-join in auto mode
Minimum IO size (in KB) used by sort/hash-join in auto mode
overwrites memory manager automatically computed bound
provides controls on the memory manager
value in KB of the instance freeable PGA memory to retain
maximum work area for insertion sort(v1)
maximum work area size in auto mode (serial)
minimum work area size in auto mode
maximum work area size in auto mode (global)
work area retain size in SGA for shared server sessions (0 for AUTO)
Turn on/off tracing for SQL memory manager
limit of SMON internal errors
limit of SMON continous undo segments re-scan
- set debug event for testing SMU operations
site ID of error simulation in KTU code
error type for error simulation in KTU code
comma-separated *AND double-quoted* list of AUM timeouts: mql,
tur, sess_exprn, qry_exprn, slot_intvl
cost ratio for sort eimination under first_rows mode
multi-block read count for sort
space align size
Amount to spin waiting for a latch
maximum number of rules in sql spreadsheet
push predicates through reference spreadsheet
enable AW for hash table in spreadsheet
use hash table for spreadsheet
SQL Analyze Parse Model control parameter
SQL Connect Capability Table Override
SQL Connect Capability Table (testing only)
Hash value of the SQL statement to debug
specifies compile-time unfolding of sql model forloops
With auto-capture on, create new SQL plan baseline on first exec
sql execution progression monitoring cost threshold
Maximum number of plans entry that can be monitored. Defaults to
20 per CPU
Number of plan lines beyond which a plan cannot be monitored
CPU/IO time threshold before a statement is monitored. 0 is disabled
Parsed category qualifier for applying hintsets
srvntfn job deq timeout
srvntfn job submit interval
srvntfn max concurrent jobs
srvntfn q msg count for job exit
srvntfn q msg count increase for job submit
Session State Capture and Restore DIRectory object
Session State Capture and Restore OS DIRectory
SQL Tuning Advisory control parameter
stack guard level
static backgrounds
enable/disable the use of statistics for storage reduction factor
step down limit in percentage
SQL tracing parameter
put storage predicate into access predicate in explain plan
streams pool maximum size when auto SGA enabled
subquery pruning cost factor
enable the use of subquery predicates to perform pruning
enable the use of subquery predicates with MVs to perform pruning
subquery pruning reduction factor
Enable/disable SWRF Metric Frequent Mode Collection
Enable/disable SWRF MMON DB Feature Usage
Enable/disable SWRF MMON FLushing
Enable/disable SWRF MMON Metrics Collection
Parameter to enable/disable SWRF
test action parameter for SWRF
Enable/disable DB Feature Usage Testing
whether to trace metadata comparisons for synonym repointing
test parameter for SYSAUX
optimizer percent system index caching
are system triggers enabled
LNS Wait time for arhcived version of online log
table lookup prefetch vector size
table lookup prefetch threshold
bump estimated full table scan and index ffs cost by one
target rba max log lag percentage
set debug mode for testing transportable database
number of blocks for a dimension before we temp transform
determines if temp table is created with cache option
test the function ksusigskip
test parmeter 1 - integer
test parameter 2 - string
test parameter 3 - string
test parameter 4 - string list
test parmeter 5 - deprecated integer
test parmeter 6 - size (ub8)
test space management background task
third spare parameter - integer
if 1, issue threshold-based alerts
enable timemodel collection
enables or disables KSU timeout actions
VKTM sleep time in milli-sec
Total memory for allocating large extents
time period for duping of TQ statistics (s)
trace buffer busy wait timeouts
trace buffer sizes per process
if TRUE on error buckets of all processes will be dumped to the
current trace file
if TRUE dump client (ie. non-kst) buckets
if TRUE on error just dump our process bucket
if TRUE filter trace dumps to always loaded dlls
trace events enabled at startup
Create publicly accessible trace files
trace kqlidp0 operation
enabling trace navigation linking
trace how long a current pin is held
trace pool size in bytes
enable KST tracing in process
trace virtual columns exprs
transaction auditing records generated in the redo log
max number of parallel recovery slaves that may be used
do truncate optimization if set to TRUE
Enable TS encryption tracing
TSM test connect string
Disable TSM auto cleanup actions
allow plugging in a tablespace with an incompatible character set
enable two-pass thread recovery
uses two-pass reverse polish alg. to generate canonical forms
UGA/CGA large extent size
maintain fast-path statistics for ultrafast latches
enable auto tuning of undo_retention
enable undo block compression
debug flag for undo related operations
invoke undo usage functions for testing
expand queries with GSets into UNIONs for rewrite
enables unnesting of correlated subqueries
enable unused block compression
user requested update of datafile headers of locally managed
datafiles with space information
use best fit to allocate space
enable the use of column statistics for DDP functions
Enable Shared Page Tables - ISM
Use ISM for allocating large extents
use nosegment indexes in explain plan
use real-free based allocator for PGA memory
whether to use process local seq cache
use vector post
Should network vector IO interface be used for data transfer
Scan database to validate result of flashback database
Vendor library search root directory
Verify that the redo logs needed for flashback are available
TRUE - verify consistency of undo quota statistics
very_large_partitioned_table
overload virtual columns expression
Wait breakup threshold (in centiseconds)
Wait breakup time (in centiseconds)
wait for sync on commit MUST BE ALWAYS TRUE
maximum number of unusable blocks to walk across freelist
is the watchpointing feature turned on?
Oracle internal test WCR parameter used ONLY for testing!
settings for window function optimizations
WITH subquery transformation
write clones flag
maximum bytes for logging peeked bind values for V$SQL_PLAN (0 =
OFF)
Explain Plan tracing parameter
OLAP API lower bound for auto materialization.
OLAP API behavior for auto materialization
OLAP API output build info to trace file
OLAP API debug output disposition
OLAP API cube densification
OLAP API symmetric overfetch
OLAP API output dml commands and expressions to trace file
OLAP API fetch type
OLAP API Enable vptr fixing logic in shared server mode
OLAP API generates WITH clause?
OLAP API hierarchy value type
When to load OLAP API library at server process start
OLAP API min number of rows required to use rowcache in query
materialization
OLAP API Enable source materialization
OLAP API metadata reader mode
OLAP API uses ODBO mode?
OLAP API enables AW position and count optimization?
OLAP API optimizes suppressions?
OLAP API precomputes subqueries?
OLAP API removes columns for materialization?
OLAP API sets NLS?
OLAP API share executors?
OLAP API output Source definitions to trace file
OLAP API multi-join non-base hints
OLAP API non-base hints
OLAP API enable automatic dimension hints
OLAP API enable automatic measure hints
OLAP API dimension hints
OLAP API enables AW join?
OLAP API enables AW QDR merge?
OLAP API generic hints
OLAP API measure hints
OLAP API SQL MINUS threshold
OLAP API enable optimization
OLAP API prepare statement cache size
OLAP API enable remove unused columns optimizations
OLAP API result set cache size
OLAP API enable symmetric predicate for dimension groups
OLAP API top dimension hints
OLAP API top measure hints
OLAP API enable bind variables optimization
OLAP API stringifies order levels?
OLAP API MTM mapping classes supported?
OLAP API suppression AW mask threshold
OLAP API suppression chunk size
OLAP API uses models?
OLAP API uses OLAP DML?
OLAP API uses OLAP DML for rank?
external tables code coverage parameter
external tables trace parameter
buffer size in KB needed for populate/query operation
allow cross platform for pre10 compatible tablespace
set cross platform info during file header read
interval to check whether actses should yield