Oracle_9i_hidden_parameters by jizhen1947

VIEWS: 89 PAGES: 34

									Parameter Name                         Parameter Value
_4031_dump_bitvec                      6639615
_NUMA_instance_mapping                 Not specified
_NUMA_pool_size                        Not specified
_PX_use_large_pool                     FALSE
_abort_recovery_on_join                FALSE
_active_standby_fast_reconfiguration   TRUE

_adaptive_direct_read                  TRUE
_adaptive_fetch_enabled                TRUE
_adjust_literal_replacement            FALSE
_affinity_on                           TRUE
_aiowait_timeouts                      100

_all_shared_dblinks
_allocate_creation_order               FALSE

_allocation_update_interval            3

_allow_error_simulation                FALSE
_allow_read_only_corruption            FALSE
_allow_resetlogs_corruption            FALSE
_allow_terminal_recovery_corruption    FALSE

_always_anti_join                      CHOOSE

_always_semi_join                      CHOOSE

_always_star_transformation            FALSE
_app_ctx_vers                          TRUE
_aq_tm_scanlimit                       0
_arch_io_slaves                        0
_async_recovery_claims                 TRUE

_async_recovery_reads                  TRUE
_attach_count_slack                    10
_avoid_prepare                         TRUE

_b_tree_bitmap_plans                   TRUE

_backup_disk_io_slaves                 0
_backup_io_pool_size                   1048576
_bitmap_or_improvement_enabled         TRUE

_buffer_busy_wait_timeout              100
_bump_highwater_mark_count             0
_bwr_for_flushed_pi                TRUE
_cgs_send_timeout                  300
_check_block_after_checksum        TRUE

_cleanup_rollback_entries          100

_close_cached_open_cursors         FALSE
_collect_undo_stats                TRUE
_column_elimination_off            FALSE
_column_tracking_level             1
_compatible_no_recovery            0.0.0

_complex_view_merging              TRUE
_controlfile_enqueue_timeout       900
_corrupted_rollback_segments
_cost_equality_semi_join           TRUE
_cpu_count                         0
_cpu_to_io                         0
_cr_grant_global_role              TRUE

_cr_grant_local_role               FALSE

_cr_server_log_flush               TRUE

_cursor_db_buffers_pinned          125

_cursor_plan_enabled               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_buffers                  254080

_db_block_cache_clone              FALSE
_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_granule_interval             10
_db_block_hash_buckets                 508171
_db_block_hash_latches                 2048
_db_block_hi_priority_batch_size       0
_db_block_lru_latches                  32
_db_block_max_cr_dba                   6
_db_block_max_dirty_target             0
_db_block_max_scan_pct                 40

_db_block_med_priority_batch_size      0
_db_block_numa                         1
_db_block_prefetch_limit               0
_db_block_prefetch_quota               10
_db_block_trace_protect                FALSE
_db_cache_advice_batch_size            128
_db_cache_advice_sample_factor         4
_db_file_direct_io_count               1048576
_db_file_noncontig_mblock_read_count   11

_db_handles                            10000
_db_handles_cached                     5
_db_large_dirty_queue                  25

_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_percent_hot_default                50
_db_percent_hot_keep                   0
_db_percent_hot_recycle                0
_db_writer_chunk_writes                0
_db_writer_histogram_statistics        FALSE
_db_writer_max_writes                  0
_db_writer_scan_depth_pct              25

_dbg_proc_startup                      FALSE
_dbwr_async_io                         TRUE
_dbwr_scan_interval                    10
_dbwr_tracing                          0
_default_non_equality_sel_check        TRUE

_defer_multiple_waiters                TRUE
_diag_daemon                                 TRUE
_disable_file_locks                          FALSE
_disable_incremental_checkpoints             FALSE

_disable_kcbhxor_osd                         FALSE
_disable_latch_free_SCN_writes_via_32cas     FALSE

_disable_latch_free_SCN_writes_via_64cas     FALSE

_disable_logging                             FALSE
_disable_multiple_block_sizes                FALSE

_disable_odm                                 FALSE
_disable_recoverable_recovery                FALSE
_disable_savepoint_reset                     FALSE
_disable_sun_rsm                             TRUE
_disable_system_state                        4294967294
_discrete_transactions_enabled               FALSE
_dispatcher_rate_scale
_dispatcher_rate_ttl
_distributed_recovery_connection_hold_time   200

_dlm_send_timeout                            30000
_dlmtrace
_domain_index_batch_size                     2000

_domain_index_dml_batch_size                 200

_dss_cache_flush                             FALSE
_dump_MTTR_to_trace                          FALSE

_dump_interval_limit                         120
_dump_max_limit                              5
_dump_system_state_scope                     local

_dump_trace_scope                            global
_dynamic_rls_policies                        TRUE
_dynamic_stats_threshold                     30

_eliminate_common_subexpr                    TRUE
_enable_NUMA_optimization                    TRUE
_enable_block_level_transaction_recovery     TRUE
_enable_cscn_caching                         FALSE
_enable_default_affinity                     0
_enable_fast_ref_after_mv_tbs                FALSE
_enable_kgh_policy                           FALSE
_enable_list_io                              FALSE
_enable_multitable_sampling           FALSE
_enable_reliable_latch_waits          TRUE
_enable_type_dep_selectivity          TRUE
_enqueue_debug_multi_instance         FALSE
_enqueue_hash                         4445
_enqueue_hash_chain_latches           8
_enqueue_locks                        27198
_explain_rewrite_mode                 FALSE

