Oracle FAQ
Your Portal to the Oracle Knowledge Grid
HOME
|
ASK QUESTION
|
ADD INFO
|
SEARCH
|
E-MAIL US
<a href='http://www.orafaq.com/admin/ads/www/delivery/ck.php?n=af7f91ef&ct0=Insert_Clicktrack_URL_Here' target='_blank'><img src='http://www.orafaq.com/admin/ads/www/delivery/adview.php?&zoneid=1&cb=Insert_Random_Number_Here&n=af7f91ef' border='0' alt='' /></a>
Index
>
ORACLE Server parameters
> Oracle 8.1.7
Oracle 8.1.7 Initialization Parameters:
O7_DICTIONARY_ACCESSIBILITY
active_instance_count
always_anti_join
always_semi_join
aq_tm_processes
audit_file_dest
audit_trail
background_core_dump
background_dump_dest
backup_tape_io_slaves
bitmap_merge_area_size
blank_trimming
buffer_pool_keep
buffer_pool_recycle
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_block_buffers
db_block_checking
db_block_checksum
db_block_lru_latches
db_block_max_dirty_target
db_block_size
db_domain
db_file_direct_io_count
db_file_multiblock_read_count
db_file_name_convert
db_files
db_name
db_writer_processes
dblink_encrypt_login
dbwr_io_slaves
disk_asynch_io
distributed_transactions
dml_locks
enqueue_resources
event
fast_start_io_target
fast_start_parallel_rollback
fixed_date
gc_defer_time
gc_files_to_locks
gc_releasable_locks
gc_rollback_locks
global_names
hash_area_size
hash_join_enabled
hash_multiblock_io_count
hi_shared_memory_address
hpux_sched_noage
hs_autoregister
ifile
instance_groups
instance_name
instance_number
java_max_sessionspace_size
java_pool_size
java_soft_sessionspace_limit
job_queue_interval
job_queue_processes
large_pool_size
license_max_sessions
license_max_users
license_sessions_warning
lm_locks
lm_ress
local_listener
lock_name_space
lock_sga
log_archive_dest
log_archive_dest_1
log_archive_dest_2
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_state_1
log_archive_dest_state_2
log_archive_dest_state_3
log_archive_dest_state_4
log_archive_dest_state_5
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
max_commit_propagation_delay
max_dump_file_size
max_enabled_roles
max_rollback_segments
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_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
open_cursors
open_links
open_links_per_instance
ops_interconnects
optimizer_features_enable
optimizer_index_caching
optimizer_index_cost_adj
optimizer_max_permutations
optimizer_mode
optimizer_percent_parallel
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_broadcast_enabled
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
plsql_v2_compatibility
pre_page_sga
processes
query_rewrite_enabled
query_rewrite_integrity
rdbms_server_dn
read_only_open_delayed
recovery_parallelism
remote_dependencies_mode
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
shadow_core_dump
shared_memory_address
shared_pool_reserved_size
shared_pool_size
sort_area_retained_size
sort_area_size
sort_multiblock_read_count
sql92_security
sql_trace
sql_version
standby_archive_dest
star_transformation_enabled
tape_asynch_io
text_enable
thread
timed_os_statistics
timed_statistics
tracefile_identifier
transaction_auditing
transactions
transactions_per_rollback_segment
use_indirect_data_buffers
user_dump_dest
utl_file_dir
Oracle 8.1.7 Hidden Parameters:
_NUMA_instance_mapping
_NUMA_pool_size
_PX_use_large_pool
_active_standby_fast_reconfiguration
_advanced_dss_features
_affinity_on
_all_shared_dblinks
_allocate_creation_order
_allow_error_simulation
_allow_read_only_corruption
_allow_resetlogs_corruption
_always_star_transformation
_aq_tm_scanlimit
_arch_io_slaves
_async_bsp
_average_dirties_half_life
_b_tree_bitmap_plans
_backup_disk_io_slaves
_backup_io_pool_size
_bsp_log_flush
_bump_highwater_mark_count
_check_block_after_checksum
_cleanup_rollback_entries
_close_cached_open_cursors
_column_elimination_off
_compatible_no_recovery
_complex_view_merging
_controlfile_enqueue_timeout
_corrupt_blocks_on_stuck_recovery
_corrupted_rollback_segments
_cpu_to_io
_cr_server
_cr_server_extn
_cursor_db_buffers_pinned
_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_map
_db_block_cache_protect
_db_block_check_for_debug
_db_block_hash_buckets
_db_block_hash_latches
_db_block_hi_priority_batch_size
_db_block_max_cr_dba
_db_block_max_scan_cnt
_db_block_med_priority_batch_size
_db_block_numa
_db_cache_advice
_db_file_noncontig_mblock_read_count
_db_handles
_db_handles_cached
_db_large_dirty_queue
_db_no_mount_lock
_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
_dbwr_async_io
_dbwr_scan_interval
_dbwr_tracing
_default_non_equality_sel_check
_defer_multiple_waiters
_disable_file_locks
_disable_incremental_checkpoints
_disable_latch_free_SCN_writes_via_32cas
_disable_latch_free_SCN_writes_via_64cas
_disable_logging
_discrete_transactions_enabled
_disk_get_lock
_distributed_lock_timeout
_distributed_recovery_connection_hold_time
_domain_index_batch_size
_domain_index_dml_batch_size
_dss_cache_flush
_dump_MTTR_to_trace
_dynamic_stats_threshold
_eliminate_common_subexpr
_enable_NUMA_optimization
_enable_block_level_transaction_recovery
_enable_cscn_caching
_enable_default_affinity
_enable_list_io
_enable_multitable_sampling
_enable_type_dep_selectivity
_enqueue_debug_multi_instance
_enqueue_hash
_enqueue_hash_chain_latches
_enqueue_locks
_fairness_threshold
_fast_full_scan_enabled
_fifth_spare_parameter
_filesystemio_options
_first_spare_parameter
_fourth_spare_parameter
_freeze_DB_for_fast_instance_recovery
_full_pwise_join_enabled
_gc_bsp_procs
_gc_class_locks
_gc_latches
_gc_lck_procs
_groupby_nopushdown_cut_ratio
_groupby_orderby_combine
_high_server_threshold
_idl_conventional_index_maintenance
_ignore_desc_in_index
_improved_outerjoin_card
_improved_row_length_enabled
_index_join_enabled
_index_prefetch_factor
_init_sql_file
_interconnect_checksum
_io_slaves_disabled
_ioslave_batch_count
_ioslave_issue_count
_ipc_fail_network
_ipc_test_failover
_ipc_test_mult_nets
_kcl_debug
_kgl_bucket_count
_kgl_latch_count
_kgl_multi_instance_invalidation
_kgl_multi_instance_lock
_kgl_multi_instance_pin
_kkfi_trace
_ksi_trace
_large_pool_min_alloc
_latch_miss_stat_sid
_latch_recovery_alignment
_latch_wait_posting
_lazy_freelist_close
_le_lru_scan
_left_nested_loops_random
_lgwr_async_io
_lgwr_io_slaves
_like_with_bind_as_equality
_lm_ast_option
_lm_cache_res_cleanup
_lm_dd_interval
_lm_direct_sends
_lm_dlmd_procs
_lm_domains
_lm_groups
_lm_non_fault_tolerant
_lm_procs
_lm_rcv_buffer_size
_lm_res_cache
_lm_res_cache_interval
_lm_send_buffers
_lm_statistics
_lm_sync_timeout
_lm_ticket_active_sendback
_lm_xids
_lock_sga_areas
_log_archive_buffer_size
_log_archive_buffers
_log_blocks_during_backup
_log_buffers_corrupt
_log_buffers_debug
_log_checkpoint_recovery_check
_log_debug_multi_instance
_log_io_size
_log_simultaneous_copies
_log_space_errors
_low_server_threshold
_max_exponential_sleep
_max_sleep_holding_latch
_max_transaction_branches
_messages
_minimal_stats_aggregation
_minimum_giga_scn
_mts_load_constants
_mts_rate_scale
_mts_rate_ttl
_mv_refresh_selections
_ncmb_readahead_enabled
_ncmb_readahead_tracing
_nested_loop_fudge
_new_connect_by_enabled
_new_initial_join_orders
_no_objects
_no_or_expansion
_number_cached_attributes
_offline_rollback_segments
_ogms_home
_oneside_colstat_for_equijoins
_open_files_limit
_optim_enhance_nnull_detection
_optimizer_adjust_for_nulls
_optimizer_choose_permutation
_optimizer_degree
_optimizer_mode_force
_optimizer_search_limit
_optimizer_undo_changes
_or_expand_nvl_predicate
_oracle_trace_events
_oracle_trace_facility_version
_ordered_nested_loop
_ordered_semijoin
_parallel_adaptive_max_users
_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
_pdml_gim_sampling
_pdml_gim_staggered
_pdml_slaves_diff_part
_plsql_dump_buffer_events
_plsql_load_without_compile
_predicate_elimination_enabled
_project_view_columns
_push_join_predicate
_push_join_union_view
_px_async_getgranule
_px_broadcast_fudge_factor
_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
_query_cost_rewrite
_query_rewrite_2
_query_rewrite_expression
_query_rewrite_fudge
_query_rewrite_vop_cleanup
_release_insert_threshold
_reuse_index_loop
_rollback_segment_count
_rollback_segment_initial
_row_cache_buffer_size
_row_cache_cursors
_row_cache_instance_locks
_scn_scheme
_serial_direct_read
_session_idle_bit_latches
_shared_pool_reserved_min_alloc
_single_process
_small_table_threshold
_sort_elimination_cost_ratio
_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_reduction
_system_trig_enabled
_table_scan_cost_plus_one
_temp_tran_block_threshold
_temp_tran_cache
_test_param_1
_test_param_2
_test_param_3
_third_spare_parameter
_tq_dump_period
_trace_archive_dest
_trace_archive_start
_trace_block_size
_trace_buffer_flushes
_trace_buffer_gets
_trace_buffers_per_process
_trace_cr_buffer_creates
_trace_enabled
_trace_events
_trace_file_size
_trace_files_public
_trace_flushing
_trace_instance_termination
_trace_multi_block_reads
_trace_write_batch_size
_transaction_recovery_servers
_tts_allow_nchar_mismatch
_unnest_subquery
_use_column_stats_for_function
_use_ism
_use_nosegment_indexes
_use_vector_post
_wait_for_sync
_walk_insert_threshold
_write_clones
_yield_check_interval
HOME
|
ASK QUESTION
|
ADD FAQ
|
SEARCH
|
E-MAIL US
