Oracle FAQ
Your Portal to the Oracle Knowledge Grid
HOME
|
ASK QUESTION
|
ADD INFO
|
SEARCH
|
E-MAIL US
Index
>
ORACLE Server parameters
> Oracle 10.2.0
Oracle 10.2.0 Initialization Parameters:
O7_DICTIONARY_ACCESSIBILITY
active_instance_count
aq_tm_processes
archive_lag_target
asm_diskgroups
asm_diskstring
asm_power_limit
audit_file_dest
audit_sys_operations
audit_syslog_level
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
commit_write
compatible
control_file_record_keep_time
control_files
core_dump_dest
cpu_count
create_bitmap_area_size
create_stored_outlines
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_flashback_retention_target
db_keep_cache_size
db_name
db_recovery_file_dest
db_recovery_file_dest_size
db_recycle_cache_size
db_unique_name
db_writer_processes
dbwr_io_slaves
ddl_wait_for_locks
dg_broker_config_file1
dg_broker_config_file2
dg_broker_start
disk_asynch_io
dispatchers
distributed_lock_timeout
dml_locks
drs_start
event
fal_client
fal_server
fast_start_io_target
fast_start_mttr_target
fast_start_parallel_rollback
file_mapping
fileio_network_adapters
filesystemio_options
fixed_date
gc_files_to_locks
gcs_server_processes
global_context_pool_size
global_names
hash_area_size
hi_shared_memory_address
hs_autoregister
ifile
instance_groups
instance_name
instance_number
instance_type
java_max_sessionspace_size
java_pool_size
java_soft_sessionspace_limit
job_queue_processes
large_pool_size
ldap_directory_access
license_max_sessions
license_max_users
license_sessions_warning
local_listener
lock_name_space
lock_sga
log_archive_config
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_local_first
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
logmnr_max_persistent_sessions
max_commit_propagation_delay
max_dispatchers
max_dump_file_size
max_enabled_roles
max_shared_servers
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_mode
optimizer_secure_view_merging
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
pga_aggregate_target
plsql_ccflags
plsql_code_type
plsql_compiler_flags
plsql_debug
plsql_native_library_dir
plsql_native_library_subdir_count
plsql_optimize_level
plsql_v2_compatibility
plsql_warnings
pre_page_sga
processes
query_rewrite_enabled
query_rewrite_integrity
rdbms_server_dn
read_only_open_delayed
recovery_parallelism
recyclebin
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
resumable_timeout
rollback_segments
serial_reuse
service_names
session_cached_cursors
session_max_open_files
sessions
sga_max_size
sga_target
shadow_core_dump
shared_memory_address
shared_pool_reserved_size
shared_pool_size
shared_server_sessions
shared_servers
skip_unusable_indexes
smtp_out_server
sort_area_retained_size
sort_area_size
spfile
sql92_security
sql_trace
sql_version
sqltune_category
standby_archive_dest
standby_file_management
star_transformation_enabled
statistics_level
streams_pool_size
tape_asynch_io
thread
timed_os_statistics
timed_statistics
trace_enabled
tracefile_identifier
transactions
transactions_per_rollback_segment
undo_management
undo_retention
undo_tablespace
use_indirect_data_buffers
user_dump_dest
utl_file_dir
workarea_size_policy
Oracle 10.2.0 Hidden Parameters:
_4031_dump_bitvec
_4031_dump_interval
_4031_max_dumps
_4031_sga_dump_interval
_4031_sga_max_dumps
_NUMA_instance_mapping
_NUMA_pool_size
_PX_use_large_pool
_abort_recovery_on_join
_accept_versions
_active_standby_fast_reconfiguration
_adaptive_direct_read
_adaptive_fetch_enabled
_add_stale_mv_to_dependency_list
_addm_auto_enable
_addm_skiprules
_addm_version_check
_adjust_literal_replacement
_affinity_on
_aiowait_timeouts
_alert_expiration
_alert_message_cleanup
_alert_message_purge
_alert_post_background
_all_shared_dblinks
_allocate_creation_order
_allocation_update_interval
_allow_commutativity
_allow_error_simulation
_allow_level_without_connect_by
_allow_read_only_corruption
_allow_resetlogs_corruption
_allow_terminal_recovery_corruption
_alternate_iot_leaf_block_split_points
_always_anti_join
_always_semi_join
_always_star_transformation
_app_ctx_vers
_aq_tm_scanlimit
_arch_io_slaves
_array_update_vector_read_enabled
_ash_disk_filter_ratio
_ash_disk_write_enable
_ash_dummy_test_param
_ash_eflush_trigger
_ash_enable
_ash_sample_all
_ash_sampling_interval
_ash_size
_asm_acd_chunks
_asm_allow_only_raw_disks
_asm_allow_resilver_corruption
_asm_ausize
_asm_blksize
_asm_disk_repair_time
_asm_droptimeout
_asm_emulmax
_asm_emultimeout
_asm_kfdpevent
_asm_libraries
_asm_maxio
_asm_stripesize
_asm_stripewidth
_asm_wait_time
_asmlib_test
_asmsid
_assm_default
_async_recovery_claims
_async_recovery_reads
_avoid_prepare
_awr_corrupt_mode
_awr_disabled_flush_tables
_awr_flush_threshold_metrics
_awr_flush_workload_metrics
_awr_mmon_cpuusage
_awr_restrict_mode
_awr_sql_child_limit
_b_tree_bitmap_plans
_backup_disk_io_slaves
_backup_io_pool_size
_backup_kgc_bufsz
_backup_kgc_niters
_backup_kgc_type
_backup_ksfq_bufcnt
_backup_ksfq_bufsz
_backup_max_gap_size
_bct_bitmaps_per_file
_bct_buffer_allocation_max
_bct_buffer_allocation_min_extents
_bct_buffer_allocation_size
_bct_chunk_size
_bct_crash_reserve_size
_bct_file_block_size
_bct_file_extent_size
_bct_fixtab_file
_bct_initial_private_dba_buffer_size
_bct_public_dba_buffer_size
_bitmap_or_improvement_enabled
_block_change_tracking
_blocks_per_cache_server
_bloom_filter_debug
_bloom_filter_enabled
_bt_mmv_query_rewrite_enabled
_buffer_busy_wait_timeout
_bufq_flow_control_thrsh
_bufq_max_msg_sz
_bufq_stop_flow_control
_build_deferred_mv_skipping_mvlog_update
_bump_highwater_mark_count
_bwr_for_flushed_pi
_cache_stats_monitor
_cgs_reconfig_timeout
_cgs_send_timeout
_check_block_after_checksum
_check_ts_threshold
_cleanup_rollback_entries
_close_cached_open_cursors
_cluster_library
_collapse_wait_history
_collect_undo_stats
_column_compression_factor
_column_elimination_off
_column_tracking_level
_compilation_call_heap_extent_size
_complex_view_merging
_controlfile_block_size
_controlfile_enqueue_dump
_controlfile_enqueue_timeout
_controlfile_section_init_size
_controlfile_section_max_expand
_controlfile_update_check
_convert_set_to_join
_coord_message_buffer
_corrupted_rollback_segments
_cost_equality_semi_join
_cpu_to_io
_cr_grant_global_role
_cr_grant_local_role
_cr_server_log_flush
_ctas_hwm_brokered_loads
_cursor_bind_capture_area_size
_cursor_bind_capture_interval
_cursor_cache_frame_bind_memory
_cursor_db_buffers_pinned
_cursor_plan_enabled
_cursor_plan_hash_version
_cursor_plan_unparse_enabled
_cursor_stats_bucket
_cursor_stats_heap
_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_adjcheck
_db_block_adjchk_level
_db_block_align_direct_read
_db_block_cache_clone
_db_block_cache_history
_db_block_cache_history_level
_db_block_cache_num_umap
_db_block_cache_protect
_db_block_cache_protect_internal
_db_block_check_for_debug
_db_block_check_objtyp
_db_block_do_full_mbreads
_db_block_hash_buckets
_db_block_hash_latches
_db_block_hi_priority_batch_size
_db_block_known_clean_pct
_db_block_lru_latches
_db_block_max_cr_dba
_db_block_max_scan_pct
_db_block_med_priority_batch_size
_db_block_numa
_db_block_prefetch_limit
_db_block_prefetch_quota
_db_block_table_scan_buffer_size
_db_block_temp_redo
_db_block_trace_protect
_db_cache_advice_batch_size
_db_cache_advice_sample_factor
_db_cache_crx_check
_db_cache_pre_warm
_db_cache_process_cr_pin_max
_db_change_notification_enable
_db_fast_obj_check
_db_fast_obj_ckpt
_db_fast_obj_truncate
_db_file_direct_io_count
_db_file_exec_read_count
_db_file_format_io_buffers
_db_file_noncontig_mblock_read_count
_db_file_optimizer_read_count
_db_handles
_db_handles_cached
_db_hot_block_tracking
_db_index_block_checking
_db_large_dirty_queue
_db_lost_write_checking
_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_obj_ckpt_ordered
_db_obj_enable_ksr
_db_percent_hot_default
_db_percent_hot_keep
_db_percent_hot_recycle
_db_percpu_create_cachesize
_db_recovery_temporal_file_dest
_db_row_overlap_checking
_db_todefer_cache_create
_db_writer_chunk_writes
_db_writer_coalesce_area_size
_db_writer_coalesce_write_limit
_db_writer_flush_imu
_db_writer_histogram_statistics
_db_writer_max_writes
_db_writer_verify_writes
_dbg_proc_startup
_dbwr_async_io
_dbwr_scan_interval
_dbwr_tracing
_dead_process_scan_interval
_dedicated_server_poll_count
_dedicated_server_post_wait
_dedicated_server_post_wait_call
_default_encrypt_alg
_default_non_equality_sel_check
_delay_index_maintain
__dg_broker_service_names
_diag_daemon
_diag_diagnostics
_dimension_skip_null
_disable_adaptive_shrunk_aggregation
_disable_datalayer_sampling
_disable_duplex_link
_disable_fast_aggregation
_disable_file_locks
_disable_function_based_index
_disable_health_check
_disable_image_check
_disable_incremental_checkpoints
_disable_incremental_recovery_ckpt
_disable_instance_params_check
_disable_interface_checking
_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_recovery_read_skip
_disable_sample_io_optim
_disable_savepoint_reset
_disable_selftune_checkpointing
_disable_streams_pool_auto_tuning
_disable_sun_rsm
_disable_system_state
_disable_txn_alert
_discrete_transactions_enabled
_dispatcher_rate_scale
_dispatcher_rate_ttl
_distinct_view_unnesting
_distributed_recovery_connection_hold_time
_dlm_send_timeout
_dlmtrace
_dm_max_shared_pool_pct
_dml_monitoring_enabled
_domain_index_batch_size
_domain_index_dml_batch_size
_drop_table_granule
_drop_table_optimization_enabled
_ds_iocount_iosize
_dss_cache_flush
_dtree_area_size
_dtree_binning_enabled
_dtree_bintest_id
_dtree_compressbmp_enabled
_dtree_max_surrogates
_dtree_pruning_enabled
_dummy_instance
_dump_common_subexpressions
_dump_connect_by_loop_data
_dump_cursor_heap_sizes
_dump_interval_limit
_dump_max_limit
_dump_qbc_tree
_dump_rcvr_ipc
_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_dml_lock_escalation
_enable_exchange_validation_using_check
_enable_fast_ref_after_mv_tbs
_enable_hash_overflow
_enable_hwm_sync
_enable_kgh_policy
_enable_list_io
_enable_nativenet_tcpip
_enable_refresh_schedule
_enable_reliable_latch_waits
_enable_rlb
_enable_tablespace_alerts
_enable_type_dep_selectivity
_enqueue_debug_multi_instance
_enqueue_hash
_enqueue_hash_chain_latches
_enqueue_locks
_enqueue_resources
_expand_aggregates
_explain_rewrite_mode
_extended_pruning_enabled
_fair_remote_cvt
_fairness_threshold
_fast_dual_enabled
_fast_full_scan_enabled
_fast_start_instance_recovery_target
_fic_algorithm_set
_fic_area_size
_fic_max_length
_fic_min_bmsize
_fic_outofmem_candidates
_fifth_spare_parameter
_filemap_dir
_first_spare_parameter
_flashback_allow_noarchivelog
_flashback_barrier_interval
_flashback_copy_latches
_flashback_fuzzy_barrier
_flashback_generation_buffer_size
_flashback_hint_barrier_percent
_flashback_log_io_error_behavior
_flashback_log_min_size
_flashback_log_size
_flashback_logfile_enqueue_timeout
_flashback_max_log_size
_flashback_max_n_log_per_thread
_flashback_n_log_per_thread
_flashback_standby_barrier_interval
_flashback_verbose_info
_flashback_write_size_qm
_force_datefold_trunc
_force_rewrite_enable
_force_temptables_for_gsets
_fourth_spare_parameter
_full_pwise_join_enabled
_gby_hash_aggregation_enabled
_gby_onekey_enabled
_gc_affinity_limit
_gc_affinity_minimum
_gc_affinity_time
_gc_check_bscn
_gc_coalesce_recovery_reads
_gc_defer_time
_gc_dynamic_affinity_locks
_gc_element_percent
_gc_global_lru
_gc_integrity_checks
_gc_keep_recovery_buffers
_gc_latches
_gc_maximum_bids
_gc_statistics
_gc_undo_affinity
_gc_undo_affinity_locks
_gc_use_cr
_gc_vector_read
_gcs_fast_reconfig
_gcs_latches
_gcs_process_in_recovery
_gcs_resources
_gcs_shadow_locks
_generalized_pruning_enabled
_ges_dd_debug
_ges_diagnostics
_ges_health_check
_groupby_nopushdown_cut_ratio
_groupby_orderby_combine
_gs_anti_semi_join_allowed
_hang_analysis_num_call_stacks
_hang_detection
_hard_protection
_hash_join_enabled
_hash_multiblock_io_count
_high_server_threshold
_hj_bit_filter_threshold
_hwm_sync_threshold
_idl_conventional_index_maintenance
_idxrb_rowincr
_ignore_desc_in_index
_immediate_commit_propagation
_improved_outerjoin_card
_improved_row_length_enabled
_imr_active
_imr_disk_voting_interval
_imr_max_reconfig_delay
_imr_splitbrain_res_wait
_imu_pools
_in_memory_undo
_incremental_recovery_ckpt_min_batch
_index_join_enabled
_index_prefetch_factor
_init_granule_interval
_init_sql_file
_inject_startup_fault
_insert_enable_hwm_brokered
_inst_locking_period
_interconnect_checksum
_intrapart_pdml_enabled
_intrapart_pdml_randomlocal_enabled
_io_shared_pool_size
_io_slaves_disabled
_ior_serialize_fault
_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_undo_grouping
_kcl_undo_locks
_kdbl_enable_post_allocation
_keep_remote_column_size
_kernel_message_network_driver
_kffmap_hash_size
_kffmop_hash_size
_kghdsidx_count
_kgl_bucket_count
_kgl_fixed_extents
_kgl_hash_collision
_kgl_heap_size
_kgl_keep_cache_pct
_kgl_keep_cache_retain_pct
_kgl_large_heap_warning_threshold
_kgl_latch_count
_kgl_multi_instance_invalidation
_kgl_multi_instance_lock
_kgl_multi_instance_pin
_kgl_session_cached_objects
_kgl_time_to_wait_for_locks
_kglsim_maxmem_percent
_kgx_latches
_kill_java_threads_on_eoc
_kkfi_trace
_kks_use_mutex_pin
_kolfuseslf
_kql_subheap_trace
_ksd_test_param
_ksdxdocmd_default_timeout_ms
_ksdxw_cini_flg
_ksdxw_nbufs
_ksdxw_num_pgw
_ksdxw_num_sgw
_ksdxw_stack_depth
_kse_die_timeout
_kse_pc_table_size
_ksfd_verify_write
_ksi_trace
_ksmg_granule_locking_status
_ksmg_granule_size
_ksmg_lock_check_interval
_ksmg_lock_reacquire_count
_ksu_diag_kill_time
_ksuitm_dont_kill_dumper
_ksxp_diagmode
_ksxp_reporting_process
_ksxp_send_timeout
_ktc_debug
_ktc_latches
_ktu_latches
_ku_trace
_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_broadcasts
_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
_lgwr_ta_sim_err
_library_cache_advice
_lightweight_hdrs
_like_with_bind_as_equality
_lm_activate_lms_threshold
_lm_cache_lvl0_cleanup
_lm_cache_res_cleanup
_lm_cache_res_type
_lm_checksum_batch_msg
_lm_contiguous_res_count
_lm_dd_interval
_lm_dd_scan_interval
_lm_drm_max_requests
_lm_drm_window
_lm_drm_xlatch
_lm_dynamic_lms
_lm_dynamic_load
_lm_dynamic_remastering
_lm_enq_lock_freelist
_lm_enq_rcfg
_lm_enqueue_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_num_pt_buckets
_lm_num_pt_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_mode
_lm_send_queue_batching
_lm_send_queue_length
_lm_sendproxy_reserve
_lm_share_lock_opt
_lm_sq_batch_factor
_lm_sq_batch_type
_lm_sq_batch_waittick
_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_avoid_memcpy
_log_archive_buffer_size
_log_archive_buffers
_log_archive_callout
_log_archive_compress_enable
_log_archive_delta_sync_wait
_log_archive_net_timeout
_log_archive_network_redo_size
_log_archive_prot_auto_demote
_log_archive_security_enabled
_log_blocks_during_backup
_log_buffers_corrupt
_log_buffers_debug
_log_checkpoint_recovery_check
_log_committime_block_cleanout
_log_debug_multi_instance
_log_deletion_policy
_log_io_size
_log_parallelism
_log_parallelism_dynamic
_log_parallelism_max
_log_private_mul
_log_private_parallelism
_log_private_parallelism_mul
_log_simultaneous_copies
_log_space_errors
_log_switch_timeout
_longops_enabled
_low_server_threshold
_master_direct_sends
_mav_refresh_consistent_read
_mav_refresh_double_count_prevented
_mav_refresh_opt
_mav_refresh_unionall_tables
_max_arch_lns_wait
_max_exponential_sleep
_max_lns_shutdown_archival_time
_max_protocol_support
_max_rfs_connections
_max_shrink_obj_stats
_max_sleep_holding_latch
_media_recovery_read_batch
_media_recovery_reap_time
_mem_annotation_pr_lev
_mem_annotation_scale
_mem_annotation_sh_lev
_mem_annotation_store
_mem_std_extent_size
_memory_broker_log_stat_entries
_memory_broker_shrink_heaps
_memory_broker_shrink_java_heaps
_memory_broker_shrink_streams_pool
_memory_broker_shrink_timeout
_memory_broker_stat_interval
_memory_management_tracing
_memory_sanity_check
_messages
_minimal_stats_aggregation
_minimum_blocks_to_shrink
_minimum_extents_to_shrink
_minimum_giga_scn
_mirror_redo_buffers
_mmv_query_rewrite_enabled
_multi_join_key_table_lookup
_multiple_instance_recovery
_mv_refresh_ana
_mv_refresh_costing
_mv_refresh_delta_fraction
_mv_refresh_eut
_mv_refresh_force_parallel_query
_mv_refresh_new_setup_disabled
_mv_refresh_rebuild_percentage
_mv_refresh_selections
_mv_refresh_use_stats
_mv_refsched_timeincr
_mv_rolling_inv
_mwin_schedule
_nchar_imp_cnv
_nchar_imp_conv
_ncmb_readahead_enabled
_ncmb_readahead_tracing
_nested_loop_fudge
_nested_mav_fast_oncommit_enabled
_new_initial_join_orders
_new_sort_cost_estimate
_newsort_enabled
_newsort_ordered_pct
_newsort_type
_no_objects
_no_or_expansion
_no_recovery_through_resetlogs
_notify_crs
_ns_max_flush_wt
_ns_max_send_delay
_num_longop_child_latches
_number_cached_attributes
_object_statistics
_offline_rollback_segments
_ogms_home
_olap_aggregate_buffer_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_dbgoutfile_echo_to_eventlog
_olap_dimension_corehash_class
_olap_dimension_corehash_max
_olap_eif_export_lob_size
_olap_lmgen_dim_size
_olap_lmgen_meas_size
_olap_object_hash_class
_olap_page_pool_expand_rate
_olap_page_pool_hi
_olap_page_pool_hit_target
_olap_page_pool_low
_olap_page_pool_pressure
_olap_page_pool_shrink_rate
_olap_parallel_update_small_group
_olap_parallel_update_small_threshold
_olap_parallel_update_threshold
_olap_poutlog_echo_to_eventlog
_olap_sesscache_enabled
_olap_sort_buffer_size
_olap_statbool_corebits
_olap_statbool_threshold
_olap_table_function_statistics
_olap_wrap_errors
_olapi_history_retention
_olapi_iface_object_history
_olapi_iface_object_history_retention
_olapi_iface_operation_history_retention
_olapi_interface_operation_history
_olapi_memory_operation_history
_olapi_memory_operation_history_pause_at_seqno
_olapi_memory_operation_history_retention
_olapi_session_history
_olapi_session_history_retention
_old_connect_by_enabled
_ols_cleanup_task
_omf
_oneside_colstat_for_equijoins
_optim_adjust_for_part_skews
_optim_dict_stats_at_db_cr_upg
_optim_enhance_nnull_detection
_optim_new_default_join_sel
_optim_peek_user_binds
_optimizer_adjust_for_nulls
_optimizer_autostats_job
_optimizer_better_inlist_costing
_optimizer_block_size
_optimizer_cache_stats
_optimizer_cartesian_enabled
_optimizer_cbqt_factor
_optimizer_cbqt_no_size_restriction
_optimizer_ceil_cost
_optimizer_choose_permutation
_optimizer_complex_pred_selectivity
_optimizer_compute_index_stats
_optimizer_correct_sq_selectivity
_optimizer_cost_based_transformation
_optimizer_cost_filter_pred
_optimizer_cost_hjsmj_multimatch
_optimizer_cost_model
_optimizer_degree
_optimizer_dim_subq_join_sel
_optimizer_disable_strans_sanity_checks
_optimizer_dyn_smp_blks
_optimizer_enhanced_filter_push
_optimizer_extended_cursor_sharing
_optimizer_filter_pred_pullup
_optimizer_ignore_hints
_optimizer_invalidation_period
_optimizer_join_elimination_enabled
_optimizer_join_order_control
_optimizer_join_sel_sanity_check
_optimizer_max_permutations
_optimizer_min_cache_blocks
_optimizer_mjc_enabled
_optimizer_mode_force
_optimizer_multiple_cenv
_optimizer_new_join_card_computation
_optimizer_or_expansion
_optimizer_order_by_elimination_enabled
_optimizer_outer_to_anti_enabled
_optimizer_percent_parallel
_optimizer_push_down_distinct
_optimizer_push_pred_cost_based
_optimizer_random_plan
_optimizer_rownum_pred_based_fkr
_optimizer_save_stats
_optimizer_search_limit
_optimizer_self_induced_cache_cost
_optimizer_skip_scan_enabled
_optimizer_sortmerge_join_enabled
_optimizer_squ_bottomup
_optimizer_star_tran_in_with_clause
_optimizer_starplan_enabled
_optimizer_system_stats_usage
_optimizer_trace
_optimizer_transitivity_retain
_optimizer_undo_changes
_optimizer_undo_cost_change
_or_expand_nvl_predicate
_oradbg_pathname
_oradebug_force
_ordered_nested_loop
_ordered_semijoin
_os_sched_high_priority
_other_wait_event_exclusion
_other_wait_threshold
_outline_bitmap_tree
_parallel_adaptive_max_users
_parallel_broadcast_enabled
_parallel_default_max_instances
_parallel_execution_message_align
_parallel_fake_class_pct
_parallel_fixwrite_bucket
_parallel_load_bal_unit
_parallel_load_balancing
_parallel_min_message_pool
_parallel_recovery_stopat
_parallel_replay_msg_limit
_parallel_server_idle_time
_parallel_server_sleep_time
_parallel_slave_acquisition_wait
_parallel_txn_global
_parallelism_cost_fudge_factor
_parameter_table_block_size
_partial_pwise_join_enabled
_partition_view_enabled
_passwordfile_enqueue_timeout
_pct_refresh_double_count_prevented
_pdml_gim_sampling
_pdml_gim_staggered
_pdml_slaves_diff_part
_percent_flashback_buf_partial_full
_pga_large_extent_size
_pga_max_size
_ping_level
_pkt_enable
_pkt_pmon_interval
_pkt_start
_plan_outline_data
_plsql_anon_block_code_type
_plsql_cache_enable
_plsql_dump_buffer_events
_plsql_minimum_cache_hit_percent
_plsql_nvl_optimize
_pmon_load_constants
_pre_rewrite_push_pred
_precompute_gid_values
_pred_move_around
_predicate_elimination_enabled
_prescomm
_print_refresh_schedule
_private_memory_address
_project_view_columns
_projection_pushdown
_projection_pushdown_debug
_push_join_predicate
_push_join_union_view
_push_join_union_view2
_px_async_getgranule
_px_broadcast_fudge_factor
_px_buffer_ttl
_px_compilation_debug
_px_compilation_trace
_px_dynamic_opt
_px_dynamic_sample_size
_px_granule_size
_px_index_sampling
_px_kxib_tracing
_px_load_publish_interval
_px_loc_msg_cost
_px_max_granules_per_slave
_px_min_granules_per_slave
_px_minus_intersect
_px_net_msg_cost
_px_no_granule_sort
_px_no_stealing
_px_nss_planb
_px_proc_constrain
_px_pwg_enabled
_px_rownum_pd
_px_send_timeout
_px_slaves_share_cursors
_px_trace
_px_xtgranule_size
_qa_control
_qa_lrg_type
_query_cost_rewrite
_query_execution_cache_max_size
_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_setopgrw_enable
_query_rewrite_vop_cleanup
_rcfg_parallel_fixwrite
_rcfg_parallel_replay
_rcfg_parallel_verify
_real_time_apply_arch_delay
_real_time_apply_sim
_realfree_heap_max_size
_realfree_heap_mode
_realfree_heap_pagesize_hint
_recoverable_recovery_batch_percent
_recovery_asserts
_recovery_percentage
_recovery_verify_writes
_recursive_imu_transactions
_redo_compatibility_check
_release_insert_threshold
_reliable_block_sends
_remove_aggr_subquery
_resource_manager_always_on
_restore_spfile
_reuse_index_loop
_right_outer_hash_enable
_rman_io_priority
_rollback_segment_count
_rollback_segment_initial
_rollback_stopat
_row_cache_cursors
_row_cr
_row_locking
_rowsource_execution_statistics
_rowsource_statistics_sampfreq
_rowsrc_trace_level
_sample_rows_per_block
_second_spare_parameter
_selfjoin_mv_duplicates
_selftune_checkpoint_write_pct
_selftune_checkpointing_lag
_send_ast_to_foreground
_send_close_with_block
_send_requests_to_pi
_serial_direct_read
_serial_recovery
_serializable
_session_cached_instantiations
_session_context_size
_session_idle_bit_latches
_session_idle_check_interval
_session_kept_cursor_pins
_session_wait_history
_seventh_spare_parameter
_shared_pool_max_size
_shared_pool_reserved_min_alloc
_shared_pool_reserved_pct
_short_stack_timeout_ms
_shrunk_aggs_disable_threshold
_shrunk_aggs_enabled
_side_channel_batch_size
_side_channel_batch_timeout
_simple_view_merging
_simulator_bucket_mindelta
_simulator_internal_bound
_simulator_lru_rebalance_sizthr
_simulator_lru_rebalance_thresh
_simulator_lru_scan_count
_simulator_pin_inval_maxcnt
_simulator_reserved_heap_count
_simulator_reserved_obj_count
_simulator_sampling_factor
_simulator_upper_bound_multiple
_single_process
_sixth_spare_parameter
_skgxp_reaping
_skgxp_udp_ach_reaping_time
_skgxp_udp_hiwat_warn
_skgxp_udp_interface_detection_time_secs
_skgxp_udp_keep_alive_ping_timer_secs
_skgxp_udp_timed_wait_buffering
_skgxp_udp_timed_wait_seconds
_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_freeable_retain
_smm_isort_cap
_smm_max_size
_smm_min_size
_smm_px_max_size
_smm_retain_size
_smm_trace
_smon_internal_errlimit
_smu_debug_mode
_smu_error_simulation_site
_smu_error_simulation_type
_smu_timeouts
_sort_elimination_cost_ratio
_sort_multiblock_read_count
_spin_count
_spr_max_rules
_spr_push_pred_refspr
_spr_use_AW_AS
_spr_use_hash_table
_sql_connect_capability_override
_sql_connect_capability_table
_sql_hash_debug
_sql_model_unfold_forloops
_sqlexec_progression_cost
_sqltune_category_parsed
_sta_control
_stack_guard_level
_static_backgrounds
_stn_trace
_streams_pool_max_size
_subquery_pruning_cost_factor
_subquery_pruning_enabled
_subquery_pruning_mv_enabled
_subquery_pruning_reduction
_swrf_metric_frequent_mode
_swrf_mmon_dbfus
_swrf_mmon_flush
_swrf_mmon_metrics
_swrf_on_disk_enabled
_swrf_test_action
_swrf_test_dbfus
_synonym_repoint_tracing
_sysaux_test_param
_system_index_caching
_system_trig_enabled
_ta_lns_wait_for_arch_log
_table_lookup_prefetch_size
_table_lookup_prefetch_thresh
_table_scan_cost_plus_one
_target_rba_max_lag_percentage
_tdb_debug_mode
_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
_threshold_alerts_enable
_total_large_extent_memory
_tq_dump_period
_trace_archive
_trace_buffer_flushes
_trace_buffer_gets
_trace_buffer_wait_timeouts
_trace_buffer_wrap_timestamp
_trace_buffers
_trace_cr_buffer_creates
_trace_events
_trace_file_size
_trace_files_public
_trace_flush_processes
_trace_multi_block_reads
_trace_navigation_scope
_trace_options
_trace_pin_time
_trace_processes
_transaction_auditing
_transaction_recovery_servers
_truncate_optimization_enabled
_tsm_connect_string
_tsm_disable_auto_cleanup
_tts_allow_charset_mismatch
_two_pass
_two_pass_reverse_polish_enabled
_uga_cga_large_extent_size
_ultrafast_latch_statistics
_undo_autotune
_undo_debug_mode
_undo_debug_usage
_union_rewrite_for_gs
_unnest_subquery
_unused_block_compression
_use_column_stats_for_function
_use_ism
_use_ism_for_pga
_use_nosegment_indexes
_use_realfree_heap
_use_seq_process_cache
_use_vector_post
_validate_flashback_database
_vendor_lib_loc
_verify_flashback_redo
_verify_undo_quota
_very_large_partitioned_table
_wait_for_sync
_walk_insert_threshold
_watchpoint_on
_windowfunc_optimization_settings
_write_clones
_xpl_peeked_binds_log_size
_xpl_trace
_xsolapi_auto_materialization_bound
_xsolapi_auto_materialization_type
_xsolapi_debug_output
_xsolapi_densify_cubes
_xsolapi_dimension_group_creation
_xsolapi_fetch_type
_xsolapi_load_at_process_start
_xsolapi_materialization_rowcache_min_rows_for_use
_xsolapi_materialize_sources
_xsolapi_source_trace
_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
_xsolapi_sql_use_bind_variables
_xt_coverage
_xt_trace
_xtbuffer_size
_xtts_allow_pre10
_xtts_set_platform_info
_yield_check_interval
HOME
|
ASK QUESTION
|
ADD FAQ
|
SEARCH
|
E-MAIL US