_fairness_threshold                   4

_fast_full_scan_enabled               TRUE
_fifth_spare_parameter
_first_spare_parameter
_force_datefold_trunc                 FALSE
_force_temptables_for_gsets           FALSE

_fourth_spare_parameter
_full_pwise_join_enabled              TRUE
_gby_onekey_enabled                   TRUE
_gc_affinity_limit                    50
_gc_affinity_time                     0
_gc_check_bscn                        TRUE
_gc_defer_time                        3

_gc_integrity_checks                  TRUE
_gc_latches                           16
_gcs_fast_reconfig                    TRUE
_gcs_latches                          128

_gcs_resources
_gcs_shadow_locks
_generalized_pruning_enabled          TRUE

_groupby_nopushdown_cut_ratio         3
_groupby_orderby_combine              5000
_gs_anti_semi_join_allowed            TRUE
_hard_protection                      FALSE
_hash_multiblock_io_count             0
_high_server_threshold                0
_idl_conventional_index_maintenance   TRUE

_ignore_desc_in_index                 FALSE

_improved_outerjoin_card              TRUE
_improved_row_length_enabled          TRUE
_imr_active                           TRUE
_imr_max_reconfig_delay               300
_imr_splitbrain_res_wait              600

_index_join_enabled                   TRUE
_index_prefetch_factor                100
_init_sql_file                        ?/rdbms/admin/sql.bsq

_initial_file_size                    50

_insert_enable_hwm_brokered           TRUE

_inst_locking_period                  5

_instance_type                        RDBMS
_interconnect_checksum                TRUE
_intrapart_pdml_enabled               TRUE
_intrapart_pdml_randomlocal_enabled   TRUE

_io_slaves_disabled                   FALSE
_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

_kcl_commit                           TRUE
_kcl_conservative_log_flush           FALSE

_kcl_debug                            TRUE
_kcl_index_split                      TRUE

_kcl_name_table_latches               64
_kcl_recovery_read_batch              8
_kcl_undo_grouping                    32
_kcl_undo_locks                       128
_kcl_use_cr                           TRUE
_kdbl_enable_post_allocation          FALSE
_keep_recovery_buffers                FALSE
_keep_remote_column_size              FALSE
_kghdsidx_count                       2
_kgl_bucket_count                     9
_kgl_latch_count                      0
_kgl_multi_instance_invalidation      TRUE

_kgl_multi_instance_lock              TRUE
_kgl_multi_instance_pin        TRUE
_kglsim_maxmem_percent         5

_kkfi_trace                    FALSE
_kolfuseslf                    FALSE
_ksdxw_cini_flg                0
_ksdxw_nbufs                   1000
_ksdxw_num_pgw                 10
_ksdxw_num_sgw                 10

_ksdxw_stack_depth             4

_ksi_trace
_ksmg_granule_locking_status   1
_ksmg_granule_size             16777216
_ksu_diag_kill_time            5

_ktc_latches                   0
_ktu_latches                   0
_large_pool_min_alloc          3

_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      998
_ldr_io_size                   262144
_left_nested_loops_random      TRUE

_lgwr_async_io                 FALSE
_lgwr_delay_write              FALSE
_lgwr_io_slaves                0
_lgwr_max_ns_wt                5

_lgwr_ns_nl_max                1000
_lgwr_ns_nl_min                500
_lgwr_ns_sim_err               0
_library_cache_advice          TRUE
_like_with_bind_as_equality   FALSE

_lm_activate_lms_threshold    100
_lm_cache_lvl0_cleanup        0
_lm_cache_res_cleanup         25

_lm_cache_res_type
_lm_dd_interval               60
_lm_direct_sends              all
_lm_drm_window                32
_lm_dynamic_lms               FALSE
_lm_dynamic_load              TRUE
_lm_dynamic_remastering       FALSE
_lm_enq_lock_freelist
_lm_enq_rcfg                  TRUE
_lm_enqeue_freelist           3
_lm_file_affinity

_lm_global_posts              FALSE
_lm_lmd_waittime              4
_lm_lms                       0

_lm_lms_waittime              8
_lm_locks                     12000

_lm_master_weight             1
_lm_max_lms                   0

_lm_min_lms                   0

_lm_msg_batch_size            2048
_lm_msg_cache_thresholds
_lm_msg_cleanup_interval      3000
_lm_node_join_opt             FALSE

_lm_non_fault_tolerant        FALSE
_lm_num_pcmhv_latches         0

_lm_proc_freeze_timeout       300
_lm_process_batching          TRUE
_lm_procs                     127

_lm_rcfg_timeout              180000
_lm_rcv_buffer_size           32768
_lm_res_hash_bucket           0
_lm_res_part                  1289
_lm_ress                               6000

_lm_send_buffers                       10000
_lm_send_queue_batching                TRUE
_lm_send_queue_length                  5000
_lm_share_lock_opt                     FALSE
_lm_sq_batch_factor                    2
_lm_sync_timeout

_lm_ticket_active_sendback
_lm_tickets                            1000
_lm_tx_delta                           16
_lm_validate_resource_type             FALSE
_lm_xids                               139

