Oracle FAQ
Your Portal to the Oracle Knowledge Grid
HOME
|
ASK QUESTION
|
ADD INFO
|
SEARCH
|
E-MAIL US
Index
>
ORACLE Server parameters
> Oracle 9.2.0
Oracle 9.2.0 Initialization Parameters:
O7_DICTIONARY_ACCESSIBILITY
active_instance_count
aq_tm_processes
archive_lag_target
audit_file_dest
audit_sys_operations
audit_trail
background_core_dump
background_dump_dest
backup_tape_io_slaves
bitmap_merge_area_size
blank_trimming
buffer_pool_keep
buffer_pool_recycle
circuits
cluster_database
cluster_database_instances
cluster_interconnects
commit_point_strength
compatible
control_file_record_keep_time
control_files
core_dump_dest
cpu_count
create_bitmap_area_size
cursor_sharing
cursor_space_for_time
db_16k_cache_size
db_2k_cache_size
db_32k_cache_size
db_4k_cache_size
db_8k_cache_size
db_block_buffers
db_block_checking
db_block_checksum
db_block_size
db_cache_advice
db_cache_size
db_create_file_dest
db_create_online_log_dest_1
db_create_online_log_dest_2
db_create_online_log_dest_3
db_create_online_log_dest_4
db_create_online_log_dest_5
db_domain
db_file_multiblock_read_count
db_file_name_convert
db_files
db_keep_cache_size
db_name
db_recycle_cache_size
db_writer_processes
dblink_encrypt_login
dbwr_io_slaves
dg_broker_config_file1
dg_broker_config_file2
dg_broker_start
disk_asynch_io
dispatchers
distributed_lock_timeout
dml_locks
drs_start
enqueue_resources
event
fal_client
fal_server
fast_start_io_target
fast_start_mttr_target
fast_start_parallel_rollback
file_mapping
filesystemio_options
fixed_date
gc_files_to_locks
global_context_pool_size
global_names
hash_area_size
hash_join_enabled
hi_shared_memory_address
hs_autoregister
ifile
instance_groups
instance_name
instance_number
java_max_sessionspace_size
java_pool_size
java_soft_sessionspace_limit
job_queue_processes
large_pool_size
license_max_sessions
license_max_users
license_sessions_warning
local_listener
lock_name_space
lock_sga
log_archive_dest
log_archive_dest_1
log_archive_dest_10
log_archive_dest_2
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_state_1
log_archive_dest_state_10
log_archive_dest_state_2
log_archive_dest_state_3
log_archive_dest_state_4
log_archive_dest_state_5
log_archive_dest_state_6
log_archive_dest_state_7
log_archive_dest_state_8
log_archive_dest_state_9
log_archive_duplex_dest
log_archive_format
log_archive_max_processes
log_archive_min_succeed_dest
log_archive_start
log_archive_trace
log_buffer
log_checkpoint_interval
log_checkpoint_timeout
log_checkpoints_to_alert
log_file_name_convert
log_parallelism
logmnr_max_persistent_sessions
max_commit_propagation_delay
max_dispatchers
max_dump_file_size
max_enabled_roles
max_rollback_segments
max_shared_servers
mts_circuits
mts_dispatchers
mts_listener_address
mts_max_dispatchers
mts_max_servers
mts_multiple_listeners
mts_servers
mts_service
mts_sessions
nls_calendar
nls_comp
nls_currency
nls_date_format
nls_date_language
nls_dual_currency
nls_iso_currency
nls_language
nls_length_semantics
nls_nchar_conv_excp
nls_numeric_characters
nls_sort
nls_territory
nls_time_format
nls_time_tz_format
nls_timestamp_format
nls_timestamp_tz_format
object_cache_max_size_percent
object_cache_optimal_size
olap_page_pool_size
open_cursors
open_links
open_links_per_instance
optimizer_dynamic_sampling
optimizer_features_enable
optimizer_index_caching
optimizer_index_cost_adj
optimizer_max_permutations
optimizer_mode
oracle_trace_collection_name
oracle_trace_collection_path
oracle_trace_collection_size
oracle_trace_enable
oracle_trace_facility_name
oracle_trace_facility_path
os_authent_prefix
os_roles
parallel_adaptive_multi_user
parallel_automatic_tuning
parallel_execution_message_size
parallel_instance_group
parallel_max_servers
parallel_min_percent
parallel_min_servers
parallel_server
parallel_server_instances
parallel_threads_per_cpu
partition_view_enabled
pga_aggregate_target
plsql_compiler_flags
plsql_native_c_compiler
plsql_native_library_dir
plsql_native_library_subdir_count
plsql_native_linker
plsql_native_make_file_name
plsql_native_make_utility
plsql_v2_compatibility
pre_page_sga
processes
query_rewrite_enabled
query_rewrite_integrity
rdbms_server_dn
read_only_open_delayed
recovery_parallelism
remote_archive_enable
remote_dependencies_mode
remote_listener
remote_login_passwordfile
remote_os_authent
remote_os_roles
replication_dependency_tracking
resource_limit
resource_manager_plan
rollback_segments
row_locking
serial_reuse
serializable
service_names
session_cached_cursors
session_max_open_files
sessions
sga_max_size
shadow_core_dump
shared_memory_address
shared_pool_reserved_size
shared_pool_size
shared_server_sessions
shared_servers
sort_area_retained_size
sort_area_size
spfile
sql92_security
sql_trace
sql_version
standby_archive_dest
standby_file_management
star_transformation_enabled
statistics_level
tape_asynch_io
thread
timed_os_statistics
timed_statistics
trace_enabled
tracefile_identifier
transaction_auditing
transactions
transactions_per_rollback_segment
undo_management
undo_retention
undo_suppress_errors
undo_tablespace
use_indirect_data_buffers
user_dump_dest
utl_file_dir
workarea_size_policy
Oracle 9.2.0 Hidden Parameters:
_NUMA_instance_mapping
_NUMA_pool_size
_PX_use_large_pool
_abort_recovery_on_join
_active_standby_fast_reconfiguration
_adaptive_direct_read
_adaptive_fetch_enabled
_affinity_on
_aiowait_timeouts
_all_shared_dblinks
_allocate_creation_order
_allocation_update_interval
_allow_error_simulation
_allow_read_only_corruption
_allow_resetlogs_corruption
_allow_terminal_recovery_corruption
_always_anti_join
_always_semi_join
_always_star_transformation
_app_ctx_vers
_aq_tm_scanlimit
_arch_io_slaves
_async_recovery_claims
_async_recovery_reads
_attach_count_slack
_avoid_prepare
_b_tree_bitmap_plans
_backup_disk_io_slaves
_backup_io_pool_size
_bitmap_or_improvement_enabled
_buffer_busy_wait_timeout
_bump_highwater_mark_count
_bwr_for_flushed_pi
_cgs_send_timeout
_check_block_after_checksum
_cleanup_rollback_entries
_close_cached_open_cursors
_collect_undo_stats
_column_elimination_off
_column_tracking_level
_compatible_no_recovery
_complex_view_merging
_controlfile_enqueue_timeout
_corrupted_rollback_segments
_cost_equality_semi_join
_cpu_to_io
_cr_grant_global_role
_cr_grant_local_role
_cr_server_log_flush
_cursor_db_buffers_pinned
_cursor_plan_enabled
_db_aging_cool_count
_db_aging_freeze_cr
_db_aging_hot_criteria
_db_aging_stay_count
_db_aging_touch_time
_db_always_check_system_ts
_db_block_cache_clone
_db_block_cache_num_umap
_db_block_cache_protect
_db_block_check_for_debug
_db_block_granule_interval
_db_block_hash_buckets
_db_block_hash_latches
_db_block_hi_priority_batch_size
_db_block_lru_latches
_db_block_max_cr_dba
_db_block_max_dirty_target
_db_block_max_scan_pct
_db_block_med_priority_batch_size
_db_block_numa
_db_block_prefetch_quota
_db_block_trace_protect
_db_cache_advice_batch_size
_db_cache_advice_sample_factor
_db_file_direct_io_count
_db_file_noncontig_mblock_read_count
_db_handles
_db_handles_cached
_db_large_dirty_queue
_db_mttr_advice
_db_mttr_partitions
_db_mttr_sample_factor
_db_mttr_sim_target
_db_mttr_sim_trace_size
_db_mttr_trace_to_alert
_db_percent_hot_default
_db_percent_hot_keep
_db_percent_hot_recycle
_db_writer_chunk_writes
_db_writer_histogram_statistics
_db_writer_max_writes
_db_writer_scan_depth_pct
_dbg_proc_startup
_dbwr_async_io
_dbwr_scan_interval
_dbwr_tracing
_default_non_equality_sel_check
_defer_multiple_waiters
_diag_daemon
_disable_file_locks
_disable_incremental_checkpoints
_disable_kcbhxor_osd
_disable_latch_free_SCN_writes_via_32cas
_disable_latch_free_SCN_writes_via_64cas
_disable_logging
_disable_multiple_block_sizes
_disable_odm
_disable_recoverable_recovery
_disable_savepoint_reset
_disable_sun_rsm
_disable_system_state
_discrete_transactions_enabled
_dispatcher_rate_scale
_dispatcher_rate_ttl
_distributed_recovery_connection_hold_time
_dlm_send_timeout
_dlmtrace
_domain_index_batch_size
_domain_index_dml_batch_size
_dss_cache_flush
_dump_MTTR_to_trace
_dump_interval_limit
_dump_max_limit
_dump_system_state_scope
_dump_trace_scope
_dynamic_rls_policies
_dynamic_stats_threshold
_eliminate_common_subexpr
_enable_NUMA_optimization
_enable_block_level_transaction_recovery
_enable_cscn_caching
_enable_default_affinity
_enable_kgh_policy
_enable_list_io
_enable_multitable_sampling
_enable_type_dep_selectivity
_enqueue_debug_multi_instance
_enqueue_hash
_enqueue_hash_chain_latches
_enqueue_locks
_explain_rewrite_mode
_fairness_threshold
_fast_full_scan_enabled
_fifth_spare_parameter
_first_spare_parameter
_force_datefold_trunc
_force_temptables_for_gsets
_fourth_spare_parameter
_full_pwise_join_enabled
_gby_onekey_enabled
_gc_affinity_limit
_gc_affinity_time
_gc_defer_time
_gc_integrity_checks
_gc_latches
_gcs_fast_reconfig
_gcs_latches
_gcs_resources
_gcs_shadow_locks
_generalized_pruning_enabled
_groupby_nopushdown_cut_ratio
_groupby_orderby_combine
_gs_anti_semi_join_allowed
_hard_protection
_hash_multiblock_io_count
_high_server_threshold
_idl_conventional_index_maintenance
_ignore_desc_in_index
_improved_outerjoin_card
_improved_row_length_enabled
_imr_active
_imr_max_reconfig_delay
_imr_splitbrain_res_wait
_index_join_enabled
_index_prefetch_factor
_init_sql_file
_initial_file_size
_insert_enable_hwm_brokered
_inst_locking_period
_instance_type
_interconnect_checksum
_intrapart_pdml_enabled
_intrapart_pdml_randomlocal_enabled
_io_slaves_disabled
_ioslave_batch_count
_ioslave_issue_count
_ipc_fail_network
_ipc_test_failover
_ipc_test_mult_nets
_job_queue_interval
_kcl_commit
_kcl_conservative_log_flush
_kcl_debug
_kcl_index_split
_kcl_name_table_latches
_kcl_recovery_read_batch
_kcl_undo_grouping
_kcl_undo_locks
_kcl_use_cr
_kdbl_enable_post_allocation
_keep_recovery_buffers
_keep_remote_column_size
_kghdsidx_count
_kgl_bucket_count
_kgl_latch_count
_kgl_multi_instance_invalidation
_kgl_multi_instance_lock
_kgl_multi_instance_pin
_kglsim_maxmem_percent
_kkfi_trace
_kolfuseslf
_ksdxw_cini_flg
_ksdxw_nbufs
_ksdxw_num_pgw
_ksdxw_num_sgw
_ksdxw_stack_depth
_ksi_trace
_ksmg_granule_locking_status
_ksmg_granule_size
_ksu_diag_kill_time
_ktc_latches
_ktu_latches
_large_pool_min_alloc
_last_allocation_period
_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
_latch_recovery_alignment
_ldr_io_size
_left_nested_loops_random
_lgwr_async_io
_lgwr_delay_write
_lgwr_io_slaves
_lgwr_max_ns_wt
_lgwr_ns_nl_max
_lgwr_ns_nl_min
_lgwr_ns_sim_err
_library_cache_advice
_like_with_bind_as_equality
_lm_activate_lms_threshold
_lm_cache_lvl0_cleanup
_lm_cache_res_cleanup
_lm_cache_res_type
_lm_dd_interval
_lm_direct_sends
_lm_drm_window
_lm_dynamic_lms
_lm_dynamic_load
_lm_dynamic_remastering
_lm_enq_lock_freelist
_lm_enq_rcfg
_lm_enqeue_freelist
_lm_file_affinity
_lm_global_posts
_lm_lmd_waittime
_lm_lms
_lm_lms_waittime
_lm_locks
_lm_master_weight
_lm_max_lms
_lm_min_lms
_lm_msg_batch_size
_lm_msg_cache_thresholds
_lm_msg_cleanup_interval
_lm_node_join_opt
_lm_non_fault_tolerant
_lm_num_pcmhv_latches
_lm_proc_freeze_timeout
_lm_process_batching
_lm_procs
_lm_rcfg_timeout
_lm_rcv_buffer_size
_lm_res_hash_bucket
_lm_res_part
_lm_ress
_lm_send_buffers
_lm_send_queue_batching
_lm_send_queue_length
_lm_share_lock_opt
_lm_sq_batch_factor
_lm_sync_timeout
_lm_ticket_active_sendback
_lm_tickets
_lm_tx_delta
_lm_validate_resource_type
_lm_xids
_load_without_compile
_local_communication_costing_enabled
_local_communication_ratio
_lock_sga_areas
_log_archive_buffer_size
_log_archive_buffers
_log_archive_callout
_log_archive_delta_sync_wait
_log_archive_net_timeout
_log_blocks_during_backup
_log_buffers_corrupt
_log_buffers_debug
_log_checkpoint_recovery_check
_log_committime_block_cleanout
_log_debug_multi_instance
_log_io_size
_log_simultaneous_copies
_log_space_errors
_log_switch_timeout
_low_server_threshold
_master_direct_sends
_mav_refresh_consistent_read
_mav_refresh_double_count_prevented
_mav_refresh_opt
_mav_refresh_unionall_tables
_max_exponential_sleep
_max_sleep_holding_latch
_messages
_minimal_stats_aggregation
_minimum_giga_scn
_multi_join_key_table_lookup
_mv_refresh_delta_fraction
_mv_refresh_eut
_mv_refresh_new_setup_disabled
_mv_refresh_selections
_mv_refresh_use_stats
_nchar_imp_cnv
_ncmb_readahead_enabled
_ncmb_readahead_tracing
_nested_loop_fudge
_nested_mav_fast_oncommit_enabled
_new_initial_join_orders
_new_sort_cost_estimate
_no_objects
_no_or_expansion
_ns_max_flush_wt
_num_longop_child_latches
_number_cached_attributes
_object_statistics
_offline_rollback_segments
_ogms_home
_olap_aggregate_buffer_size
_olap_aggregate_child_fragment_size
_olap_aggregate_child_max_size
_olap_aggregate_flags
_olap_aggregate_function_cache_enabled
_olap_aggregate_function_merge_threshold
_olap_aggregate_max_thread_tuples
_olap_aggregate_min_buffer_size
_olap_aggregate_min_thread_status
_olap_aggregate_multipath_hier
_olap_aggregate_statlen_thresh
_olap_aggregate_store_probability
_olap_aggregate_work_per_thread
_olap_aggregate_worklist_max
_olap_allocate_errorlog_format
_olap_allocate_errorlog_header
_olap_continuous_trace_file
_olap_dimsave_restore_cache_values
_olap_eif_export_lob_size
_olap_object_hash_class
_olap_parallel_update_threshold
_olap_poutlog_echo_to_eventlog
_olap_sort_buffer_size
_olap_statbool_threshold
_old_connect_by_enabled
_omf
_oneside_colstat_for_equijoins
_open_files_limit
_optim_adjust_for_part_skews
_optim_enhance_nnull_detection
_optim_new_default_join_sel
_optim_peek_user_binds
_optimizer_adjust_for_nulls
_optimizer_choose_permutation
_optimizer_cost_model
_optimizer_degree
_optimizer_dyn_smp_blks
_optimizer_join_sel_sanity_check
_optimizer_mode_force
_optimizer_new_join_card_computation
_optimizer_percent_parallel
_optimizer_search_limit
_optimizer_skip_scan_enabled
_optimizer_sortmerge_join_enabled
_optimizer_system_stats_usage
_optimizer_undo_changes
_optimizer_undo_cost_change
_or_expand_nvl_predicate
_oracle_trace_events
_oracle_trace_facility_version
_ordered_nested_loop
_ordered_semijoin
_parallel_adaptive_max_users
_parallel_broadcast_enabled
_parallel_default_max_instances
_parallel_execution_message_align
_parallel_fake_class_pct
_parallel_load_bal_unit
_parallel_load_balancing
_parallel_min_message_pool
_parallel_recovery_stopat
_parallel_server_idle_time
_parallel_server_sleep_time
_parallel_txn_global
_parallelism_cost_fudge_factor
_partial_pwise_join_enabled
_passwordfile_enqueue_timeout
_pct_refresh_double_count_prevented
_pdml_gim_sampling
_pdml_gim_staggered
_pdml_slaves_diff_part
_pga_max_size
_ping_level
_plsql_dump_buffer_events
_pmon_load_constants
_pre_rewrite_push_pred
_precompute_gid_values
_pred_move_around
_predicate_elimination_enabled
_project_view_columns
_push_join_predicate
_push_join_union_view
_px_async_getgranule
_px_broadcast_fudge_factor
_px_dynamic_opt
_px_dynamic_sample_size
_px_granule_size
_px_index_sampling
_px_kxib_tracing
_px_load_publish_interval
_px_max_granules_per_slave
_px_min_granules_per_slave
_px_no_stealing
_px_trace
_query_cost_rewrite
_query_rewrite_1
_query_rewrite_2
_query_rewrite_drj
_query_rewrite_expression
_query_rewrite_fpc
_query_rewrite_fudge
_query_rewrite_jgmigrate
_query_rewrite_maxdisjunct
_query_rewrite_or_error
_query_rewrite_vop_cleanup
_realfree_heap_free_threshold
_realfree_heap_max_size
_realfree_heap_mode
_recoverable_recovery_batch_percent
_recovery_asserts
_recovery_claim_batch_size
_recovery_percentage
_release_insert_threshold
_reliable_block_sends
_reuse_index_loop
_rollback_segment_count
_rollback_segment_initial
_row_cache_cursors
_row_cr
_rowsource_execution_statistics
_scn_scheme
_second_spare_parameter
_send_ast_to_foreground
_send_close_with_block
_send_requests_to_PI
_serial_direct_read
_session_idle_bit_latches
_seventh_spare_parameter
_shared_pool_reserved_min_alloc
_shared_pool_reserved_pct
_shrunk_aggs_disable_threshold
_shrunk_aggs_enabled
_side_channel_batch_size
_side_channel_batch_timeout
_single_process
_sixth_spare_parameter
_skip_assume_msg
_slave_mapping_enabled
_slave_mapping_group_size
_small_table_threshold
_smm_advice_enabled
_smm_advice_log_size
_smm_auto_cost_enabled
_smm_auto_max_io_size
_smm_auto_min_io_size
_smm_bound
_smm_control
_smm_max_size
_smm_min_size
_smm_px_max_size
_smm_trace
_smon_consume_post
_smon_internal_errlimit
_smu_debug_mode
_smu_error_simulation_site
_smu_error_simulation_type
_sort_elimination_cost_ratio
_sort_multiblock_read_count
_sort_space_for_write_buffers
_sortmerge_inequality_join_off
_spin_count
_sql_connect_capability_override
_sql_connect_capability_table
_sqlexec_progression_cost
_subquery_pruning_cost_factor
_subquery_pruning_enabled
_subquery_pruning_mv_enabled
_subquery_pruning_reduction
_system_index_caching
_system_trig_enabled
_table_lookup_prefetch_size
_table_lookup_prefetch_thresh
_table_scan_cost_plus_one
_temp_tran_block_threshold
_temp_tran_cache
_test_ksusigskip
_test_param_1
_test_param_2
_test_param_3
_test_param_4
_test_param_5
_test_param_6
_third_spare_parameter
_tq_dump_period
_trace_archive
_trace_buffer_flushes
_trace_buffer_gets
_trace_buffer_wait_timeouts
_trace_buffers
_trace_cr_buffer_creates
_trace_events
_trace_file_size
_trace_files_public
_trace_flush_processes
_trace_instance_termination
_trace_multi_block_reads
_trace_options
_trace_pin_time
_trace_processes
_transaction_recovery_servers
_tts_allow_nchar_mismatch
_two_pass
_two_pass_reverse_polish_enabled
_union_rewrite_for_gs
_unnest_notexists_sq
_unnest_subquery
_use_column_stats_for_function
_use_ism
_use_new_explain_plan
_use_nosegment_indexes
_use_realfree_heap
_use_seq_process_cache
_use_vector_post
_verify_undo_quota
_wait_for_sync
_walk_insert_threshold
_watchpoint_on
_write_clones
_xsolapi_cursor_max_rows_to_cache_per_req
_xsolapi_cursor_max_time_for_partial_cache
_xsolapi_cursor_use_row_cache
_xsolapi_debug_output
_xsolapi_dimension_group_creation
_xsolapi_fetch_type
_xsolapi_sql_all_multi_join_non_base_hints
_xsolapi_sql_all_non_base_hints
_xsolapi_sql_auto_dimension_hints
_xsolapi_sql_auto_measure_hints
_xsolapi_sql_dimension_hints
_xsolapi_sql_hints
_xsolapi_sql_measure_hints
_xsolapi_sql_optimize
_xsolapi_sql_prepare_stmt_cache_size
_xsolapi_sql_remove_columns
_xsolapi_sql_result_set_cache_size
_xsolapi_sql_symmetric_predicate
_xsolapi_sql_top_dimension_hints
_xsolapi_sql_top_measure_hints
_xsolapi_sql_use_bind_variables.
_yield_check_interval
HOME
|
ASK QUESTION
|
ADD FAQ
|
SEARCH
|
E-MAIL US