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