_load_without_compile                  NONE

_local_communication_costing_enabled   TRUE
_local_communication_ratio             50

_lock_sga_areas                        0

_log_archive_buffer_size               2048
_log_archive_buffers                   4
_log_archive_callout
_log_archive_delta_sync_wait           0

_log_archive_net_timeout               0

_log_blocks_during_backup              TRUE
_log_buffers_corrupt                   FALSE
_log_buffers_debug                     FALSE
_log_checkpoint_recovery_check         0
_log_committime_block_cleanout         FALSE
_log_debug_multi_instance              FALSE
_log_io_size                           0

_log_simultaneous_copies               16

_log_space_errors                      TRUE
_log_switch_timeout                    0

_low_server_threshold                  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_exponential_sleep                   0
_max_sleep_holding_latch                 4
_messages                                4000

_minimal_stats_aggregation               TRUE

_minimum_giga_scn                        0
_multi_join_key_table_lookup             TRUE

_mv_refresh_delta_fraction               10
_mv_refresh_eut                          TRUE

_mv_refresh_new_setup_disabled           FALSE

_mv_refresh_selections                   TRUE

_mv_refresh_use_stats                    TRUE
_nchar_imp_cnv                           TRUE

_ncmb_readahead_enabled                  0
_ncmb_readahead_tracing                  0
_nested_loop_fudge                       100
_nested_mav_fast_oncommit_enabled        FALSE
_new_initial_join_orders                 TRUE

_new_sort_cost_estimate                  TRUE
_no_objects                              FALSE
_no_or_expansion                         FALSE
_ns_max_flush_wt                         1

_num_longop_child_latches                8
_number_cached_attributes                10

_object_statistics                       TRUE
_offline_rollback_segments
_ogms_home
_olap_aggregate_buffer_size              1048576
_olap_aggregate_child_fragment_size      32
_olap_aggregate_child_max_size           32768
_olap_aggregate_flags                    0
_olap_aggregate_function_cache_enabled   TRUE
_olap_aggregate_function_merge_threshold   32768
_olap_aggregate_max_thread_tuples          5000
_olap_aggregate_min_buffer_size            1024
_olap_aggregate_min_thread_status          64

_olap_aggregate_multipath_hier             FALSE
_olap_aggregate_statlen_thresh             1024
_olap_aggregate_store_probability          100
_olap_aggregate_work_per_thread            1024
_olap_aggregate_worklist_max               5000
_olap_allocate_errorlog_format             %8p %8y %8z %e (%n)
_olap_allocate_errorlog_header             Dim Source Basis % -8d %-8s
                                           %-8b Description -------- --------
                                           ------ -- -----------
_olap_continuous_trace_file                FALSE

_olap_dimsave_restore_cache_values         TRUE
_olap_eif_export_lob_size                  2147483647
_olap_object_hash_class                    2
_olap_parallel_update_threshold            1000
_olap_poutlog_echo_to_eventlog             FALSE
_olap_sort_buffer_size                     65536
_olap_statbool_corebits                    20000000
_olap_statbool_threshold                   8100
_old_connect_by_enabled                    FALSE
_omf                                       enabled
_oneside_colstat_for_equijoins             TRUE

_open_files_limit                          4294967294

_optim_adjust_for_part_skews               TRUE
_optim_enhance_nnull_detection             TRUE
_optim_new_default_join_sel                TRUE

_optim_peek_user_binds                     TRUE
_optimizer_adjust_for_nulls                TRUE
_optimizer_choose_permutation              0

_optimizer_cost_model                      CHOOSE
_optimizer_degree                          0

_optimizer_dyn_smp_blks                    32
_optimizer_join_sel_sanity_check           FALSE

_optimizer_mode_force                      TRUE
_optimizer_new_join_card_computation   TRUE

_optimizer_percent_parallel            101
_optimizer_search_limit                5
_optimizer_skip_scan_enabled           TRUE
_optimizer_sortmerge_join_enabled      TRUE
_optimizer_system_stats_usage          0
_optimizer_undo_changes                FALSE
_optimizer_undo_cost_change            9.2.0
_or_expand_nvl_predicate               TRUE

_oracle_trace_events
_oracle_trace_facility_version
_ordered_nested_loop                   TRUE
_ordered_semijoin                      TRUE
_parallel_adaptive_max_users           1

_parallel_broadcast_enabled            TRUE

_parallel_default_max_instances        1

_parallel_execution_message_align      FALSE
_parallel_fake_class_pct               0
_parallel_load_bal_unit                0
_parallel_load_balancing               TRUE
_parallel_min_message_pool             3718656

_parallel_recovery_stopat              32767
_parallel_server_idle_time             5
_parallel_server_sleep_time            10

_parallel_txn_global                   FALSE
_parallelism_cost_fudge_factor         350
_partial_pwise_join_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

_pga_max_size                          209715200

_ping_level                            4
_plsql_conditional_compilation         FALSE
_plsql_dump_buffer_events

_pmon_load_constants             300,192,64,3,10,10,0
_pre_rewrite_push_pred           TRUE
_precompute_gid_values           TRUE

_pred_move_around                TRUE
_predicate_elimination_enabled   TRUE
_project_view_columns            TRUE

_push_join_predicate             TRUE
_push_join_union_view            TRUE
_px_async_getgranule             FALSE
_px_broadcast_fudge_factor       100
_px_dynamic_opt                  TRUE

_px_dynamic_sample_size          50

_px_granule_size                 100000
_px_index_sampling               200

_px_kxib_tracing                 0
_px_load_publish_interval        200

_px_max_granules_per_slave       100

_px_min_granules_per_slave       13

_px_no_stealing                  FALSE

_px_trace                        none
_query_cost_rewrite              TRUE

_query_rewrite_1                 TRUE

_query_rewrite_2                 TRUE

_query_rewrite_drj               TRUE
_query_rewrite_expression        TRUE
_query_rewrite_fpc               TRUE
_query_rewrite_fudge             90
_query_rewrite_jgmigrate         TRUE
_query_rewrite_maxdisjunct       257
_query_rewrite_or_error          FALSE

_query_rewrite_vop_cleanup       TRUE
_realfree_heap_free_threshold         4194303
_realfree_heap_max_size               32768
_realfree_heap_mode                   0
_recoverable_recovery_batch_percent   50

_recovery_asserts                     FALSE

_recovery_claim_batch_size            10

_recovery_percentage                  50
_release_insert_threshold             5

_reliable_block_sends                 FALSE

_reuse_index_loop                     5

_rollback_segment_count               0
_rollback_segment_initial             1
_row_cache_cursors                    10

_row_cr                               FALSE
_rowsource_execution_statistics       FALSE

_scn_scheme
_second_spare_parameter
_send_ast_to_foreground               TRUE
_send_close_with_block                TRUE

_send_requests_to_PI                  TRUE
_serial_direct_read                   FALSE
_session_idle_bit_latches             0

_seventh_spare_parameter
_shared_pool_reserved_min_alloc       4400

_shared_pool_reserved_pct             5

_shrunk_aggs_disable_threshold        60

_shrunk_aggs_enabled                  TRUE

_side_channel_batch_size              100

_side_channel_batch_timeout           5

_single_process                       FALSE
_sixth_spare_parameter
_skip_assume_msg                   TRUE

_slave_mapping_enabled             TRUE
_slave_mapping_group_size          0

_small_table_threshold             5081
_smm_advice_enabled                TRUE
_smm_advice_log_size               0

_smm_auto_cost_enabled             FALSE
_smm_auto_max_io_size              248

_smm_auto_min_io_size              56

_smm_bound                         0

_smm_control                       0
_smm_max_size                      0
_smm_min_size                      128
_smm_px_max_size                   0
_smm_trace                         0
_smon_consume_post                 FALSE

_smon_internal_errlimit            100
_smu_debug_mode                    0

_smu_error_simulation_site         0
_smu_error_simulation_type         0
_sort_elimination_cost_ratio       0

_sort_multiblock_read_count        2
_sort_space_for_write_buffers      1

_sortmerge_inequality_join_off     FALSE
_spin_count                        2000
_sql_connect_capability_override   0
_sql_connect_capability_table
_sqlexec_progression_cost          1000

_subquery_pruning_cost_factor      20
_subquery_pruning_enabled          TRUE

_subquery_pruning_mv_enabled       FALSE

_subquery_pruning_reduction        50
_system_index_caching              0
_system_trig_enabled               TRUE
_table_lookup_prefetch_size        40
_table_lookup_prefetch_thresh      2
_table_scan_cost_plus_one          TRUE

_temp_tran_block_threshold         100

_temp_tran_cache                   TRUE

_test_ksusigskip                   5
_test_param_1                      25
_test_param_2
_test_param_3
_test_param_4
_test_param_5                      25
_test_param_6                      0
_third_spare_parameter
_tq_dump_period                    0
_trace_archive                     FALSE
_trace_buffer_flushes              FALSE
_trace_buffer_gets                 FALSE
_trace_buffer_wait_timeouts        0
_trace_buffers                     ALL:256
_trace_cr_buffer_creates           FALSE

_trace_events
_trace_file_size                   65536

_trace_files_public                TRUE
_trace_flush_processes             ALL
_trace_instance_termination        FALSE
_trace_multi_block_reads           FALSE

_trace_options                     text,multiple
_trace_pin_time                    0
_trace_processes                   ALL
_transaction_recovery_servers      0

_tts_allow_nchar_mismatch          FALSE

_two_pass                          TRUE
_two_pass_reverse_polish_enabled   TRUE

_union_rewrite_for_gs              CHOOSE

_unnest_notexists_sq               SINGLE

_unnest_subquery                   TRUE
_use_column_stats_for_function               TRUE

_use_ism                                     TRUE
_use_new_explain_plan                        FALSE
_use_nosegment_indexes                       FALSE
_use_realfree_heap                           FALSE
_use_seq_process_cache                       TRUE
_use_vector_post                             TRUE
_verify_undo_quota                           FALSE
_wait_for_sync                               TRUE
_walk_insert_threshold                       0

_watchpoint_on                               FALSE
_write_clones                                3
_xsolapi_cursor_max_rows_to_cache_per_req    15000
_xsolapi_cursor_max_time_for_partial_cache   5000

_xsolapi_cursor_use_row_cache                TRUE
_xsolapi_debug_output
_xsolapi_dimension_group_creation            OVERFETCH
_xsolapi_fetch_type                          PARTIAL
_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_hints
_xsolapi_sql_measure_hints
_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
_yield_check_interval                        100000
Description
bitvec to specify dumps prior to 4031 error
Set of nodes that this instance should run on
aggregate size in bytes of NUMA pool
Use Large Pool as source of PX buffers
if TRUE, abort recovery on join reconfigurati ons
if TRUE optimize dlm reconfiguration for acti ve/standby
OPS
Adaptive Direct Read
enable/disable adaptive fetch in parallel gro up by
If TRUE, we will adjust the SQL/PLUS output
enable/disable affinity at run time
Number of aiowait timeouts before error is re ported

treat all dblinks as shared
should files be examined in creation order du ring
allocation
interval at which successful search in L1 sho uld be
updated
Allow error simulation for testing
allow read-only open even if database is corr upt
allow resetlogs even if it will cause corrupt ion
Finish terminal recovery even if it may cause corruption

always use this method for anti-join when pos sible

always use this method for semi-join when pos sible

always favor use of star transformation
enable app ctx versioning
scan limit for Time Managers to clean up IOT
ARCH I/O slaves
if TRUE, issue recovery claims asynchronously (DFS)

if TRUE, issue recovery reads asynchronously (DFS)
unauth user processes slack
if TRUE, do not prepare a buffer when the mas ter is local
(DFS)
enable the use of bitmap plans for tables w. only B-tree
indexes
BACKUP Disk I/O slaves
memory to reserve from the large pool
controls extensions to partition pruning for general
predicates
buffer busy wait time in centiseconds
how many blocks should we allocate per free l ist on
advancing HW
if TRUE, generate a BWR for a flushed PI (DFS )
CGS send timeout value
perform block check after checksum if both ar e turned
on
no. of undo entries to apply per transaction cleanup

close cursors cached by PL/SQL at each commit
Collect Statistics v$undostat
turn off predicate-only column elimination
column usage tracking
Database will be compatible unless crash or m edia
recovery is ne
enable complex view merging
control file enqueue timeout in seconds
corrupted undo segment list
enables costing of equality semi-join
current number of cpu's for this instance
divisor for converting CPU cost to I/O cost
if TRUE, grant lock for CR requests when bloc k is in global
role
if TRUE, grant lock for CR using 3way ping in local role

if TRUE, flush redo log before serving a CR b uffer (DFS)

additional number of buffers a cursor can pin at once

enable collection and display of cursor plans
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 r
eplacement list
Touch count set when buffer moved to head of
replacement list
Touch count which sends a buffer to head of r
eplacement list
Always perform block check and checksum for S ystem
tablespace
Number of database blocks cached in memory: h idden
parameter
Always clone data blocks on get (for debuggin g)
number of unmapped buffers (for tracking swap calls on
blocks)
protect database blocks (true only when debug ging)

protect database blocks (for strictly interna l use only)
Check more and dump block before image for de bugging

number of granules to process
Number of database block hash buckets
Number of database block hash latches
Fraction of writes for high priority reasons
number of lru latches
Maximum Allowed Number of CR buffers per dba
Upper bound on modified buffers/recovery read s
Percentage of buffers to inspect when looking for free

Fraction of writes for medium priority reason s
Number of NUMA nodes
Prefetch limit in blocks
Prefetch quota as a percent of cache size
trace buffer protect calls
cache advisory simulation batch size
cache advisory sampling factor
Sequential I/O buf size
number of noncontiguous db blocks to be prefe tched

System-wide simultaneous buffer operations
Buffer handles cached each process
Number of buffers which force dirty queue to be written

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
Percent of default buffer pool considered hot
Percent of keep buffer pool considered hot
Percent of recycle buffer pool considered hot
Number of writes DBWR should wait for
maintain dbwr histogram statistics in x$kcbbh s
Max number of outstanding DB Writer IOs
Percentage of LRU buffers for dbwr to scan wh en looking
for dirt
debug process startup
Enable dbwriter asynchronous writes
dbwriter scan interval
Enable dbwriter tracing
sanity check on default selectivity for like/ range
predicate
if TRUE, defer down converts when there were waiters
(DFS)
start DIAG daemon
disable file locks for control, data, redo lo g files
Disable incremental checkpoints for thread re covery

disable kcbh(c)xor OSD functionality
disable latch-free SCN writes using 32-bit co mpare &
swap
disable latch-free SCN writes using 64-bit co mpare &
swap
Disable logging
disable multiple block size support (for debu gging)

disable odm feature
Disable the new recoverable recovery mechanis m
disable the fix for bug 1402161
Disable IPC OSD support for Sun RSMAPI
disable system state dump
enable OLTP mode
scale to display rate statistic (100ths of a second)
time-to-live for rate statistic (100ths of a second)
number of seconds RECO holds outbound connect ions
open
DLM send timeout value
Trace string of lock types(s)
maximum number of rows from one call to domai n index
fetch routi
maximum number of rows for one call to domain index
dml routines
enable full cache flush for parallel executio n
Dump High Availability MTTR infromation to CK PT trace
file
trace dump time interval limit (in seconds)
max number of dump within dump interval
scope of sysstate dump during instance termin ation

scope of trace dump during a process crash
rls policies are dynamic
delay threshold (in seconds) between sending statistics
messages
enables elimination of common sub-expressions
Enable NUMA specific optimizations
enable block level recovery
enable commit SCN caching for all transaction s
to enable default implementation of affinity osds
enable fast refresh after move tablespace
temporary to disable/enable kgh policy
Enable List I/O
enable multitable sampling
Enable reliable latch waits
enable type dependent selectivity estimates
debug enqueue multi instance
enqueue hash table length
enqueue hash chain latches
locks for managed enqueues
allow additional messages to be generated dur ing
explain rewrite
number of times to CR serve before downgradin g lock
(DFS)
enable/disable index fast full scan
fifth spare parameter - string
first spare parameter - integer
force use of trunc for datefolding rewrite
executes concatenation of rollups using temp tables

fourth spare parameter - string
enable full partition-wise join when TRUE
enable use of one comparison of all group by keys
dynamic affinity limit (DFS)
how often in minutes to check affinity (DFS)
if TRUE, check for stale blocks (DFS)
how long to defer down converts for hot buffe rs (DFS)

if TRUE, enable expensive integrity checks (D FS)
number of latches per LMS process (DFS)
if TRUE, enable fast reconfiguration for gcs locks
number of gcs resource hash latches to be all ocated

number of gcs resources to be allocated
number of gcs shadow locks to be allocated
controls extensions to partition pruning for general
predicates
groupby nopushdown cut ratio
groupby/orderby don't combine threshold
enable anti/semi join for the GS query
if TRUE enable H.A.R.D specific format change s
number of blocks hash join will read/write at once
high server thresholds
enable conventional index maintenance for ins ert direct
load
ignore DESC in indexes, sort those columns as cending
anyhow
improved outer-join cardinality calculation
enable the improvements for computing the ave rage
row length
Activate Instance Membership Recovery feature
Maximum Reconfiguration delay (seconds)
Maximum wait for split-brain resolution (seco nds)

enable the use of index joins
index prefetching factor
File containing SQL statements to execute upo n database
creation
Initial size used for file creation when file size not known

during parallel inserts high water marks are brokered

period an instance can retain a newly acquire d level1
bitmap
type of instance to be executed
if TRUE, checksum interconnect blocks (DFS)
Enable intra-partition updates/deletes
Enable intra-partition updates/deletes with r andom local
dist
Do not use I/O slaves
Per attempt IOs picked
IOs issued before completion check
Simulate cluster network failer
Test transparent cluster network failover
simulate multiple cluster networks
Wakeup interval in seconds for job queue co-o rdinator

if TRUE, call kjbcommit (DFS)
if TRUE, conservatively log flush before CR s erving (DFS)

if TRUE, record le history (DFS)
if TRUE, reject pings on blocks in middle of a split (DFS)

number of name table latches (DFS)
recovery read batch size (DFS)
grouping for undo block locks (DFS)
number of locks per undo segment (DFS)
if TRUE, use Fusion CR buffers (DFS)
allocate dbas after populating data buffers
if TRUE, make recovery buffers current (DFS)
remote column size does not get modified
max kghdsidx count
index to the bucket count array
number of library cache latches
whether KGL to support multi-instance invalid ations

whether KGL to support multi-instance locks
whether KGL to support multi-instance pins
max percentage of shared pool size to be used for KGL
advice
trace expression substitution
allow kolf to use slffopen
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 pro cesses

number of PCs to collect in the stack when wa tchpoint is
hit
KSI trace string of lock type(s)
granule locking status
granule size in bytes
number of seconds ksuitm waits before killing diag

number of ktc latches
number of KTU latches
minimum allocation size in bytes for the larg e allocation
pool
period over which an instance can retain an a ctive 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 sta ts
align latch recovery structures
size of write IOs used during a load operatio n
enable random distribution method for left of
nestedloops
LGWR Asynchronous IO 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
Variable to simulate network latency
Variable to simulate errors lgwrns
whether KGL advice should be turned on
treat LIKE predicate with bind as an equality predicate

threshold value to activate an additional lms
how often to cleanup level 0 cache res (in se c)
percentage of cached resources should be clea nup

cache resource: string of lock types(s)
dd time interval in seconds
Processes which will do direct sends
dynamic remastering bucket window size
dynamic lms invocation
dynamic load adjustment
if TRUE enables dynamic remastering
Number of ges enqueue element freelist
if TRUE enables enqueue reconfiguration
Number of enqueue freelist
mapping between file id and master instance n umber

if TRUE deliver global posts to remote nodes
default wait time for lmd
number of background global cache server proc esses to
start
default wait time for lms
number of enqueues configured for cluster dat abase

master resource weight for this instance
max. number of background global cache server
processes
min. number of background global cache server
processes
GES batch message size
GES message buffer caching threshold
GES message buffer cleanup interval time
cluster database node join optimization in re config

disable cluster database fault-tolerance mode
number of latches covering the PCM HV buckets in cgs

reconfiguration: process freeze timeout
GES implicit process batching for IPC message s
number of client processes configured for clu ster
database
Reconfiguration timeout
the size of receive buffer
number of resource hash buckets
number of resource partition configured for g cs
number of resources configured for cluster da tabase

number of cluster database send buffers
GES send queue message batching
GES send queue maximum length
if TRUE enables share lock optimization
GES send queue minimum batching factor
Synchronization timeout for DLM reconfigurati on 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 clus ter
database
Load PL/SQL or Database objects without compi lation

enable local communication costing when TRUE
set the ratio between global and local commun ication
(0..100)
Lock specified areas of the SGA in physical m emory

Size of each archival buffer in log file bloc ks
Number of buffers to allocate for archiving
archival callout
iterative sleep time in centiseconds seconds when
SYNC=PARALLEL
maximum network wait time in seconds when SYN
C=PARALLEL
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
debug redo multi instance code
automatically initiate log write if this many redo blocks in
buf
number of simultaneous copies into redo buffe r(# of
copy latches
should we report space errors to alert log
Maximum number of seconds redos in the curren t log
could span
low server thresholds
direct sends for messages from master (DFS)
refresh materialized views using consistent r ead
snapshot
materialized view MAV refreshes avoid double counting

optimizations during refresh of materialized views

# tables for union all expansion during mater ialized view
refres
max sleep during exponential backoff
max time to sleep while holding a latch
message queue resources - dependent on # proc esses &
# buffers
prohibit stats aggregation at compile/partiti on
maintenance time
Minimum SCN to start with in 2^30 units
TRUE iff multi-join-key table lookup prefetch is enabled

delta mv as fractional percentage of size of mv
refresh materialized views using EUT(partitio n)-based
algorithm
materialized view MV refresh new setup disabl ing

create materialized views with selections and fast refresh

pass cardinality hints to refresh queries
NLS allow Implicit Conversion between CHAR an d NCHAR

enable multi-block readahead for an index sca n
turn on multi-block readahead tracing
nested loop fudge
nested MAV refresh fast on commit allowed
enable initial join orders based on new order ing
heuristics
enables the use of new cost estimate for sort
no object features are used
OR expansion during optimization disabled
Flush wait time for NetServer to flush oustan ding writes

number of child latches for long op array
maximum number of cached attributes per insta nce

enable the object level statistics collection
offline undo segment list
GMS home directory
OLAP Aggregate max buffer size
OLAP Aggregate child fragment size
OLAP Aggregate child list max 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 dimensi ons 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 onc e
OLAP Allocate Errorlog Format
OLAP Allocate Errorlog Header format


Specify TRUE to enable continuous OLAP tracin g -
otherwise only
OLAP Dimsave restores cached dimension values
OLAP EIF Export BLOB size
OLAP Object Hash Table Class
OLAP parallel update threshold in pages
OLAP POutLog copy output to event log (tracef ile)
OLAP Sort Buffer Size
OLAP Status Boolean max incore bits
OLAP Status Boolean CBM threshold
enable/disable old connect by
enable/disable OMF
sanity check on default selectivity for like/ range
predicate
Limit on number of files opened by I/O subsys tem

adjust stats for skews across partitions
TRUE to enable index [fast] full scan more of ten
improves the way default equijoin selectivity are
computed
enable peeking of user binds
adjust selectivity for null values
force the optimizer to use the specified perm utation

optimizer cost model
force the optimizer to use the same degree of parallelism

number of blocks for optimizer dynamic sampli ng
enable/disable sanity check for multi-column join
selectivity
force setting of optimizer mode for user recu rsive SQL
also
compute join cardinality using non-rounded in put values

optimizer percent parallel
optimizer search limit
enable/disable index skip scan
enable/disable sort-merge join method
system statistics usage
undo changes to query optimizer
optimizer undo cost change
enable OR expanded plan for NVL/DECODE predic ate

Oracle TRACE event flags
Oracle TRACE facility version
enable ordered nested loop costing
enable ordered semi-join subquery
maximum number of users running with default DOP

enable broadcasting of small inputs to hash a nd sort
merge joins
default maximum number of instances for paral lel query

Alignment of PX buffers to OS page boundary
fake db-scheduler percent used for testing
number of threads to allocate per instance
parallel execution load balanced slave alloca tion
minimum size of shared pool memory to reserve for pq
servers
stop at -position- to step through SMON
idle time before parallel query server dies
sleep time between dequeue timeouts (in 1/100 ths)

enable parallel_txn hint with updates and del etes
set the parallelism cost fudge factor
enable partial partition-wise join when TRUE
password file enqueue timeout in seconds
materialized view PCT refreshes avoid double counting

control separation of global index maintenanc e for PDML

slaves start on different index when doing in dex maint

slaves start on different partition when doin g index
maint
Maximum size of the PGA memory for one proces s

fusion ping level (DFS)
PL/SQL conditional compilation
conditions upon which the PL/SQL circular buf fer is
dumped
server load balancing constants (S,P,D,I,L,C, M)
push predicates into views before rewrite
precompute gid values and copy them before re turning a
row
enables predicate move-around
allow predicate elimination if set to TRUE
enable projecting out unreferenced columns of a view

enable pushing join predicate inside a view
enable pushing join predicate inside a union view
asynchronous get granule in the slave
set the tq broadcasting fudge factor percenta ge
turn off/on restartable qerpx dynamic optimiz ation

num of samples for restartable qerpx dynamic
optimization
default size of a rowid range granule (in KB)
parallel query sampling for index create (100 000 = 100%)

turn on kxib tracing
interval at which LMON will check whether to publish PX
load
maximum number of rowid range granules to gen erate
per slave
minimum number of rowid range granules to gen erate
per slave
prevent parallel granule stealing in shared n othing
environment
px trace parameter
perform the cost based rewrite with materiali zed views

perform query rewrite before&after or only be fore view
merging
perform query rewrite before&after or only af ter 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 facto r
mv rewrite with jg migration
query rewrite max disjuncts
allow query rewrite, if referenced tables are not dataless

prune frocol chain before rewrite after view- merging
threshold for performing real-free, in Kbytes
minimum max total heap size, in Kbytes
mode flags for real-free heap
Recoverable recovery batch size (percentage o f buffer
cache)
if TRUE, enable expensive recovery sanity che cks (DFS)

number of messages to batch in a recovery cla im
message (DFS)
recovery buffer cache percentage
maximum number of unusable blocks to unlink f rom
freelist
if TRUE, block sends across interconnect are reliable

number of blocks being examine for index bloc k reuse

number of undo segments
starting undo segment number
number of cached cursors for row cache manage ment

enable row cr for all sql
if TRUE, Oracle will collect rowsource level statistics

SCN scheme
second spare parameter - integer
if TRUE, send ast message to foreground
if TRUE, send close with block even with dire ct sends

if TRUE, try to send CR requests to PI buffer s (DFS)
enable direct read in serial
one latch per session or a latch per group of sessions

seventh spare parameter - string list
minimum allocation size in bytes for reserved area of
shared poo
percentage memory of the shared pool allocate d for the
reserved
percentage of exceptions at which to switch t o 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 all the batched s ide channel
message
run without detached processes
sixth spare parameter - string list
if TRUE, skip assume message for consigns at the master

enable slave mapping when TRUE
force the number of slave group in a slave ma pper

threshold level of table size for direct read s
if TRUE, enable v$pga_advice
overwrites default size of the PGA advice wor karea
history log
if TRUE, use the AUTO size policy cost functi ons
Maximum IO size (in KB) used by sort/hash-joi n in auto
mode
Minimum IO size (in KB) used by sort/hash-joi n in auto
mode
overwrites memory manager automatically compu ted
bound
provides controls on the memory manager
maximum work area size in auto mode (serial)
minimum work area size in auto mode
maximum work area size in auto mode (global)
Turn on/off tracing for SQL memory manager
consume any extra posts after completion of t ransaction
recovery
limit of SMON internal errors
<debug-flag> - set debug event for testing SM U
operations
site ID of error simulation in KTU code
error type for error simulation in KTU code
cost ratio for sort eimination under first_ro ws mode

multi-block read count for sort
tenths of sort_area_size devoted to direct wr ite buffers

turns off sort-merge join on inequality
Amount to spin waiting for a latch
SQL Connect Capability Table Override
SQL Connect Capability Table (testing only)
sql execution progression monitoring cost thr eshold

subquery pruning cost factor
enable the use of subquery predicates to perf orm
pruning
enable the use of subquery predicates with MV s to
perform prunin
subquery pruning reduction factor
optimizer percent system index caching
are system triggers enabled
table lookup prefetch vector size
table lookup prefetch threshold
bump estimated full table scan and index ffs cost by one

number of blocks for a dimension before we te mp
transform
determines if temp table is created with cach e 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)
third spare parameter - integer
time period for duping of TQ statistics (s)
start DIAG process
trace buffer flushes if otrace cacheIO event is set
trace kcb buffer gets if otrace cacheIO event is set
trace buffer busy wait timeouts
trace buffer sizes per process
trace cr buffer creates if otrace cacheIO eve nt is set

trace events enabled at startup
maximum size of trace file (in number of trac e records)

Create publicly accessible trace files
trace data archived by DIAG for these process es
trace instance termination actions
trace multi_block reads if otrace cacheIO eve nt is set

trace data flush options
trace how long a current pin is held
enable KST tracing in process
max number of parallel recovery slaves that m ay be used

allow plugging in a tablespace with a differe nt national
charact
enable two-pass thread recovery
uses two-pass reverse polish alg. to generate canonical
forms
expand queries with GSets into UNIONs for rew rite

unnest NOT EXISTS subquery with one or more t ables if
possible
enables unnesting of correlated subqueries
enable the use of column statistics for DDP f unctions

Enable Shared Page Tables - ISM
if TRUE, use the AUTO size policy cost functi ons
use nosegment indexes in explain plan
use real-free based allocator for PGA memory
whether to use process local seq cache
use vector post
TRUE - verify consistency of undo quota stati stics
wait for sync on commit MUST BE ALWAYS TRUE
maximum number of unusable blocks to walk acr oss
freelist
is the watchpointing feature turned on?
write clones flag
OLAP API max rows to cache per request
OLAP API cursor max execute time for partial cache

OLAP API enable cursor caching
OLAP API debug output disposition
OLAP API symmetric overfetch
OLAP API fetch type
OLAP API output Source definitions to trace f ile
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 generic hints
OLAP API measure hints
OLAP API enable optimization
OLAP API prepare statement cache size
OLAP API enable remove unused columns optimiz ations

OLAP API result set cache size
OLAP API enable symmetric predicate for dimen sion
groups
OLAP API top dimension hints
OLAP API top measure hints
OLAP API enable bind variables optimization
interval to check whether actses should yield

								
To top