Database Parameters

Non-Default Parameters

Parameter Name Value Modified
_log_deletion_policy ALL FALSE
audit_file_dest /pcard18/admin/pcard/adump FALSE
background_dump_dest /pcard18/admin/pcard/bdump FALSE
compatible 10.2.0.1.0 FALSE
control_file_record_keep_time 15 FALSE
control_files /pcard02/oradata/pcard/control01.ctl, /pcard03/oradata/pcard/control02.ctl, /pcard04/oradata/pcard/control03.ctl FALSE
core_dump_dest /pcard18/admin/pcard/cdump FALSE
db_block_size 8192 FALSE
db_domain Null value FALSE
db_file_multiblock_read_count 16 FALSE
db_name pcard FALSE
db_recovery_file_dest /dbpcardarch/pcard1 FALSE
db_recovery_file_dest_size 128849018880 FALSE
dispatchers (PROTOCOL=TCP) (SERVICE=pcard) FALSE
fal_client PCARDDR FALSE
fal_server PCARD FALSE
job_queue_processes 10 FALSE
local_listener PCARD_LSNR FALSE
log_archive_config DG_CONFIG=(pcard,pcarddr) FALSE
log_archive_dest_1 LOCATION=/dbpcardarch/pcard1/PCARD/archivelog FALSE
log_archive_dest_2 service=pcarddr async db_unique_name=pcarddr valid_for=(primary_role,online_logfile) FALSE
log_archive_dest_state_2 ENABLE FALSE
open_cursors 2000 FALSE
pga_aggregate_target 1887436800 FALSE
processes 500 FALSE
remote_listener PCARD_LSNR FALSE
remote_login_passwordfile EXCLUSIVE FALSE
sga_max_size 9445572608 FALSE
sga_target 9445572608 FALSE
spfile /dbpcard01/pcard01/oradata/pcard/spfilepcard.ora FALSE
standby_file_management AUTO FALSE
undo_management AUTO FALSE
undo_tablespace UNDOTBS1 FALSE
user_dump_dest /pcard18/admin/pcard/udump FALSE

Back to top

All Parameters

Parameter Name Value Default Modified
O7_DICTIONARY_ACCESSIBILITY FALSE TRUE FALSE
_log_deletion_policy ALL FALSE FALSE
active_instance_count Null value TRUE FALSE
aq_tm_processes 0 TRUE FALSE
archive_lag_target 0 TRUE FALSE
asm_diskgroups Null value TRUE FALSE
asm_diskstring Null value TRUE FALSE
asm_power_limit 1 TRUE FALSE
audit_file_dest /pcard18/admin/pcard/adump FALSE FALSE
audit_sys_operations FALSE TRUE FALSE
audit_syslog_level Null value TRUE FALSE
audit_trail NONE TRUE FALSE
background_core_dump partial TRUE FALSE
background_dump_dest /pcard18/admin/pcard/bdump FALSE FALSE
backup_tape_io_slaves FALSE TRUE FALSE
bitmap_merge_area_size 1048576 TRUE FALSE
blank_trimming FALSE TRUE FALSE
buffer_pool_keep Null value TRUE FALSE
buffer_pool_recycle Null value TRUE FALSE
circuits Null value TRUE FALSE
cluster_database FALSE TRUE FALSE
cluster_database_instances 1 TRUE FALSE
cluster_interconnects Null value TRUE FALSE
commit_point_strength 1 TRUE FALSE
commit_write Null value TRUE FALSE
compatible 10.2.0.1.0 FALSE FALSE
control_file_record_keep_time 15 FALSE FALSE
control_files /pcard02/oradata/pcard/control01.ctl, /pcard03/oradata/pcard/control02.ctl, /pcard04/oradata/pcard/control03.ctl FALSE FALSE
core_dump_dest /pcard18/admin/pcard/cdump FALSE FALSE
cpu_count 16 TRUE FALSE
create_bitmap_area_size 8388608 TRUE FALSE
create_stored_outlines Null value TRUE FALSE
cursor_sharing EXACT TRUE FALSE
cursor_space_for_time FALSE TRUE FALSE
db_16k_cache_size 0 TRUE FALSE
db_2k_cache_size 0 TRUE FALSE
db_32k_cache_size 0 TRUE FALSE
db_4k_cache_size 0 TRUE FALSE
db_8k_cache_size 0 TRUE FALSE
db_block_buffers 0 TRUE FALSE
db_block_checking FALSE TRUE FALSE
db_block_checksum TRUE TRUE FALSE
db_block_size 8192 FALSE FALSE
db_cache_advice ON TRUE FALSE
db_cache_size 0 TRUE FALSE
db_create_file_dest Null value TRUE FALSE
db_create_online_log_dest_1 Null value TRUE FALSE
db_create_online_log_dest_2 Null value TRUE FALSE
db_create_online_log_dest_3 Null value TRUE FALSE
db_create_online_log_dest_4 Null value TRUE FALSE
db_create_online_log_dest_5 Null value TRUE FALSE
db_domain Null value FALSE FALSE
db_file_multiblock_read_count 16 FALSE FALSE
db_file_name_convert Null value TRUE FALSE
db_files 200 TRUE FALSE
db_flashback_retention_target 1440 TRUE FALSE
db_keep_cache_size 0 TRUE FALSE
db_name pcard FALSE FALSE
db_recovery_file_dest /dbpcardarch/pcard1 FALSE FALSE
db_recovery_file_dest_size 128849018880 FALSE FALSE
db_recycle_cache_size 0 TRUE FALSE
db_unique_name pcard TRUE FALSE
db_writer_processes 2 TRUE FALSE
dbwr_io_slaves 0 TRUE FALSE
ddl_wait_for_locks FALSE TRUE FALSE
dg_broker_config_file1 /oracle/app/oracle/product/10.2.0/db_1/dbs/dr1pcard.dat TRUE FALSE
dg_broker_config_file2 /oracle/app/oracle/product/10.2.0/db_1/dbs/dr2pcard.dat TRUE FALSE
dg_broker_start FALSE TRUE FALSE
disk_asynch_io TRUE TRUE FALSE
dispatchers (PROTOCOL=TCP) (SERVICE=pcard) FALSE FALSE
distributed_lock_timeout 60 TRUE FALSE
dml_locks 2440 TRUE FALSE
drs_start FALSE TRUE FALSE
event Null value TRUE FALSE
fal_client PCARDDR FALSE FALSE
fal_server PCARD FALSE FALSE
fast_start_io_target 0 TRUE FALSE
fast_start_mttr_target 0 TRUE FALSE
fast_start_parallel_rollback LOW TRUE FALSE
file_mapping FALSE TRUE FALSE
fileio_network_adapters Null value TRUE FALSE
filesystemio_options none TRUE FALSE
fixed_date Null value TRUE FALSE
gc_files_to_locks Null value TRUE FALSE
gcs_server_processes 0 TRUE FALSE
global_context_pool_size Null value TRUE FALSE
global_names FALSE TRUE FALSE
hash_area_size 131072 TRUE FALSE
hi_shared_memory_address 0 TRUE FALSE
hs_autoregister TRUE TRUE FALSE
ifile Null value TRUE FALSE
instance_groups Null value TRUE FALSE
instance_name pcard TRUE FALSE
instance_number 0 TRUE FALSE
instance_type RDBMS TRUE FALSE
java_max_sessionspace_size 0 TRUE FALSE
java_pool_size 0 TRUE FALSE
java_soft_sessionspace_limit 0 TRUE FALSE
job_queue_processes 10 FALSE FALSE
large_pool_size 0 TRUE FALSE
ldap_directory_access NONE TRUE FALSE
license_max_sessions 0 TRUE FALSE
license_max_users 0 TRUE FALSE
license_sessions_warning 0 TRUE FALSE
local_listener PCARD_LSNR FALSE FALSE
lock_name_space Null value TRUE FALSE
lock_sga FALSE TRUE FALSE
log_archive_config DG_CONFIG=(pcard,pcarddr) FALSE FALSE
log_archive_dest Null value TRUE FALSE
log_archive_dest_1 LOCATION=/dbpcardarch/pcard1/PCARD/archivelog FALSE FALSE
log_archive_dest_10 Null value TRUE FALSE
log_archive_dest_2 service=pcarddr async db_unique_name=pcarddr valid_for=(primary_role,online_logfile) FALSE FALSE
log_archive_dest_3 Null value TRUE FALSE
log_archive_dest_4 Null value TRUE FALSE
log_archive_dest_5 Null value TRUE FALSE
log_archive_dest_6 Null value TRUE FALSE
log_archive_dest_7 Null value TRUE FALSE
log_archive_dest_8 Null value TRUE FALSE
log_archive_dest_9 Null value TRUE FALSE
log_archive_dest_state_1 enable TRUE FALSE
log_archive_dest_state_10 enable TRUE FALSE
log_archive_dest_state_2 ENABLE FALSE FALSE
log_archive_dest_state_3 enable TRUE FALSE
log_archive_dest_state_4 enable TRUE FALSE
log_archive_dest_state_5 enable TRUE FALSE
log_archive_dest_state_6 enable TRUE FALSE
log_archive_dest_state_7 enable TRUE FALSE
log_archive_dest_state_8 enable TRUE FALSE
log_archive_dest_state_9 enable TRUE FALSE
log_archive_duplex_dest Null value TRUE FALSE
log_archive_format %t_%s_%r.dbf TRUE FALSE
log_archive_local_first TRUE TRUE FALSE
log_archive_max_processes 2 TRUE FALSE
log_archive_min_succeed_dest 1 TRUE FALSE
log_archive_start FALSE TRUE FALSE
log_archive_trace 0 TRUE FALSE
log_buffer 14230528 TRUE FALSE
log_checkpoint_interval 0 TRUE FALSE
log_checkpoint_timeout 1800 TRUE FALSE
log_checkpoints_to_alert FALSE TRUE FALSE
log_file_name_convert Null value TRUE FALSE
logmnr_max_persistent_sessions 1 TRUE FALSE
max_commit_propagation_delay 0 TRUE FALSE
max_dispatchers Null value TRUE FALSE
max_dump_file_size UNLIMITED TRUE FALSE
max_enabled_roles 150 TRUE FALSE
max_shared_servers Null value TRUE FALSE
nls_calendar Null value TRUE FALSE
nls_comp Null value TRUE FALSE
nls_currency Null value TRUE FALSE
nls_date_format Null value TRUE FALSE
nls_date_language Null value TRUE FALSE
nls_dual_currency Null value TRUE FALSE
nls_iso_currency Null value TRUE FALSE
nls_language AMERICAN TRUE FALSE
nls_length_semantics BYTE TRUE FALSE
nls_nchar_conv_excp FALSE TRUE FALSE
nls_numeric_characters Null value TRUE FALSE
nls_sort Null value TRUE FALSE
nls_territory AMERICA TRUE FALSE
nls_time_format Null value TRUE FALSE
nls_time_tz_format Null value TRUE FALSE
nls_timestamp_format Null value TRUE FALSE
nls_timestamp_tz_format Null value TRUE FALSE
object_cache_max_size_percent 10 TRUE FALSE
object_cache_optimal_size 102400 TRUE FALSE
olap_page_pool_size 0 TRUE FALSE
open_cursors 2000 FALSE FALSE
open_links 4 TRUE FALSE
open_links_per_instance 4 TRUE FALSE
optimizer_dynamic_sampling 2 TRUE FALSE
optimizer_features_enable 10.2.0.4 TRUE FALSE
optimizer_index_caching 0 TRUE FALSE
optimizer_index_cost_adj 100 TRUE FALSE
optimizer_mode ALL_ROWS TRUE FALSE
optimizer_secure_view_merging TRUE TRUE FALSE
os_authent_prefix ops$ TRUE FALSE
os_roles FALSE TRUE FALSE
parallel_adaptive_multi_user TRUE TRUE FALSE
parallel_automatic_tuning FALSE TRUE FALSE
parallel_execution_message_size 2152 TRUE FALSE
parallel_instance_group Null value TRUE FALSE
parallel_max_servers 320 TRUE FALSE
parallel_min_percent 0 TRUE FALSE
parallel_min_servers 0 TRUE FALSE
parallel_server FALSE TRUE FALSE
parallel_server_instances 1 TRUE FALSE
parallel_threads_per_cpu 2 TRUE FALSE
pga_aggregate_target 1887436800 FALSE FALSE
plsql_ccflags Null value TRUE FALSE
plsql_code_type INTERPRETED TRUE FALSE
plsql_compiler_flags INTERPRETED, NON_DEBUG TRUE FALSE
plsql_debug FALSE TRUE FALSE
plsql_native_library_dir Null value TRUE FALSE
plsql_native_library_subdir_count 0 TRUE FALSE
plsql_optimize_level 2 TRUE FALSE
plsql_v2_compatibility FALSE TRUE FALSE
plsql_warnings DISABLE:ALL TRUE FALSE
pre_11g_enable_capture FALSE TRUE FALSE
pre_page_sga FALSE TRUE FALSE
processes 500 FALSE FALSE
query_rewrite_enabled TRUE TRUE FALSE
query_rewrite_integrity enforced TRUE FALSE
rdbms_server_dn Null value TRUE FALSE
read_only_open_delayed FALSE TRUE FALSE
recovery_parallelism 0 TRUE FALSE
recyclebin on TRUE FALSE
remote_archive_enable true TRUE FALSE
remote_dependencies_mode TIMESTAMP TRUE FALSE
remote_listener PCARD_LSNR FALSE FALSE
remote_login_passwordfile EXCLUSIVE FALSE FALSE
remote_os_authent FALSE TRUE FALSE
remote_os_roles FALSE TRUE FALSE
replication_dependency_tracking TRUE TRUE FALSE
resource_limit FALSE TRUE FALSE
resource_manager_plan Null value TRUE FALSE
resumable_timeout 0 TRUE FALSE
rollback_segments Null value TRUE FALSE
serial_reuse disable TRUE FALSE
service_names pcard TRUE FALSE
session_cached_cursors 20 TRUE FALSE
session_max_open_files 10 TRUE FALSE
sessions 555 TRUE FALSE
sga_max_size 9445572608 FALSE FALSE
sga_target 9445572608 FALSE FALSE
shadow_core_dump partial TRUE FALSE
shared_memory_address 0 TRUE FALSE
shared_pool_reserved_size 74658611 TRUE FALSE
shared_pool_size 0 TRUE FALSE
shared_server_sessions Null value TRUE FALSE
shared_servers 1 TRUE FALSE
skip_unusable_indexes TRUE TRUE FALSE
smtp_out_server Null value TRUE FALSE
sort_area_retained_size 0 TRUE FALSE
sort_area_size 65536 TRUE FALSE
spfile /dbpcard01/pcard01/oradata/pcard/spfilepcard.ora FALSE FALSE
sql92_security FALSE TRUE FALSE
sql_trace FALSE TRUE FALSE
sql_version NATIVE TRUE FALSE
sqltune_category DEFAULT TRUE FALSE
standby_archive_dest ?/dbs/arch TRUE FALSE
standby_file_management AUTO FALSE FALSE
star_transformation_enabled FALSE TRUE FALSE
statistics_level TYPICAL TRUE FALSE
streams_pool_size 0 TRUE FALSE
tape_asynch_io TRUE TRUE FALSE
thread 0 TRUE FALSE
timed_os_statistics 0 TRUE FALSE
timed_statistics TRUE TRUE FALSE
trace_enabled TRUE TRUE FALSE
tracefile_identifier Null value TRUE FALSE
transactions 610 TRUE FALSE
transactions_per_rollback_segment 5 TRUE FALSE
undo_management AUTO FALSE FALSE
undo_retention 900 TRUE FALSE
undo_tablespace UNDOTBS1 FALSE FALSE
use_indirect_data_buffers FALSE TRUE FALSE
user_dump_dest /pcard18/admin/pcard/udump FALSE FALSE
utl_file_dir Null value TRUE FALSE
workarea_size_policy AUTO TRUE FALSE

Back to top

Hidden Parameters

Parameter Name Value Default Description
_4031_dump_bitvec 67194879 TRUE bitvec to specify dumps prior to 4031 error
_4031_dump_interval 300 TRUE Dump 4031 error once for each n-second interval
_4031_max_dumps 100 TRUE Maximum number of 4031 dumps for this process
_4031_sga_dump_interval 3600 TRUE Dump 4031 SGA heapdump error once for each n-second interval
_4031_sga_max_dumps 10 TRUE Maximum number of SGA heapdumps
_NUMA_instance_mapping Not specified TRUE Set of nodes that this instance should run on
_NUMA_pool_size Not specified TRUE aggregate size in bytes of NUMA pool
_PX_use_large_pool FALSE TRUE Use Large Pool as source of PX buffers
__db_cache_size 7784628224 FALSE Actual size of DEFAULT buffer pool for standard block size buffers
__dg_broker_service_names pcard_XPT TRUE service names for broker use
__java_pool_size 16777216 FALSE Actual size in bytes of java pool
__large_pool_size 16777216 FALSE Actual size in bytes of large pool
__shared_pool_size 1577058304 FALSE Actual size in bytes of shared pool
__streams_pool_size 33554432 FALSE Actual size in bytes of streams pool
_abort_recovery_on_join FALSE TRUE if TRUE, abort recovery on join reconfigurations
_accept_versions Null value TRUE List of parameters for rolling operation
_active_standby_fast_reconfiguration TRUE TRUE if TRUE optimize dlm reconfiguration for active/standby OPS
_adaptive_direct_read TRUE TRUE Adaptive Direct Read
_adaptive_fetch_enabled TRUE TRUE enable/disable adaptive fetch in parallel group by
_add_stale_mv_to_dependency_list TRUE TRUE add stale mv to dependency list
_addm_auto_enable TRUE TRUE governs whether ADDM gets run automatically after every AWR snapshot
_addm_skiprules Null value TRUE comma-separated list of ADDM nodes to skip
_addm_version_check TRUE TRUE governs whether ADDM checks the input AWR snapshot version
_adjust_literal_replacement FALSE TRUE If TRUE, we will adjust the SQL/PLUS output
_affinity_on TRUE TRUE enable/disable affinity at run time
_aiowait_timeouts 100 TRUE Number of aiowait timeouts before error is reported
_alert_expiration 604800 TRUE seconds before an alert message is moved to exception queue
_alert_message_cleanup 1 TRUE Enable Alert Message Cleanup
_alert_message_purge 1 TRUE Enable Alert Message Purge
_alert_post_background 1 TRUE Enable Background Alert Posting
_all_shared_dblinks Null value TRUE treat all dblinks as shared
_allocate_creation_order FALSE TRUE should files be examined in creation order during allocation
_allocation_update_interval 3 TRUE interval at which successful search in L1 should be updated
_allow_commutativity TRUE TRUE allow for commutativity of +, * when comparing expressions
_allow_error_simulation FALSE TRUE Allow error simulation for testing
_allow_level_without_connect_by FALSE TRUE allow level without connect by
_allow_read_only_corruption FALSE TRUE allow read-only open even if database is corrupt
_allow_resetlogs_corruption FALSE TRUE allow resetlogs even if it will cause corruption
_allow_terminal_recovery_corruption FALSE TRUE Finish terminal recovery even if it may cause corruption
_alternate_iot_leaf_block_split_points TRUE TRUE enable alternate index-organized table leaf-block split-points
_always_anti_join CHOOSE TRUE always use this method for anti-join when possible
_always_semi_join CHOOSE TRUE always use this method for semi-join when possible
_always_star_transformation FALSE TRUE always favor use of star transformation
_app_ctx_vers FALSE TRUE enable app ctx versioning
_aq_tm_scanlimit 0 TRUE scan limit for Time Managers to clean up IOT
_arch_corrupted_redo_log 0 TRUE Variable to simulate corruption errors during archivals
_arch_io_slaves 0 TRUE ARCH I/O slaves
_array_update_vector_read_enabled FALSE TRUE Enable array update vector read
_ash_disk_filter_ratio 10 TRUE Ratio of the number of in-memory samples to the number of samples actually written to disk
_ash_disk_write_enable TRUE TRUE To enable or disable Active Session History flushing
_ash_dummy_test_param 0 TRUE Oracle internal dummy ASH parameter used ONLY for testing!
_ash_eflush_trigger 66 TRUE The percentage above which if the in-memory ASH is full the emergency flusher will be triggered
_ash_enable TRUE TRUE To enable or disable Active Session sampling and flushing
_ash_sample_all FALSE TRUE To enable or disable sampling every connected session including ones waiting for idle waits
_ash_sampling_interval 1000 TRUE Time interval between two successive Active Session samples in millisecs
_ash_size 1048618 TRUE To set the size of the in-memory Active Session History buffers
_asm_acd_chunks 1 TRUE initial ACD chunks created
_asm_allow_only_raw_disks TRUE TRUE Discovery only raw devices
_asm_allow_resilver_corruption FALSE TRUE Enable disk resilvering for external redundancy
_asm_ausize 1048576 TRUE allocation unit size
_asm_blksize 4096 TRUE metadata block size
_asm_disk_repair_time 14400 TRUE seconds to wait before dropping a failing disk
_asm_droptimeout 60 TRUE timeout before offlined disks get dropped (in 3s ticks)
_asm_emulmax 10000 TRUE max number of concurrent disks to emulate I/O errors
_asm_emultimeout 0 TRUE timeout before emulation begins (in 3s ticks)
_asm_kfdpevent 0 TRUE KFDP event
_asm_libraries ufs TRUE library search order for discovery
_asm_maxio 1048576 TRUE Maximum size of individual I/O request
_asm_skip_resize_check FALSE TRUE skip the checking of the clients for s/w compatibility for resize
_asm_stripesize 131072 TRUE ASM file stripe size
_asm_stripewidth 8 TRUE ASM file stripe width
_asm_wait_time 18 TRUE Max/imum time to wait before asmb exits
_asmlib_test 0 TRUE Osmlib test event
_asmsid asm TRUE ASM instance id
_assm_default TRUE TRUE ASSM default
_async_object_flush TRUE TRUE if FALSE, disable asychronous object flush
_async_recovery_claims TRUE TRUE if TRUE, issue recovery claims asynchronously
_async_recovery_reads TRUE TRUE if TRUE, issue recovery reads asynchronously
_avoid_prepare TRUE TRUE if TRUE, do not prepare a buffer when the master is local
_awr_corrupt_mode FALSE TRUE AWR Corrupt Mode
_awr_disabled_flush_tables Null value TRUE Disable flushing of specified AWR tables
_awr_flush_threshold_metrics FALSE TRUE Enable/Disable Flushing AWR Workload Metrics
_awr_flush_workload_metrics FALSE TRUE Enable/Disable Flushing AWR Workload Metrics
_awr_mmon_cpuusage TRUE TRUE Enable/disable AWR MMON CPU Usage Tracking
_awr_restrict_mode FALSE TRUE AWR Restrict Mode
_awr_sql_child_limit 200 TRUE Setting for AWR SQL Child Limit
_b_tree_bitmap_plans TRUE TRUE enable the use of bitmap plans for tables w. only B-tree indexes
_backup_disk_io_slaves 0 TRUE BACKUP Disk I/O slaves
_backup_io_pool_size 1048576 TRUE memory to reserve from the large pool
_backup_kgc_bufsz 0 TRUE specifies buffer size to be used for kgc compression
_backup_kgc_niters 0 TRUE specifies number of iterations used for kgc compression
_backup_kgc_type 0 TRUE specifies compression type used for kgc compression
_backup_ksfq_bufcnt 0 TRUE number of the ksfq buffers used for backup/restore
_backup_ksfq_bufsz 0 TRUE size of the ksfq buffer used for backup/restore
_backup_max_gap_size 4294967294 TRUE largest gap in an incremental/optimized backup buffer, in bytes
_bct_bitmaps_per_file 8 TRUE number of bitmaps to store for each datafile
_bct_buffer_allocation_max 104857600 TRUE maximum size of all change tracking buffer allocations, in bytes
_bct_buffer_allocation_min_extents 1 TRUE mininum number of extents to allocate per buffer allocation
_bct_buffer_allocation_size 2097152 TRUE size of one change tracking buffer allocation, in bytes
_bct_chunk_size 0 TRUE change tracking datafile chunk size, in bytes
_bct_crash_reserve_size 262144 TRUE change tracking reserved crash recovery SGA space, in bytes
_bct_file_block_size 0 TRUE block size of change tracking file, in bytes
_bct_file_extent_size 0 TRUE extent size of change tracking file, in bytes
_bct_fixtab_file Null value TRUE change tracking file for fixed tables
_bct_initial_private_dba_buffer_size 0 TRUE initial number of entries in the private change tracking dba buffers
_bct_public_dba_buffer_size 0 TRUE total size of all public change tracking dba buffers, in bytes
_bitmap_or_improvement_enabled TRUE TRUE controls extensions to partition pruning for general predicates
_block_change_tracking TRUE TRUE change tracking possible
_blocks_per_cache_server 128 TRUE number of consecutive blocks per global cache server
_bloom_filter_debug 0 TRUE debug level for bloom filtering
_bloom_filter_enabled TRUE TRUE enables or disables bloom filter
_bt_mmv_query_rewrite_enabled TRUE TRUE allow rewrites with multiple MVs and base tables
_buffer_busy_wait_timeout 100 TRUE buffer busy wait time in centiseconds
_buffered_publisher_flow_control_threshold 0 TRUE Flow control threshold for buffered publishers except capture
_bufq_flow_control_thrsh 0 TRUE flow control threshold value
_bufq_max_msg_sz 0 TRUE maximum size of the message allowed in memory
_bufq_stop_flow_control FALSE TRUE Stop enforcing flow control for buffered queues
_build_deferred_mv_skipping_mvlog_update FALSE TRUE DEFERRED MV creation skipping MV log setup update
_bump_highwater_mark_count 0 TRUE how many blocks should we allocate per free list on advancing HWM
_bwr_for_flushed_pi TRUE TRUE if TRUE, generate a BWR for a flushed PI
_cache_stats_monitor FALSE TRUE if TRUE, enable cache stats monitoring
_capture_buffer_size 65536 TRUE To set the size of the PGA I/O recording buffers
_capture_publisher_flow_control_threshold 0 TRUE Flow control threshold for capture publishers
_cgs_reconfig_timeout 120 TRUE CGS reconfiguration timeout interval
_cgs_send_timeout 300 TRUE CGS send timeout value
_check_block_after_checksum TRUE TRUE perform block check after checksum if both are turned on
_check_ts_threshold 0 TRUE check tablespace thresholds
_cleanup_rollback_entries 100 TRUE no. of undo entries to apply per transaction cleanup
_close_cached_open_cursors FALSE TRUE close cursors cached by PL/SQL at each commit
_cluster_library clss TRUE cluster library selection
_collapse_wait_history FALSE TRUE collapse wait history
_collect_undo_stats TRUE TRUE Collect Statistics v$undostat
_column_compression_factor 0 TRUE Column compression ratio
_column_elimination_off FALSE TRUE turn off predicate-only column elimination
_column_tracking_level 1 TRUE column usage tracking
_compilation_call_heap_extent_size 16384 TRUE Size of the compilation call heaps extents
_complex_view_merging TRUE TRUE enable complex view merging
_controlfile_block_size 0 TRUE control file block size in bytes
_controlfile_enqueue_dump FALSE TRUE dump the system states after controlfile enqueue timeout
_controlfile_enqueue_holding_time 120 TRUE control file enqueue max holding time in seconds
_controlfile_enqueue_timeout 900 TRUE control file enqueue timeout in seconds
_controlfile_section_init_size Null value TRUE control file initial section size
_controlfile_section_max_expand Null value TRUE control file max expansion rate
_controlfile_update_check OFF TRUE controlfile update sanity check
_convert_set_to_join FALSE TRUE enables conversion of set operator to join
_coord_message_buffer 0 TRUE parallel recovery coordinator side extra message buffer size
_corrupted_rollback_segments Null value TRUE corrupted undo segment list
_cost_equality_semi_join TRUE TRUE enables costing of equality semi-join
_cpu_to_io 0 TRUE divisor for converting CPU cost to I/O cost
_cr_grant_global_role TRUE TRUE if TRUE, grant lock for CR requests when block is in global role
_cr_grant_local_role AUTO TRUE turn 3-way CR grants off, make it automatic, or turn it on
_cr_server_log_flush TRUE TRUE if TRUE, flush redo log before serving a CR buffer
_ctas_hwm_brokered_loads TRUE TRUE Enable HWM brokered CTAS
_cursor_bind_capture_area_size 400 TRUE maximum size of the cursor bind capture area
_cursor_bind_capture_interval 900 TRUE interval (in seconds) between two bind capture for a cursor
_cursor_cache_frame_bind_memory FALSE TRUE frame & bind buffer caching
_cursor_db_buffers_pinned 1854 TRUE additional number of buffers a cursor can pin at once
_cursor_features_enabled 2 TRUE Shared cursor features enabled bits.
_cursor_plan_enabled TRUE TRUE enable collection and display of cursor plans
_cursor_plan_hash_version 1 TRUE version of cursor plan hash value
_cursor_plan_unparse_enabled TRUE TRUE enables/disables using unparse to build projection/predicates
_cursor_stats_bucket 15 TRUE Hash table buckets for cursor stats (2^).
_cursor_stats_heap 4 TRUE Heaps/latches for cursor stats.
_cvw_enable_weak_checking TRUE TRUE enable weak view checking
_db_aging_cool_count 1 TRUE Touch count set when buffer cooled
_db_aging_freeze_cr FALSE TRUE Make CR buffers always be too cold to keep in cache
_db_aging_hot_criteria 2 TRUE Touch count which sends a buffer to head of replacement list
_db_aging_stay_count 0 TRUE Touch count set when buffer moved to head of replacement list
_db_aging_touch_time 3 TRUE Touch count which sends a buffer to head of replacement list
_db_always_check_system_ts TRUE TRUE Always perform block check and checksum for System tablespace
_db_block_adjcheck TRUE TRUE adjacent cache buffer checks - low blkchk overwrite parameter
_db_block_adjchk_level 0 TRUE adjacent cache buffer check level
_db_block_align_direct_read TRUE TRUE Align Direct Reads
_db_block_buffers 928151 TRUE Number of database blocks cached in memory: hidden parameter
_db_block_cache_clone FALSE TRUE Always clone data blocks on get (for debugging)
_db_block_cache_history 0 TRUE buffer header tracing (non-zero only when debugging)
_db_block_cache_history_level 2 TRUE buffer header tracing level
_db_block_cache_num_umap 0 TRUE number of unmapped buffers (for tracking swap calls on blocks)
_db_block_cache_protect FALSE TRUE protect database blocks (true only when debugging)
_db_block_cache_protect_internal 0 TRUE protect database blocks (for strictly internal use only)
_db_block_check_for_debug FALSE TRUE Check more and dump block before image for debugging
_db_block_check_objtyp TRUE TRUE check objd and typ on cache disk read
_db_block_do_full_mbreads FALSE TRUE do full block read even if some blocks are in cache
_db_block_hash_buckets 2097152 TRUE Number of database block hash buckets
_db_block_hash_latches 65536 TRUE Number of database block hash latches
_db_block_hi_priority_batch_size 0 TRUE Fraction of writes for high priority reasons
_db_block_known_clean_pct 2 TRUE Initial Percentage of buffers to maintain known clean
_db_block_lru_latches 64 TRUE number of lru latches
_db_block_max_cr_dba 6 TRUE Maximum Allowed Number of CR buffers per dba
_db_block_max_scan_pct 40 TRUE Percentage of buffers to inspect when looking for free
_db_block_med_priority_batch_size 0 TRUE Fraction of writes for medium priority reasons
_db_block_numa 1 TRUE Number of NUMA nodes
_db_block_prefetch_limit 0 TRUE Prefetch limit in blocks
_db_block_prefetch_quota 10 TRUE Prefetch quota as a percent of cache size
_db_block_table_scan_buffer_size 4194304 TRUE Size of shared table scan read buffer
_db_block_temp_redo FALSE TRUE generate redo for temp blocks
_db_block_trace_protect FALSE TRUE trace buffer protect calls
_db_block_vlm_check FALSE TRUE check of rvlm mapping leaks (for debugging)
_db_block_vlm_leak_threshold 3 TRUE Threshold for allowable vlm leaks
_db_blocks_per_hash_latch Null value TRUE Number of blocks per hash latch
_db_cache_advice_batch_size 128 TRUE cache advisory simulation batch size
_db_cache_advice_sample_factor 4 TRUE cache advisory sampling factor
_db_cache_crx_check FALSE TRUE check for costly crx examination functions
_db_cache_pre_warm TRUE TRUE Buffer Cache Pre-Warm Enabled : hidden parameter
_db_cache_process_cr_pin_max Null value TRUE maximum number of cr pins a process may have
_db_change_notification_enable TRUE TRUE enable db change notification
_db_fast_obj_check FALSE TRUE enable fast object drop sanity check
_db_fast_obj_ckpt TRUE TRUE enable fast object checkpoint
_db_fast_obj_truncate TRUE TRUE enable fast object truncate
_db_file_direct_io_count 1048576 TRUE Sequential I/O buf size
_db_file_exec_read_count 16 TRUE multiblock read count for regular clients
_db_file_format_io_buffers 4 TRUE Block formatting I/O buf count
_db_file_noncontig_mblock_read_count 11 TRUE number of noncontiguous db blocks to be prefetched
_db_file_optimizer_read_count 16 TRUE multiblock read count for regular clients
_db_handles 2500 TRUE System-wide simultaneous buffer operations
_db_handles_cached 5 TRUE Buffer handles cached each process
_db_hot_block_tracking FALSE TRUE track hot blocks for hash latch contention
_db_index_block_checking TRUE TRUE index block checking override parameter
_db_large_dirty_queue 25 TRUE Number of buffers which force dirty queue to be written
_db_lost_write_checking FALSE TRUE Enable scn based lost write detection mechanism
_db_mttr_advice ON TRUE MTTR advisory
_db_mttr_partitions 0 TRUE number of partitions for MTTR advisory
_db_mttr_sample_factor 64 TRUE MTTR simulation sampling factor
_db_mttr_sim_target Null value TRUE MTTR simulation targets
_db_mttr_sim_trace_size 256 TRUE MTTR simulation trace size
_db_mttr_trace_to_alert FALSE TRUE dump trace entries to alert file
_db_obj_ckpt_ordered FALSE TRUE fast object checkpoint ordered by lrba
_db_obj_enable_ksr TRUE TRUE enable ksr in object checkpoint/reuse
_db_percent_hot_default 50 TRUE Percent of default buffer pool considered hot
_db_percent_hot_keep 0 TRUE Percent of keep buffer pool considered hot
_db_percent_hot_recycle 0 TRUE Percent of recycle buffer pool considered hot
_db_percpu_create_cachesize 2 TRUE size of cache created per cpu in deferred cache create
_db_recovery_temporal_file_dest Null value TRUE default database recovery temporal file location
_db_required_percent_fairshare_usage 10 TRUE percent of fairshare a processor group should always use
_db_row_overlap_checking TRUE TRUE row overlap checking override parameter for data/index blocks
_db_todefer_cache_create TRUE TRUE buffer cache deferred create
_db_writer_chunk_writes 0 TRUE Number of writes DBWR should wait for
_db_writer_coalesce_area_size 1048576 TRUE Size of memory allocated to dbwriter for coalescing writes
_db_writer_coalesce_write_limit 131072 TRUE Limit on size of coalesced write
_db_writer_flush_imu TRUE TRUE If FALSE, DBWR will not downgrade IMU txns for AGING
_db_writer_histogram_statistics FALSE TRUE maintain dbwr histogram statistics in x$kcbbhs
_db_writer_max_writes 0 TRUE Max number of outstanding DB Writer IOs
_db_writer_verify_writes FALSE TRUE Enable lost write detection mechanism
_dbg_proc_startup FALSE TRUE debug process startup
_dbwr_async_io TRUE TRUE Enable dbwriter asynchronous writes
_dbwr_scan_interval 300 TRUE dbwriter scan interval
_dbwr_tracing 0 TRUE Enable dbwriter tracing
_dead_process_scan_interval 10 TRUE PMON dead process scan interval
_dedicated_server_poll_count 10 TRUE dedicated server poll count
_dedicated_server_post_wait FALSE TRUE dedicated server post/wait
_dedicated_server_post_wait_call FALSE TRUE dedicated server post/wait call
_default_encrypt_alg 0 TRUE default encryption algorithm
_default_non_equality_sel_check TRUE TRUE sanity check on default selectivity for like/range predicate
_delay_index_maintain TRUE TRUE delays index maintenance until after MV is refreshed
_diag_daemon TRUE TRUE start DIAG daemon
_diag_diagnostics TRUE TRUE Turn off diag diagnostics
_diag_dump_timeout 30 TRUE timeout parameter for SYNC dump
_dimension_skip_null TRUE TRUE control dimension skip when null feature
_disable_adaptive_shrunk_aggregation FALSE TRUE adaptive shrunk aggregation
_disable_datalayer_sampling FALSE TRUE disable datalayer sampling
_disable_duplex_link TRUE TRUE Turn off connection duplexing
_disable_fast_aggregation FALSE TRUE fast aggregation
_disable_file_locks FALSE TRUE disable file locks for control, data, redo log files
_disable_flashback_wait_callback FALSE TRUE Disable flashback wait callback
_disable_function_based_index FALSE TRUE disable function-based index matching
_disable_health_check FALSE TRUE Disable Health Check
_disable_image_check FALSE TRUE Disable Oracle executable image checking
_disable_incremental_checkpoints FALSE TRUE Disable incremental checkpoints for thread recovery
_disable_incremental_recovery_ckpt FALSE TRUE Disable incremental recovery checkpoint mechanism
_disable_instance_params_check FALSE TRUE disable instance type check for ksp
_disable_interface_checking FALSE TRUE disable interface checking at startup
_disable_kcbhxor_osd FALSE TRUE disable kcbh(c)xor OSD functionality
_disable_latch_free_SCN_writes_via_32cas FALSE TRUE disable latch-free SCN writes using 32-bit compare & swap
_disable_latch_free_SCN_writes_via_64cas FALSE TRUE disable latch-free SCN writes using 64-bit compare & swap
_disable_logging FALSE TRUE Disable logging
_disable_multiple_block_sizes FALSE TRUE disable multiple block size support (for debugging)
_disable_odm FALSE TRUE disable odm feature
_disable_recoverable_recovery FALSE TRUE Disable the new recoverable recovery mechanism
_disable_recovery_read_skip FALSE TRUE Disable the read optimization during media recovery
_disable_sample_io_optim FALSE TRUE disable row sampling IO optimization
_disable_savepoint_reset FALSE TRUE disable the fix for bug 1402161
_disable_selftune_checkpointing FALSE TRUE Disable self-tune checkpointing
_disable_streams_pool_auto_tuning FALSE TRUE disable streams pool auto tuning
_disable_sun_rsm TRUE TRUE Disable IPC OSD support for Sun RSMAPI
_disable_system_state 4294967294 TRUE disable system state dump
_disable_txn_alert 0 TRUE disable txn layer alert
_discrete_transactions_enabled FALSE TRUE enable OLTP mode
_dispatcher_rate_scale Null value TRUE scale to display rate statistic (100ths of a second)
_dispatcher_rate_ttl Null value TRUE time-to-live for rate statistic (100ths of a second)
_distinct_view_unnesting FALSE TRUE enables unnesting of in subquery into distinct view
_distributed_recovery_connection_hold_time 200 TRUE number of seconds RECO holds outbound connections open
_dlm_send_timeout 30000 TRUE DLM send timeout value
_dlmtrace Null value TRUE Trace string of global enqueue type(s)
_dm_max_shared_pool_pct 1 TRUE max percentage of the shared pool to use for a mining model
_dml_monitoring_enabled TRUE TRUE enable modification monitoring
_domain_index_batch_size 2000 TRUE maximum number of rows from one call to domain index fetch routine
_domain_index_dml_batch_size 200 TRUE maximum number of rows for one call to domain index dml routines
_drop_table_granule 256 TRUE drop_table_granule
_drop_table_optimization_enabled TRUE TRUE reduce SGA memory use during drop of a partitioned table
_ds_iocount_iosize 6553664 TRUE Dynamic Sampling Service defaults: #IOs and IO Size
_dss_cache_flush FALSE TRUE enable full cache flush for parallel execution
_dtree_area_size 131072 TRUE size of Decision Tree Classification work area
_dtree_binning_enabled TRUE TRUE Decision Tree Binning Enabled
_dtree_bintest_id 0 TRUE Decision Tree Binning Test ID
_dtree_compressbmp_enabled TRUE TRUE Decision Tree Using Compressed Bitmaps Enabled
_dtree_max_surrogates 1 TRUE maximum number of surrogates
_dtree_pruning_enabled TRUE TRUE Decision Tree Pruning Enabled
_dummy_instance FALSE TRUE dummy instance started by RMAN
_dump_common_subexpressions FALSE TRUE dump common subexpressions
_dump_connect_by_loop_data FALSE TRUE dump connect by loop error message into trc file
_dump_cursor_heap_sizes FALSE TRUE dump comp/exec heap sizes to tryace file
_dump_interval_limit 120 TRUE trace dump time interval limit (in seconds)
_dump_max_limit 5 TRUE max number of dump within dump interval
_dump_qbc_tree 0 TRUE dump top level query parse tree to trace
_dump_rcvr_ipc TRUE TRUE if TRUE enables IPC dump at instance eviction time
_dump_system_state_scope local TRUE scope of sysstate dump during instance termination
_dump_trace_scope global TRUE scope of trace dump during a process crash
_dynamic_rls_policies TRUE TRUE rls policies are dynamic
_dynamic_stats_threshold 30 TRUE delay threshold (in seconds) between sending statistics messages
_eliminate_common_subexpr TRUE TRUE enables elimination of common sub-expressions
_enable_NUMA_optimization TRUE TRUE Enable NUMA specific optimizations
_enable_block_level_transaction_recovery TRUE TRUE enable block level recovery
_enable_cscn_caching FALSE TRUE enable commit SCN caching for all transactions
_enable_default_affinity 0 TRUE to enable default implementation of affinity osds
_enable_dml_lock_escalation TRUE TRUE enable dml lock escalation against partitioned tables if TRUE
_enable_exchange_validation_using_check TRUE TRUE use check constraints on the table for validation
_enable_fast_ref_after_mv_tbs FALSE TRUE enable fast refresh after move tablespace
_enable_hash_overflow FALSE TRUE TRUE - enable hash cluster overflow based on SIZE
_enable_hwm_sync TRUE TRUE enable HWM synchronization
_enable_list_io FALSE TRUE Enable List I/O
_enable_nativenet_tcpip FALSE TRUE Enable skgxp driver usage for native net
_enable_refresh_schedule TRUE TRUE enable or disable MV refresh scheduling (revert to 9.2 behavior)
_enable_reliable_latch_waits TRUE TRUE Enable reliable latch waits
_enable_rlb TRUE TRUE enable RLB metrics processing
_enable_row_shipping FALSE TRUE use the row shipping optimization for wide table selects
_enable_shared_pool_durations TRUE TRUE temporary to disable/enable kgh policy
_enable_tablespace_alerts TRUE TRUE enable tablespace alerts
_enable_type_dep_selectivity TRUE TRUE enable type dependent selectivity estimates
_enqueue_deadlock_time_sec 5 TRUE requests with timeout <= this will not have deadlock detection
_enqueue_debug_multi_instance FALSE TRUE debug enqueue multi instance
_enqueue_hash 1145 TRUE enqueue hash table length
_enqueue_hash_chain_latches 16 TRUE enqueue hash chain latches
_enqueue_locks 7410 TRUE locks for managed enqueues
_enqueue_resources 2660 TRUE resources for enqueues
_expand_aggregates TRUE TRUE expand aggregates
_explain_rewrite_mode FALSE TRUE allow additional messages to be generated during explain rewrite
_extended_pruning_enabled TRUE TRUE do runtime pruning in iterator if set to TRUE
_fair_remote_cvt FALSE TRUE if TRUE enables fair remote convert
_fairness_threshold 4 TRUE number of times to CR serve before downgrading lock
_fast_dual_enabled TRUE TRUE enable/disable fast dual
_fast_full_scan_enabled TRUE TRUE enable/disable index fast full scan
_fast_start_instance_recovery_target 0 TRUE instance recovery target time in RAC environment
_fg_sync_sleep_usecs 0 TRUE Log file sync via usleep
_fic_algorithm_set automatic TRUE Set Frequent Itemset Counting Algorithm
_fic_area_size 131072 TRUE size of Frequent Itemset Counting work area
_fic_max_length 20 TRUE Frequent Itemset Counting Maximum Itemset Length
_fic_min_bmsize 1024 TRUE Frequent Itemset Counting Minimum BITMAP Size
_fic_outofmem_candidates FALSE TRUE Frequent Itemset Counting Out Of Memory Candidates Generation
_fifth_spare_parameter Null value TRUE fifth spare parameter - string
_filemap_dir Null value TRUE FILEMAP directory
_first_k_rows_dynamic_proration TRUE TRUE enable the use of dynamic proration of join cardinalities
_first_spare_parameter 4294967294 TRUE high threshold undo_retention in seconds
_fix_control Null value TRUE bug fix control parameter
_flashback_allow_noarchivelog FALSE TRUE Allow enabling flashback on noarchivelog database
_flashback_barrier_interval 1800 TRUE Flashback barrier interval in seconds
_flashback_copy_latches 10 TRUE Number of flashback copy latches
_flashback_fuzzy_barrier TRUE TRUE Use flashback fuzzy barrier
_flashback_generation_buffer_size 67108864 TRUE flashback generation buffer size
_flashback_hint_barrier_percent 20 TRUE Flashback hint barrier percent
_flashback_log_io_error_behavior 0 TRUE Specify Flashback log I/O error behavior
_flashback_log_min_size 100 TRUE Minimum flashback log size
_flashback_log_size 1000 TRUE Flashback log size
_flashback_logfile_enqueue_timeout 600 TRUE flashback logfile enqueue timeout for opens
_flashback_marker_cache_enabled TRUE TRUE Enable flashback database marker cache
_flashback_marker_cache_size 328 TRUE Size of flashback database marker cache
_flashback_max_log_size 0 TRUE Maximum flashback log size in bytes (OS limit)
_flashback_max_n_log_per_thread 2048 TRUE Maximum number of flashback logs per flashback thread
_flashback_n_log_per_thread 128 TRUE Desired number of flashback logs per flashback thread
_flashback_standby_barrier_interval 1800 TRUE Flashback standby barrier interval in seconds
_flashback_verbose_info FALSE TRUE Print verbose information about flashback database
_flashback_write_size_qm 4 TRUE Desired flashback write size in quarter MB
_force_datefold_trunc FALSE TRUE force use of trunc for datefolding rewrite
_force_rewrite_enable FALSE TRUE control new query rewrite features
_force_temptables_for_gsets FALSE TRUE executes concatenation of rollups using temp tables
_fourth_spare_parameter Null value TRUE fourth spare parameter - string
_full_pwise_join_enabled TRUE TRUE enable full partition-wise join when TRUE
_gby_hash_aggregation_enabled TRUE TRUE enable group-by and aggregation using hash scheme
_gby_onekey_enabled TRUE TRUE enable use of one comparison of all group by keys
_gc_affinity_limit 50 TRUE dynamic affinity limit
_gc_affinity_minimum 6000 TRUE dynamic affinity minimum activity per minute
_gc_affinity_time 10 TRUE if non zero, enable dynamic object affinity
_gc_async_memcpy FALSE TRUE if TRUE, use async memcpy
_gc_check_bscn TRUE TRUE if TRUE, check for stale blocks
_gc_coalesce_recovery_reads TRUE TRUE if TRUE, coalesce recovery reads
_gc_defer_time 3 TRUE how long to defer down converts for hot buffers
_gc_dissolve_undo_affinity FALSE TRUE if TRUE, dissolve undo affinity after an offline
_gc_dynamic_affinity_locks TRUE TRUE if TRUE, get dynamic affinity locks
_gc_element_percent 103 TRUE global cache element percent
_gc_global_lru AUTO TRUE turn global lru off, make it automatic, or turn it on
_gc_initiate_undo_affinity TRUE TRUE if TRUE, initiate undo affinity after an online
_gc_integrity_checks 1 TRUE set the integrity check level
_gc_keep_recovery_buffers TRUE TRUE if TRUE, make recovery buffers current
_gc_latches 8 TRUE number of latches per LMS process
_gc_maximum_bids 0 TRUE maximum number of bids which can be prepared
_gc_statistics TRUE TRUE if TRUE, kcl statistics are maintained
_gc_undo_affinity TRUE TRUE if TRUE, enable dynamic undo affinity
_gc_undo_affinity_locks TRUE TRUE if TRUE, get affinity locks for undo
_gc_use_cr TRUE TRUE if TRUE, allow CR pins on PI and WRITING buffers
_gc_vector_read TRUE TRUE if TRUE, vector read current buffers
_gcs_fast_reconfig TRUE TRUE if TRUE, enable fast reconfiguration for gcs locks
_gcs_latches 2 TRUE number of gcs resource hash latches to be allocated per LMS process
_gcs_process_in_recovery TRUE TRUE if TRUE, process gcs requests during instance recovery
_gcs_resources Null value TRUE number of gcs resources to be allocated
_gcs_shadow_locks Null value TRUE number of pcm shadow locks to be allocated
_gcs_testing 0 TRUE GCS testing parameter
_generalized_pruning_enabled TRUE TRUE controls extensions to partition pruning for general predicates
_ges_dd_debug 1 TRUE if 1 or higher enables GES deadlock detection debug diagnostics
_ges_diagnostics TRUE TRUE if TRUE enables GES diagnostics
_ges_health_check 1 TRUE if greater than 0 enables GES system health check
_globalindex_pnum_filter_enabled TRUE TRUE enables filter for global index with partition extended syntax
_groupby_nopushdown_cut_ratio 3 TRUE groupby nopushdown cut ratio
_groupby_orderby_combine 5000 TRUE groupby/orderby don't combine threshold
_gs_anti_semi_join_allowed TRUE TRUE enable anti/semi join for the GS query
_hang_analysis_num_call_stacks 3 TRUE hang analysis num call stacks
_hang_detection 0 TRUE Hang Management detection interval
_hard_protection FALSE TRUE if TRUE enable H.A.R.D specific format changes
_hash_join_enabled TRUE TRUE enable/disable hash join
_hash_multiblock_io_count 0 TRUE number of blocks hash join will read/write at once
_high_priority_process_num_yields_before_sleep 1000 TRUE the number of yields performed by high priority processesbefore they sleep
_high_priority_processes LMS* TRUE High Priority Process Name Mask
_high_server_threshold 0 TRUE high server thresholds
_hj_bit_filter_threshold 50 TRUE hash-join bit filtering threshold (0 always enabled)
_hwm_sync_threshold 10 TRUE HWM synchronization threshold in percentage
_idl_conventional_index_maintenance TRUE TRUE enable conventional index maintenance for insert direct load
_idxrb_rowincr 100000000 TRUE proportionality constant for dop vs. rows in index rebuild
_ignore_desc_in_index FALSE TRUE ignore DESC in indexes, sort those columns ascending anyhow
_immediate_commit_propagation TRUE TRUE if TRUE, propagate commit SCN immediately
_improved_outerjoin_card TRUE TRUE improved outer-join cardinality calculation
_improved_row_length_enabled TRUE TRUE enable the improvements for computing the average row length
_imr_active TRUE TRUE Activate Instance Membership Recovery feature
_imr_disk_voting_interval 3 TRUE Maximum wait for IMR disk voting (seconds)
_imr_max_reconfig_delay 300 TRUE Maximum Reconfiguration delay (seconds)
_imr_splitbrain_res_wait 600 TRUE Maximum wait for split-brain resolution (seconds)
_imr_systemload_check TRUE TRUE Perform the system load check during IMR
_imu_pools 3 TRUE in memory undo pools
_in_memory_undo TRUE TRUE Make in memory undo for top level transactions
_incremental_recovery_ckpt_min_batch 300 TRUE Minimum number of writes for incremental recovery ckpt every 3 sec
_index_join_enabled TRUE TRUE enable the use of index joins
_index_prefetch_factor 100 TRUE index prefetching factor
_init_granule_interval 10 TRUE number of granules to process for deferred cache
_init_sql_file ?/rdbms/admin/sql.bsq TRUE File containing SQL statements to execute upon database creation
_inject_startup_fault 0 TRUE inject fault in the startup code
_inline_sql_in_plsql FALSE TRUE inline SQL in PL/SQL
_inquiry_retry_interval 3 TRUE if greater than 0 enables inquiry retry after specified interval
_insert_ctas_dependency FALSE TRUE determines if ctas cursors insert a dependency on the base table
_insert_enable_hwm_brokered TRUE TRUE during parallel inserts high water marks are brokered
_inst_locking_period 5 TRUE period an instance can retain a newly acquired level1 bitmap
_interconnect_checksum TRUE TRUE if TRUE, checksum interconnect blocks
_intrapart_pdml_enabled TRUE TRUE Enable intra-partition updates/deletes
_intrapart_pdml_randomlocal_enabled TRUE TRUE Enable intra-partition updates/deletes with random local dist
_io_shared_pool_size 4194304 TRUE Size of I/O buffer pool from SGA
_io_slaves_disabled FALSE TRUE Do not use I/O slaves
_ior_serialize_fault 0 TRUE inject fault in the ior serialize code
_ioslave_batch_count 1 TRUE Per attempt IOs picked
_ioslave_issue_count 500 TRUE IOs issued before completion check
_ipc_fail_network 0 TRUE Simulate cluster network failer
_ipc_test_failover 0 TRUE Test transparent cluster network failover
_ipc_test_mult_nets 0 TRUE simulate multiple cluster networks
_job_queue_interval 5 TRUE Wakeup interval in seconds for job queue co-ordinator
_kcl_commit TRUE TRUE if TRUE, call kjbcommit
_kcl_conservative_log_flush FALSE TRUE if TRUE, conservatively log flush before CR serving
_kcl_debug TRUE TRUE if TRUE, record le history
_kcl_index_split TRUE TRUE if TRUE, reject pings on blocks in middle of a split
_kcl_undo_grouping 32 TRUE grouping for undo block locks
_kcl_undo_locks 128 TRUE number of locks per undo segment
_kdbl_enable_post_allocation FALSE TRUE allocate dbas after populating data buffers
_keep_remote_column_size FALSE TRUE remote column size does not get modified
_kernel_message_network_driver FALSE TRUE kernel message network driver
_kffmap_hash_size 1024 TRUE size of kffmap_hash table
_kffmop_hash_size 2048 TRUE size of kffmop_hash table
_kghdsidx_count 4 TRUE max kghdsidx count
_kgl_bucket_count 9 TRUE index to the bucket count array
_kgl_fixed_extents TRUE TRUE fixed extent size for library cache memory allocations
_kgl_hash_collision FALSE TRUE whether KGL hash collision is possible
_kgl_heap_size 1024 TRUE extent size for library cache heap 0
_kgl_keep_cache_pct 30 TRUE KGL keep cache minimum threshold
_kgl_keep_cache_retain_pct 20 TRUE KGL keep cache retain threshold
_kgl_large_heap_warning_threshold 52428800 TRUE maximum heap size before KGL writes warnings to the alert log
_kgl_latch_count 0 TRUE number of library cache latches
_kgl_multi_instance_invalidation TRUE TRUE whether KGL to support multi-instance invalidations
_kgl_multi_instance_lock TRUE TRUE whether KGL to support multi-instance locks
_kgl_multi_instance_pin TRUE TRUE whether KGL to support multi-instance pins
_kgl_session_cached_objects 10 TRUE maximum length of the KGL object cache lru
_kgl_time_to_wait_for_locks 15 TRUE time to wait for locks and pins before timing out
_kglsim_maxmem_percent 5 TRUE max percentage of shared pool size to be used for KGL advice
_kgx_latches 512 TRUE # of mutex latches if CAS is not supported.
_kgx_spin_count 255 TRUE third spare parameter - integer
_kill_controlfile_enqueue_blocker TRUE TRUE enable killing controlfile enqueue blocker on timeout
_kill_diagnostics_timeout 60 TRUE timeout delay in seconds before killing enqueue blocker
_kill_enqueue_blocker 3 TRUE if greater than 0 enables killing enqueue blocker
_kill_java_threads_on_eoc FALSE TRUE Kill Java threads and do sessionspace migration at end of call
_kkdlgon_max_iter 20000 TRUE kkdlgon maximum number of iterations
_kkfi_trace FALSE TRUE trace expression substitution
_kks_free_cursor_stat_pct 10 TRUE percentage of cursor stats buckets to scan on each load, in 1/10th of a percent
_kks_use_mutex_pin TRUE TRUE Turning on this will make KKS use mutex for cursor pins.
_kolfuseslf FALSE TRUE allow kolf to use slffopen
_kql_subheap_trace 0 TRUE tracing level for library cache subheap level pins
_ksb_disable_diagpid FALSE TRUE disable the call to ksb_diagpid
_ksb_restart_clean_time 30000 TRUE process uptime for restarts
_ksb_restart_policy_times Null value TRUE process restart policy times in seconds
_ksd_test_param 999 TRUE KSD test parmeter
_ksdxdocmd_default_timeout_ms 30000 TRUE default timeout for internal oradebug commands
_ksdxw_cini_flg 0 TRUE ksdxw context initialization flag
_ksdxw_nbufs 1000 TRUE ksdxw number of buffers in buffered mode
_ksdxw_num_pgw 10 TRUE number of watchpoints on a per-process basis
_ksdxw_num_sgw 10 TRUE number of watchpoints to be shared by all processes
_ksdxw_stack_depth 4 TRUE number of PCs to collect in the stack when watchpoint is hit
_kse_die_timeout 60000 TRUE amount of time a dying process is spared by PMON (in centi-secs)
_kse_pc_table_size 256 TRUE kse pc table cache size
_ksfd_verify_write FALSE TRUE verify asynchronous writes issued through ksfd
_ksi_trace Null value TRUE KSI trace string of lock type(s)
_ksmg_granule_locking_status 1 TRUE granule locking status
_ksmg_granule_size 16777216 TRUE granule size in bytes
_ksmg_lock_check_interval Null value TRUE timeout action interval in minutes
_ksmg_lock_reacquire_count 5 TRUE repeat count for acquisition of locks
_ksu_diag_kill_time 5 TRUE number of seconds ksuitm waits before killing diag
_ksuitm_dont_kill_dumper FALSE TRUE delay inst. termination to allow processes to dump
_ksxp_diagmode OFF TRUE set to OFF to disable automatic slowsend diagnostics
_ksxp_reporting_process LMD0 TRUE reporting process for KSXP
_ksxp_send_timeout 300 TRUE set timeout for sends queued with the inter-instance IPC
_ksxp_testing 0 TRUE KSXP test parameter
_ktc_debug 0 TRUE for ktc debug
_ktc_latches 0 TRUE number of ktc latches
_ktu_latches 0 TRUE number of KTU latches
_ku_trace none TRUE datapump trace parameter
_large_pool_min_alloc 65536 TRUE minimum allocation size in bytes for the large allocation pool
_last_allocation_period 5 TRUE period over which an instance can retain an active level1 bitmap
_latch_class_0 Null value TRUE latch class 0
_latch_class_1 Null value TRUE latch class 1
_latch_class_2 Null value TRUE latch class 2
_latch_class_3 Null value TRUE latch class 3
_latch_class_4 Null value TRUE latch class 4
_latch_class_5 Null value TRUE latch class 5
_latch_class_6 Null value TRUE latch class 6
_latch_class_7 Null value TRUE latch class 7
_latch_classes Null value TRUE latch classes override
_latch_miss_stat_sid 0 TRUE Sid of process for which to collect latch stats
_latch_recovery_alignment 998 TRUE align latch recovery structures
_ldr_io_size 262144 TRUE size of write IOs used during a load operation
_left_nested_loops_random TRUE TRUE enable random distribution method for left of nestedloops
_lgwr_async_broadcasts TRUE TRUE LGWR Asynchronous Broadcasts enabling boolean flag
_lgwr_async_io FALSE TRUE LGWR Asynchronous IO enabling boolean flag
_lgwr_delay_write FALSE TRUE LGWR write delay for debugging
_lgwr_io_slaves 0 TRUE LGWR I/O slaves
_lgwr_max_ns_wt 1 TRUE Maximum wait time for lgwr to allow NetServer to progress
_lgwr_ns_nl_max 1000 TRUE Variable to simulate network latency or buffer threshold
_lgwr_ns_nl_min 500 TRUE Variable to simulate network latency or buffer threshold
_lgwr_ns_sim_err 0 TRUE Variable to simulate errors lgwrns
_lgwr_ta_sim_err 0 TRUE Variable to simulate errors lgwr true async
_library_cache_advice TRUE TRUE whether KGL advice should be turned on
_lightweight_hdrs TRUE TRUE Lightweight headers for redo
_like_with_bind_as_equality FALSE TRUE treat LIKE predicate with bind as an equality predicate
_lm_activate_lms_threshold 100 TRUE threshold value to activate an additional lms
_lm_better_ddvictim TRUE TRUE GES better deadlock victim
_lm_cache_lvl0_cleanup 0 TRUE how often to cleanup level 0 cache res (in sec)
_lm_cache_res_cleanup 25 TRUE percentage of cached resources should be cleanup
_lm_cache_res_type TMHWDI TRUE cache resource: string of lock types(s)
_lm_checksum_batch_msg FALSE TRUE GES checksum batch messages
_lm_contiguous_res_count 128 TRUE number of contiguous blocks that will hash to the same HV bucket
_lm_dd_interval 60 TRUE dd time interval in seconds
_lm_dd_max_search_time 180 TRUE max dd search time per token
_lm_dd_scan_interval 5 TRUE dd scan interval in seconds
_lm_dd_search_cnt 3 TRUE number of dd search per token get
_lm_drm_max_requests 100 TRUE dynamic remastering maximum affinity requests processed together
_lm_drm_window 0 TRUE dynamic remastering bucket window size
_lm_drm_xlatch 0 TRUE dynamic remastering forced exclusive latches
_lm_dynamic_lms FALSE TRUE dynamic lms invocation
_lm_dynamic_load TRUE TRUE dynamic load adjustment
_lm_dynamic_remastering FALSE TRUE if TRUE enables dynamic remastering
_lm_enq_lock_freelist Null value TRUE Number of ges enqueue element freelist
_lm_enq_rcfg TRUE TRUE if TRUE enables enqueue reconfiguration
_lm_enqueue_freelist 3 TRUE Number of enqueue freelist
_lm_file_affinity Null value TRUE mapping between file id and master instance number
_lm_global_posts TRUE TRUE if TRUE deliver global posts to remote nodes
_lm_lmd_waittime 8 TRUE default wait time for lmd in centiseconds
_lm_lms 0 TRUE number of background gcs server processes to start
_lm_lms_waittime 8 TRUE default wait time for lms in centiseconds
_lm_locks 12000 TRUE number of enqueues configured for cluster database
_lm_master_weight 1 TRUE master resource weight for this instance
_lm_max_lms 0 TRUE max. number of background global cache server processes
_lm_min_lms 0 TRUE min. number of background global cache server processes
_lm_msg_batch_size 8192 TRUE GES batch message size
_lm_msg_cache_thresholds Null value TRUE GES message buffer caching threshold
_lm_msg_cleanup_interval 3000 TRUE GES message buffer cleanup interval time
_lm_node_join_opt FALSE TRUE cluster database node join optimization in reconfig
_lm_non_fault_tolerant FALSE TRUE disable cluster database fault-tolerance mode
_lm_num_pcmhv_latches 0 TRUE number of latches covering the PCM HV buckets in cgs
_lm_num_pt_buckets 4096 TRUE number of buckets in the object affinity hash table
_lm_num_pt_latches 128 TRUE number of latches in the object affinity hash table
_lm_postevent_buffer_size 256 TRUE postevent buffer size
_lm_proc_freeze_timeout 300 TRUE reconfiguration: process freeze timeout
_lm_process_batching TRUE TRUE GES implicit process batching for IPC messages
_lm_procs 320 TRUE number of client processes configured for cluster database
_lm_rcfg_timeout 180000 TRUE Reconfiguration timeout
_lm_rcv_buffer_size 32768 TRUE the size of receive buffer
_lm_rcvr_hang_allow_time 200 TRUE receiver hang allow time in seconds
_lm_rcvr_hang_check_frequency 60 TRUE receiver hang check frequency in seconds
_lm_rcvr_hang_kill FALSE TRUE to kill receiver hang
_lm_res_hash_bucket 0 TRUE number of resource hash buckets
_lm_res_part 128 TRUE number of resource partition configured for gcs
_lm_ress 6000 TRUE number of resources configured for cluster database
_lm_send_buffers 10000 TRUE number of cluster database send buffers
_lm_send_mode auto TRUE GES send mode
_lm_send_queue_batching TRUE TRUE GES send queue message batching
_lm_send_queue_length 5000 TRUE GES send queue maximum length
_lm_sendproxy_reserve 25 TRUE GES percentage of send proxy reserve of send tickets
_lm_share_lock_opt FALSE TRUE if TRUE enables share lock optimization
_lm_sq_batch_factor 2 TRUE GES send queue minimum batching factor
_lm_sq_batch_type auto TRUE GES send queue batching mechanism
_lm_sq_batch_waittick 3 TRUE GES send queue batching waittime in tick
_lm_sync_timeout Null value TRUE Synchronization timeout for DLM reconfiguration steps
_lm_ticket_active_sendback Null value TRUE Flow control ticket active sendback threshold
_lm_tickets 1000 TRUE GES messaging tickets
_lm_tx_delta 16 TRUE TX lock localization delta
_lm_validate_resource_type FALSE TRUE if TRUE enables resource name validation
_lm_xids 352 TRUE number of transaction IDs configured for cluster database
_load_without_compile NONE TRUE Load PL/SQL or Database objects without compilation
_local_communication_costing_enabled TRUE TRUE enable local communication costing when TRUE
_local_communication_ratio 50 TRUE set the ratio between global and local communication (0..100)
_lock_sga_areas 0 TRUE Lock specified areas of the SGA in physical memory
_log_archive_avoid_memcpy TRUE TRUE log archive avoid memcpy
_log_archive_buffer_size 2048 TRUE Size of each archival buffer in log file blocks
_log_archive_buffers 10 TRUE Number of buffers to allocate for archiving
_log_archive_callout Null value TRUE archival callout
_log_archive_compress_enable FALSE TRUE Bypass database rules for enabling archivelog compression
_log_archive_delta_sync_wait 0 TRUE iterative sleep time in centiseconds seconds when SYNC=PARALLEL
_log_archive_net_timeout 0 TRUE maximum network wait time in seconds when SYNC=PARALLEL
_log_archive_network_redo_size 10 TRUE Log archive network redo buffer size used by ARCH
_log_archive_prot_auto_demote FALSE TRUE log archive protection auto demotion
_log_archive_security_enabled TRUE TRUE log archive security enabled
_log_blocks_during_backup TRUE TRUE log block images when changed during backup
_log_buffers_corrupt FALSE TRUE corrupt redo buffers before write
_log_buffers_debug FALSE TRUE debug redo buffers (slows things down)
_log_checkpoint_recovery_check 0 TRUE # redo blocks to verify after checkpoint
_log_committime_block_cleanout FALSE TRUE Log commit-time block cleanout
_log_debug_multi_instance FALSE TRUE debug redo multi instance code
_log_deletion_policy ALL FALSE archivelog deletion policy for mandatory/all destination
_log_event_queues 0 TRUE number of the log writer event queues
_log_io_size 0 TRUE automatically initiate log write if this many redo blocks in buffer
_log_parallelism 1 TRUE Number of log buffer strands
_log_parallelism_dynamic TRUE TRUE Enable dynamic strands
_log_parallelism_max 2 TRUE Maximum number of log buffer strands
_log_private_mul 5 TRUE Private strand multiplier for log space preallocation
_log_private_parallelism FALSE TRUE Number of private log buffer strands for zero-copy redo
_log_private_parallelism_mul 10 TRUE Active sessions multiplier to deduce number of private strands
_log_simultaneous_copies 32 TRUE number of simultaneous copies into redo buffer(# of copy latches)
_log_space_errors TRUE TRUE should we report space errors to alert log
_log_switch_timeout 0 TRUE Maximum number of seconds redos in the current log could span
_logout_storm_rate 0 TRUE number of processes that can logout in a second
_logout_storm_retrycnt 600 TRUE maximum retry count for logouts
_logout_storm_timeout 5 TRUE timeout in centi-seconds for time to wait between retries
_longops_enabled TRUE TRUE longops stats enabled
_low_server_threshold 0 TRUE low server thresholds
_master_direct_sends 31 TRUE direct sends for messages from master (DFS)
_mav_refresh_consistent_read TRUE TRUE refresh materialized views using consistent read snapshot
_mav_refresh_double_count_prevented FALSE TRUE materialized view MAV refreshes avoid double counting
_mav_refresh_opt 0 TRUE optimizations during refresh of materialized views
_mav_refresh_unionall_tables 3 TRUE # tables for union all expansion during materialized view refresh
_max_arch_lns_wait 120 TRUE Maximum wait by ARCH to allow NetServer to complete archival
_max_exponential_sleep 0 TRUE max sleep during exponential backoff
_max_lns_shutdown_archival_time 30 TRUE Maximum time spent by LNS to archive last log during shutdown
_max_protocol_support 10000 TRUE Max occurrence protocols supported in a process
_max_rfs_connections 0 TRUE maximum number of connections used for remote archival
_max_shrink_obj_stats 0 TRUE number of segments for which shrink stats will be maintained
_max_sleep_holding_latch 4 TRUE max time to sleep while holding a latch
_media_recovery_read_batch 128 TRUE media recovery block read batch
_media_recovery_reap_time 3 TRUE media recovery reap time
_mem_annotation_pr_lev 0 TRUE private memory annotation collection level
_mem_annotation_scale 1 TRUE memory annotation pre-allocation scaling
_mem_annotation_sh_lev 0 TRUE shared memory annotation collection level
_mem_annotation_store FALSE TRUE memory annotation in-memory store
_mem_std_extent_size 4096 TRUE standard extent size for fixed-size-extent heaps
_memory_broker_log_stat_entries 5 TRUE memory broker num stat entries
_memory_broker_marginal_utility_bc 10 TRUE Marginal Utility threshold pct for bc
_memory_broker_marginal_utility_sp 4 TRUE Marginal Utility threshold pct for sp
_memory_broker_shrink_heaps 15 TRUE memory broker allow policy to shrink shared pool
_memory_broker_shrink_java_heaps 900 TRUE memory broker allow policy to shrink java pool
_memory_broker_shrink_streams_pool 900 TRUE memory broker allow policy to shrink streams pool
_memory_broker_shrink_timeout 60000000 TRUE memory broker policy to timeout shrink shared/java pool
_memory_broker_stat_interval 30 TRUE memory broker statistics gathering interval
_memory_management_tracing 0 TRUE trace memory management activity
_memory_sanity_check 0 TRUE partial granule sanity check
_messages 1000 TRUE message queue resources - dependent on # processes & # buffers
_minfree_plus 0 TRUE max percentage of block space + minfree before we mark block full
_minimal_stats_aggregation TRUE TRUE prohibit stats aggregation at compile/partition maintenance time
_minimum_blocks_to_shrink 0 TRUE minimum number freeable blocks for shrink to be present
_minimum_extents_to_shrink 1 TRUE minimum number freeable extents for shrink to be present
_minimum_giga_scn 0 TRUE Minimum SCN to start with in 2^30 units
_mirror_redo_buffers FALSE TRUE Save buffers for debugging redo corruptions
_mmv_query_rewrite_enabled TRUE TRUE allow rewrites with multiple MVs and/or base tables
_multi_join_key_table_lookup TRUE TRUE TRUE iff multi-join-key table lookup prefetch is enabled
_multiple_instance_recovery FALSE TRUE use multiple instances for media recovery
_mv_refresh_ana 0 TRUE what percent to analyze after complete/PCT refresh
_mv_refresh_costing rule TRUE refresh decision based on cost or on rules
_mv_refresh_delta_fraction 10 TRUE delta mv as fractional percentage of size of mv
_mv_refresh_eut TRUE TRUE refresh materialized views using EUT(partition)-based algorithm
_mv_refresh_force_parallel_query 0 TRUE force materialized view refreshes to use parallel query
_mv_refresh_new_setup_disabled FALSE TRUE materialized view MV refresh new setup disabling
_mv_refresh_rebuild_percentage 10 TRUE minimum percentage change required in MV to force an index rebuild
_mv_refresh_selections TRUE TRUE create materialized views with selections and fast refresh
_mv_refresh_use_stats FALSE TRUE pass cardinality hints to refresh queries
_mv_refsched_timeincr 300000 TRUE proportionality constant for dop vs. time in MV refresh
_mv_rolling_inv FALSE TRUE create/alter mv uses rolling cursor invalidation instead of immediate
_mwin_schedule TRUE TRUE Enable/disable Maintenance Window Schedules
_nchar_imp_cnv TRUE TRUE NLS allow Implicit Conversion between CHAR and NCHAR
_nchar_imp_conv TRUE TRUE should implicit conversion bewteen clob and nclob be allowed
_ncmb_readahead_enabled 0 TRUE enable multi-block readahead for an index scan
_ncmb_readahead_tracing 0 TRUE turn on multi-block readahead tracing
_nested_loop_fudge 100 TRUE nested loop fudge
_nested_mav_fast_oncommit_enabled TRUE TRUE nested MAV refresh fast on commit allowed
_new_initial_join_orders TRUE TRUE enable initial join orders based on new ordering heuristics
_new_sort_cost_estimate TRUE TRUE enables the use of new cost estimate for sort
_newsort_enabled TRUE TRUE controls whether new sorts can be used as system sort
_newsort_ordered_pct 63 TRUE controls when new sort avoids sorting ordered input
_newsort_type 0 TRUE specifies options for the new sort algorithm
_no_objects FALSE TRUE no object features are used
_no_or_expansion FALSE TRUE OR expansion during optimization disabled
_no_recovery_through_resetlogs FALSE TRUE no recovery through this resetlogs operation
_notify_crs FALSE TRUE notify cluster ready services of startup and shutdown
_ns_max_flush_wt 1 TRUE Flush wait time for NetServer to flush oustanding writes
_ns_max_send_delay 15 TRUE Data Loss Time Bound for NetServer
_num_longop_child_latches 16 TRUE number of child latches for long op array
_number_cached_attributes 10 TRUE maximum number of cached attributes per instance
_object_reuse_bast 2 TRUE if 1 or higher, handle object reuse
_object_statistics TRUE TRUE enable the object level statistics collection
_offline_rollback_segments Null value TRUE offline undo segment list
_ogms_home Null value TRUE GMS home directory
_olap_aggregate_buffer_size 1048576 TRUE OLAP Aggregate max buffer size
_olap_aggregate_flags 0 TRUE OLAP Aggregate debug flags
_olap_aggregate_function_cache_enabled TRUE TRUE OLAP Aggregate function cache enabler
_olap_aggregate_function_merge_threshold 529 TRUE OLAP Aggregate function merge threshold
_olap_aggregate_max_thread_tuples 5000 TRUE OLAP Aggregate max thread tuples creation
_olap_aggregate_min_buffer_size 1024 TRUE OLAP Aggregate min buffer size
_olap_aggregate_min_thread_status 64 TRUE OLAP Aggregate minimum cardinality of dimensions for thread
_olap_aggregate_multipath_hier FALSE TRUE OLAP Aggregate Multi-path Hierarhies enabled
_olap_aggregate_statlen_thresh 1024 TRUE OLAP Aggregate status array usage threshold
_olap_aggregate_store_probability 100 TRUE OLAP Aggregate function storeback probability
_olap_aggregate_work_per_thread 1024 TRUE OLAP Aggregate max work parents
_olap_aggregate_worklist_max 5000 TRUE OLAP Aggregate max worklists generated at once
_olap_allocate_errorlog_format %8p %8y %8z %e (%n) TRUE OLAP Allocate Errorlog Format
_olap_allocate_errorlog_header Dim Source Basis
%-8d %-8s %-8b Description
-------- -------- -------- -----------
TRUE OLAP Allocate Errorlog Header format
_olap_continuous_trace_file FALSE TRUE Specify TRUE to enable continuous OLAP tracing - otherwise only exceptional events will be logged
_olap_dbgoutfile_echo_to_eventlog FALSE TRUE OLAP DbgOutfile copy output to event log (tracefile)
_olap_dimension_corehash_class 1 TRUE OLAP Dimension In-Core Hash Table Class
_olap_dimension_corehash_max 10000 TRUE OLAP Dimension In-Core Hash Table Maximum Size
_olap_eif_export_lob_size 2147483647 TRUE OLAP EIF Export BLOB size
_olap_lmgen_dim_size 100 TRUE Limitmap generator dimension column size
_olap_lmgen_meas_size 1000 TRUE Limitmap generator measure column size
_olap_object_hash_class 2 TRUE OLAP Object Hash Table Class
_olap_page_pool_expand_rate 20 TRUE OLAP Page Pool Expand Rate
_olap_page_pool_hi 50 TRUE OLAP Page Pool High Watermark
_olap_page_pool_hit_target 100 TRUE OLAP Page Pool Hit Target
_olap_page_pool_low 262144 TRUE OLAP Page Pool Low Watermark
_olap_page_pool_pressure 90 TRUE OLAP Page Pool Pressure Threshold
_olap_page_pool_shrink_rate 50 TRUE OLAP Page Pool Shrink Rate
_olap_parallel_update_small_group 400 TRUE OLAP parallel update pagespace by group
_olap_parallel_update_small_threshold 1000 TRUE OLAP parallel update threshold for number of small pagespaces
_olap_parallel_update_threshold 1000 TRUE OLAP parallel update threshold in pages
_olap_poutlog_echo_to_eventlog FALSE TRUE OLAP POutLog copy output to event log (tracefile)
_olap_sesscache_enabled TRUE TRUE OLAP Session Cache knob
_olap_sort_buffer_size 262144 TRUE OLAP Sort Buffer Size
_olap_statbool_corebits 20000000 TRUE OLAP Status Boolean max incore bits
_olap_statbool_threshold 8100 TRUE OLAP Status Boolean CBM threshold
_olap_table_function_statistics FALSE TRUE Specify TRUE to output OLAP table function timed statistics trace
_olap_wrap_errors FALSE TRUE Wrap error messages to OLAP outfile
_olapi_history_retention FALSE TRUE enable olapi history retention
_olapi_iface_object_history 1000 TRUE enable olapi interface object history collection
_olapi_iface_object_history_retention FALSE TRUE enable olapi interface object history retention
_olapi_iface_operation_history_retention FALSE TRUE enable olapi interface operation history retention
_olapi_interface_operation_history 1000 TRUE enable olapi interface operation history collection
_olapi_memory_operation_history 1000 TRUE enable olapi memory alloc/free history collection
_olapi_memory_operation_history_pause_at_seqno 0 TRUE enable olapi memory alloc/free history collection pausing
_olapi_memory_operation_history_retention FALSE TRUE enable olapi memory operation history retention
_olapi_session_history 300 TRUE enable olapi session history collection
_olapi_session_history_retention FALSE TRUE enable olapi session history retention
_old_connect_by_enabled FALSE TRUE enable/disable old connect by
_ols_cleanup_task TRUE TRUE Clean up unnecessary entries in OLS sessinfo table
_omf enabled TRUE enable/disable OMF
_oneside_colstat_for_equijoins TRUE TRUE sanity check on default selectivity for like/range predicate
_optim_adjust_for_part_skews TRUE TRUE adjust stats for skews across partitions
_optim_dict_stats_at_db_cr_upg TRUE TRUE enable/disable dictionary stats gathering at db create/upgrade
_optim_enhance_nnull_detection TRUE TRUE TRUE to enable index [fast] full scan more often
_optim_new_default_join_sel TRUE TRUE improves the way default equijoin selectivity are computed
_optim_peek_user_binds TRUE TRUE enable peeking of user binds
_optimizer_adjust_for_nulls TRUE TRUE adjust selectivity for null values
_optimizer_autostats_job TRUE TRUE enable/disable auto stats collection job
_optimizer_better_inlist_costing ALL TRUE enable improved costing of index access using in-list(s)
_optimizer_block_size 8192 TRUE standard block size used by optimizer
_optimizer_cache_stats FALSE TRUE cost with cache statistics
_optimizer_cartesian_enabled TRUE TRUE optimizer cartesian join enabled
_optimizer_cbqt_factor 50 TRUE cost factor for cost-based query transformation
_optimizer_cbqt_no_size_restriction TRUE TRUE disable cost based transformation query size restriction
_optimizer_ceil_cost TRUE TRUE CEIL cost in CBO
_optimizer_choose_permutation 0 TRUE force the optimizer to use the specified permutation
_optimizer_complex_pred_selectivity TRUE TRUE enable selectivity estimation for builtin functions
_optimizer_compute_index_stats TRUE TRUE force index stats collection on index creation/rebuild
_optimizer_connect_by_combine_sw TRUE TRUE combine no filtering connect by and start with
_optimizer_connect_by_cost_based TRUE TRUE use cost-based transformation for connect by
_optimizer_correct_sq_selectivity TRUE TRUE force correct computation of subquery selectivity
_optimizer_cost_based_transformation LINEAR TRUE enables cost-based query transformation
_optimizer_cost_filter_pred FALSE TRUE enables costing of filter predicates in IO cost model
_optimizer_cost_hjsmj_multimatch TRUE TRUE add cost of generating result set when #rows per key > 1
_optimizer_cost_model CHOOSE TRUE optimizer cost model
_optimizer_degree 0 TRUE force the optimizer to use the same degree of parallelism
_optimizer_dim_subq_join_sel TRUE TRUE use join selectivity in choosing star transformation dimensions
_optimizer_disable_strans_sanity_checks 0 TRUE disable star transformation sanity checks
_optimizer_dyn_smp_blks 32 TRUE number of blocks for optimizer dynamic sampling
_optimizer_enable_density_improvements FALSE TRUE use improved density computation for selectivity estimation
_optimizer_enhanced_filter_push TRUE TRUE push filters before trying cost-based query transformation
_optimizer_extended_cursor_sharing UDO TRUE optimizer extended cursor sharing
_optimizer_filter_pred_pullup TRUE TRUE use cost-based flter predicate pull up transformation
_optimizer_fkr_index_cost_bias 10 TRUE Optimizer index bias over FTS/IFFS under first K rows mode
_optimizer_ignore_hints FALSE TRUE enables the embedded hints to be ignored
_optimizer_invalidation_period 18000 TRUE time window for invalidation of cursors of analyzed objects
_optimizer_join_elimination_enabled TRUE TRUE optimizer join elimination enabled
_optimizer_join_order_control 3 TRUE controls the optimizer join order search algorithm
_optimizer_join_sel_sanity_check TRUE TRUE enable/disable sanity check for multi-column join selectivity
_optimizer_max_permutations 2000 TRUE optimizer maximum join permutations per query block
_optimizer_min_cache_blocks 10 TRUE set minimum cached blocks
_optimizer_mjc_enabled TRUE TRUE enable merge join cartesian
_optimizer_mode_force TRUE TRUE force setting of optimizer mode for user recursive SQL also
_optimizer_multiple_cenv Null value TRUE generate and run plans using several compilation environments
_optimizer_native_full_outer_join off TRUE execute full outer join using native implementaion
_optimizer_new_join_card_computation TRUE TRUE compute join cardinality using non-rounded input values
_optimizer_or_expansion DEPTH TRUE control or expansion approach used
_optimizer_or_expansion_subheap TRUE TRUE Use subheap for optimizer or-expansion
_optimizer_order_by_elimination_enabled TRUE TRUE Eliminates order bys from views before query transformation
_optimizer_outer_to_anti_enabled TRUE TRUE Enable transformation of outer-join to anti-join if possible
_optimizer_percent_parallel 101 TRUE optimizer percent parallel
_optimizer_push_down_distinct 0 TRUE push down distinct from query block to table
_optimizer_push_pred_cost_based TRUE TRUE use cost-based query transformation for push pred optimization
_optimizer_random_plan 0 TRUE optimizer seed value for random plans
_optimizer_rownum_bind_default 10 TRUE Default value to use for rownum bind
_optimizer_rownum_pred_based_fkr TRUE TRUE enable the use of first K rows due to rownum predicate
_optimizer_save_stats TRUE TRUE enable/disable saving old versions of optimizer stats
_optimizer_search_limit 5 TRUE optimizer search limit
_optimizer_self_induced_cache_cost FALSE TRUE account for self-induced caching
_optimizer_skip_scan_enabled TRUE TRUE enable/disable index skip scan
_optimizer_skip_scan_guess FALSE TRUE consider index skip scan for predicates with guessed selectivity
_optimizer_sortmerge_join_enabled TRUE TRUE enable/disable sort-merge join method
_optimizer_sortmerge_join_inequality TRUE TRUE enable/disable sort-merge join using inequality predicates
_optimizer_squ_bottomup TRUE TRUE enables unnesting of subquery in a bottom-up manner
_optimizer_star_tran_in_with_clause TRUE TRUE enable/disable star transformation in with clause queries
_optimizer_star_trans_min_cost 0 TRUE optimizer star transformation minimum cost
_optimizer_star_trans_min_ratio 0 TRUE optimizer star transformation minimum ratio
_optimizer_starplan_enabled TRUE TRUE optimizer star plan enabled
_optimizer_system_stats_usage TRUE TRUE system statistics usage
_optimizer_trace none TRUE optimizer trace parameter
_optimizer_transitivity_retain TRUE TRUE retain equi-join pred upon transitive equality pred generation
_optimizer_undo_changes FALSE TRUE undo changes to query optimizer
_optimizer_undo_cost_change 10.2.0.4 TRUE optimizer undo cost change
_optimizer_use_histograms TRUE TRUE Controls whether to use histograms
_optimizer_use_subheap TRUE TRUE Enables physical optimizer subheap
_or_expand_nvl_predicate TRUE TRUE enable OR expanded plan for NVL/DECODE predicate
_oradbg_pathname Null value TRUE path of oradbg script
_oradebug_force FALSE TRUE force target processes to execute oradebug commands?
_ordered_nested_loop TRUE TRUE enable ordered nested loop costing
_ordered_semijoin TRUE TRUE enable ordered semi-join subquery
_os_sched_high_priority 1 TRUE OS high priority level
_other_wait_event_exclusion Null value TRUE exclude event names from _other_wait_threshold calculations
_other_wait_threshold 0 TRUE threshold wait percentage for event wait class Other
_outline_bitmap_tree TRUE TRUE BITMAP_TREE hint enabled in outline
_parallel_adaptive_max_users 2 TRUE maximum number of users running with default DOP
_parallel_broadcast_enabled TRUE TRUE enable broadcasting of small inputs to hash and sort merge joins
_parallel_default_max_instances 1 TRUE default maximum number of instances for parallel query
_parallel_execution_message_align FALSE TRUE Alignment of PX buffers to OS page boundary
_parallel_fake_class_pct 0 TRUE fake db-scheduler percent used for testing
_parallel_fixwrite_bucket 1000 TRUE Number of buckets for each round of fix write
_parallel_load_bal_unit 0 TRUE number of threads to allocate per instance
_parallel_load_balancing TRUE TRUE parallel execution load balanced slave allocation
_parallel_min_message_pool 1076000 TRUE minimum size of shared pool memory to reserve for pq servers
_parallel_recovery_stopat 32767 TRUE stop at -position- to step through SMON
_parallel_replay_msg_limit 4000 TRUE Number of messages for each round of parallel replay
_parallel_server_idle_time 30000 TRUE idle time before parallel query server dies (in 1/100 sec)
_parallel_server_sleep_time 10 TRUE sleep time between dequeue timeouts (in 1/100ths)
_parallel_slave_acquisition_wait 1 TRUE time(in seconds) to wait before retrying slave acquisition
_parallel_txn_global FALSE TRUE enable parallel_txn hint with updates and deletes
_parallelism_cost_fudge_factor 350 TRUE set the parallelism cost fudge factor
_parameter_table_block_size 2048 TRUE parameter table block size
_partial_pwise_join_enabled TRUE TRUE enable partial partition-wise join when TRUE
_partition_view_enabled TRUE TRUE enable/disable partitioned views
_passwordfile_enqueue_timeout 900 TRUE password file enqueue timeout in seconds
_pct_refresh_double_count_prevented TRUE TRUE materialized view PCT refreshes avoid double counting
_pdml_gim_sampling 5000 TRUE control separation of global index maintenance for PDML
_pdml_gim_staggered FALSE TRUE slaves start on different index when doing index maint
_pdml_slaves_diff_part TRUE TRUE slaves start on different partition when doing index maint
_percent_flashback_buf_partial_full 50 TRUE Percent of flashback buffer filled to be considered partial full
_pga_large_extent_size 1048576 TRUE PGA large extent size
_pga_max_size 377487360 TRUE Maximum size of the PGA memory for one process
_ping_level 3 TRUE fusion ping level
_pkt_enable FALSE TRUE enable progressive kill test
_pkt_pmon_interval 50 TRUE PMON process clean-up interval (cs)
_pkt_start FALSE TRUE start progressive kill test instrumention
_plan_outline_data TRUE TRUE explain plan outline data enabled
_plsql_anon_block_code_type INTERPRETED TRUE PL/SQL anonymous block code-type
_plsql_cache_enable TRUE TRUE PL/SQL Function Cache Enabled
_plsql_dump_buffer_events Null value TRUE conditions upon which the PL/SQL circular buffer is dumped
_plsql_minimum_cache_hit_percent 20 TRUE plsql minimum cache hit percentage required to keep caching active
_plsql_nvl_optimize FALSE TRUE PL/SQL NVL optimize
_pmon_load_constants 300,192,64,3,10,10,0,0 TRUE server load balancing constants (S,P,D,I,L,C,M)
_pre_rewrite_push_pred TRUE TRUE push predicates into views before rewrite
_precompute_gid_values TRUE TRUE precompute gid values and copy them before returning a row
_pred_move_around TRUE TRUE enables predicate move-around
_predicate_elimination_enabled TRUE TRUE allow predicate elimination if set to TRUE
_prescomm FALSE TRUE presume commit of IMU transactions
_print_refresh_schedule false TRUE enable dbms_output of materialized view refresh schedule
_private_memory_address Null value TRUE Start address of large extent memory segment
_project_view_columns TRUE TRUE enable projecting out unreferenced columns of a view
_projection_pushdown TRUE TRUE projection pushdown
_projection_pushdown_debug 0 TRUE level for projection pushdown debugging
_push_join_predicate TRUE TRUE enable pushing join predicate inside a view
_push_join_union_view TRUE TRUE enable pushing join predicate inside a union all view
_push_join_union_view2 TRUE TRUE enable pushing join predicate inside a union view
_px_async_getgranule FALSE TRUE asynchronous get granule in the slave
_px_bind_peek_sharing TRUE TRUE enables sharing of px cursors that were built using bind peeking
_px_broadcast_fudge_factor 100 TRUE set the tq broadcasting fudge factor percentage
_px_buffer_ttl 30 TRUE ttl for px mesg buffers in seconds
_px_compilation_debug 0 TRUE debug level for parallel compilation
_px_compilation_trace 0 TRUE tracing level for parallel compilation
_px_dynamic_opt TRUE TRUE turn off/on restartable qerpx dynamic optimization
_px_dynamic_sample_size 50 TRUE num of samples for restartable qerpx dynamic optimization
_px_granule_size 100000 TRUE default size of a rowid range granule (in KB)
_px_index_sampling 200 TRUE parallel query sampling for index create (100000 = 100%)
_px_kxib_tracing 0 TRUE turn on kxib tracing
_px_load_publish_interval 200 TRUE interval at which LMON will check whether to publish PX load
_px_loc_msg_cost 1000 TRUE CPU cost to send a PX message via shared memory
_px_max_granules_per_slave 100 TRUE maximum number of rowid range granules to generate per slave
_px_min_granules_per_slave 13 TRUE minimum number of rowid range granules to generate per slave
_px_minus_intersect TRUE TRUE enables pq for minus/interect operators
_px_net_msg_cost 10000 TRUE CPU cost to send a PX message over the internconnect
_px_no_granule_sort FALSE TRUE prevent parallel partition granules to be sorted on size
_px_no_stealing FALSE TRUE prevent parallel granule stealing in shared nothing environment
_px_nss_planb TRUE TRUE enables or disables NSS Plan B reparse with outline
_px_proc_constrain TRUE TRUE reduce parallel_max_servers if greater than (processes - fudge)
_px_pwg_enabled TRUE TRUE parallel partition wise group by enabled
_px_rownum_pd TRUE TRUE turn off/on parallel rownum pushdown optimization
_px_send_timeout 300 TRUE IPC message send timeout value in seconds
_px_slaves_share_cursors 0 TRUE slaves share cursors with QC
_px_trace none TRUE px trace parameter
_px_ual_serial_input TRUE TRUE enables new pq for UNION operators
_px_xtgranule_size 10000 TRUE default size of a external table granule (in KB)
_qa_control 0 TRUE Oracle internal parameter to control QA
_qa_lrg_type 0 TRUE Oracle internal parameter to specify QA lrg type
_query_cost_rewrite TRUE TRUE perform the cost based rewrite with materialized views
_query_execution_cache_max_size 65536 TRUE max size of query execution cache
_query_rewrite_1 TRUE TRUE perform query rewrite before&after or only before view merging
_query_rewrite_2 TRUE TRUE perform query rewrite before&after or only after view merging
_query_rewrite_drj TRUE TRUE mv rewrite and drop redundant joins
_query_rewrite_expression TRUE TRUE rewrite with cannonical form for expressions
_query_rewrite_fpc TRUE TRUE mv rewrite fresh partition containment
_query_rewrite_fudge 90 TRUE cost based query rewrite with MVs fudge factor
_query_rewrite_jgmigrate TRUE TRUE mv rewrite with jg migration
_query_rewrite_maxdisjunct 257 TRUE query rewrite max disjuncts
_query_rewrite_or_error FALSE TRUE allow query rewrite, if referenced tables are not dataless
_query_rewrite_setopgrw_enable TRUE TRUE perform general rewrite using set operator summaries
_query_rewrite_vop_cleanup TRUE TRUE prune frocol chain before rewrite after view-merging
_rcfg_disable_verify FALSE TRUE if TRUE disables verify at reconfiguration
_rcfg_parallel_fixwrite TRUE TRUE if TRUE enables parallel fixwrite at reconfiguration
_rcfg_parallel_replay TRUE TRUE if TRUE enables parallel replay and cleanup at reconfiguration
_rcfg_parallel_verify TRUE TRUE if TRUE enables parallel verify at reconfiguration
_real_time_apply_arch_delay 0 TRUE Archival delay with real time apply
_real_time_apply_sim 0 TRUE Simulation value with real time apply
_realfree_heap_max_size 32768 TRUE minimum max total heap size, in Kbytes
_realfree_heap_mode 0 TRUE mode flags for real-free heap
_realfree_heap_pagesize_hint 65536 TRUE hint for real-free page size in bytes
_recoverable_recovery_batch_percent 50 TRUE Recoverable recovery batch size (percentage of buffer cache)
_recovery_asserts FALSE TRUE if TRUE, enable expensive integrity checks
_recovery_percentage 50 TRUE recovery buffer cache percentage
_recovery_skip_cfseq_check FALSE TRUE allow media recovery even if controlfile seq check fails
_recovery_verify_writes FALSE TRUE enable thread recovery write verify
_recursive_imu_transactions FALSE TRUE recursive transactions may be IMU
_redo_compatibility_check FALSE TRUE general and redo/undo compatibility sanity check
_release_insert_threshold 5 TRUE maximum number of unusable blocks to unlink from freelist
_reliable_block_sends FALSE TRUE if TRUE, block sends across interconnect are reliable
_remove_aggr_subquery TRUE TRUE enables removal of subsumed aggregated subquery
_resource_manager_always_on TRUE TRUE enable the resource manager always
_restore_spfile Null value TRUE restore spfile to this location
_reuse_index_loop 5 TRUE number of blocks being examine for index block reuse
_right_outer_hash_enable TRUE TRUE Right Outer/Semi/Anti Hash Enabled
_rm_numa_sched_enable FALSE TRUE Is Resource Manager (RM) related NUMA scheduled policy enabled
_rm_numa_simulation_cpus 0 TRUE number of cpus per PG for numa simulation in resource manager
_rm_numa_simulation_pgs 0 TRUE number of PGs for numa simulation in resource manager
_rman_io_priority 3 TRUE priority at which rman backup i/o's are done
_rollback_segment_count 0 TRUE number of undo segments
_rollback_segment_initial 1 TRUE starting undo segment number
_rollback_stopat 0 TRUE stop at -position to step rollback
_row_cache_cursors 20 TRUE number of cached cursors for row cache management
_row_cr TRUE TRUE enable row cr for all sql
_row_locking always TRUE row-locking
_row_shipping_explain FALSE TRUE enable row shipping explain plan support
_row_shipping_threshold 80 TRUE row shipping column selection threshold
_rowsource_execution_statistics FALSE TRUE if TRUE, Oracle will collect rowsource statistics
_rowsource_statistics_sampfreq 128 TRUE frequency of rowsource statistic sampling (must be a power of 2)
_rowsrc_trace_level 0 TRUE Row source tree tracing level
_sample_rows_per_block 4 TRUE number of rows per block used for sampling IO optimization
_scatter_gcs_resources FALSE TRUE if TRUE, gcs resources are scattered uniformly across sub pools
_scatter_gcs_shadows FALSE TRUE if TRUE, gcs shadows are scattered uniformly across sub pools
_second_spare_parameter Null value TRUE second spare parameter - integer
_selfjoin_mv_duplicates TRUE TRUE control rewrite self-join algorithm
_selftune_checkpoint_write_pct 3 TRUE Percentage of total physical i/os for self-tune ckpt
_selftune_checkpointing_lag 300 TRUE Self-tune checkpointing lag the tail of the redo log
_send_ast_to_foreground TRUE TRUE if TRUE, send ast message to foreground
_send_close_with_block TRUE TRUE if TRUE, send close with block even with direct sends
_send_requests_to_pi TRUE TRUE if TRUE, try to send CR requests to PI buffers
_serial_direct_read FALSE TRUE enable direct read in serial
_serial_recovery FALSE TRUE force serial recovery or parallel recovery
_serializable FALSE TRUE serializable
_session_cached_instantiations 60 TRUE Number of pl/sql instantiations to cache in a session.
_session_context_size 10000 TRUE session app context size
_session_idle_bit_latches 0 TRUE one latch per session or a latch per group of sessions
_session_idle_check_interval 60 TRUE Resource Manager session idle limit check interval in seconds
_session_kept_cursor_pins 0 TRUE Number of cursors pins to keep in a session
_session_wait_history 10 TRUE enable session wait history collection
_seventh_spare_parameter Null value TRUE seventh spare parameter - string list
_shared_pool_max_size 0 TRUE shared pool maximum size when auto SGA enabled
_shared_pool_minsize_on FALSE TRUE shared pool minimum size when auto SGA enabled
_shared_pool_reserved_min_alloc 4400 TRUE minimum allocation size in bytes for reserved area of shared pool
_shared_pool_reserved_pct 5 TRUE percentage memory of the shared pool allocated for the reserved area
_shared_server_spare_param1 Null value TRUE _shared_server_spare_param1
_shared_server_spare_param2 Null value TRUE _shared_server_spare_param2
_shared_server_spare_param3 Null value TRUE _shared_server_spare_param3
_short_stack_timeout_ms 30000 TRUE short stack timeout in ms
_shrunk_aggs_disable_threshold 60 TRUE percentage of exceptions at which to switch to full length aggs
_shrunk_aggs_enabled TRUE TRUE enable use of variable sized buffers for non-distinct aggregates
_side_channel_batch_size 200 TRUE number of messages to batch in a side channel message (DFS)
_side_channel_batch_timeout 6 TRUE timeout before shipping out the batched side channelmessages in seconds
_side_channel_batch_timeout_ms 500 TRUE timeout before shipping out the batched side channelmessages in milliseconds
_simple_view_merging TRUE TRUE control simple view merging performed by the optimizer
_simulator_bucket_mindelta 8192 TRUE LRU bucket minimum delta
_simulator_internal_bound 10 TRUE simulator internal bound percent
_simulator_lru_rebalance_sizthr 2 TRUE LRU list rebalance threshold (size)
_simulator_lru_rebalance_thresh 10240 TRUE LRU list rebalance threshold (count)
_simulator_lru_scan_count 8 TRUE LRU scan count
_simulator_pin_inval_maxcnt 16 TRUE maximum count of invalid chunks on pin list
_simulator_reserved_heap_count 4096 TRUE simulator reserved heap count
_simulator_reserved_obj_count 1024 TRUE simulator reserved object count
_simulator_sampling_factor 2 TRUE sampling factor for the simulator
_simulator_upper_bound_multiple 2 TRUE upper bound multiple of pool size
_single_process FALSE TRUE run without detached processes
_sixth_spare_parameter Null value TRUE sixth spare parameter - string list
_skgxp_reaping 1000 TRUE tune skgxp OSD reaping limit
_skgxp_udp_ach_reaping_time 0 TRUE time in minutes before idle ach's are reaped
_skgxp_udp_hiwat_warn 1000 TRUE ach hiwat mark warning interval
_skgxp_udp_interface_detection_time_secs 60 TRUE time in seconds between interface detection checks
_skgxp_udp_keep_alive_ping_timer_secs 300 TRUE connection idle time in seconds before keep alive is initiated. min: 30 sec max: 1800 sec default: 300 sec
_skgxp_udp_lmp_mtusize 0 TRUE MTU size for UDP LMP testing
_skgxp_udp_lmp_on FALSE TRUE enable UDP long message protection
_skgxp_udp_timed_wait_buffering 1024 TRUE diagnostic log buffering space (in bytes) for timed wait (0 means unbufferd
_skgxp_udp_timed_wait_seconds 5 TRUE time in seconds before timed wait is invoked
_skip_assume_msg TRUE TRUE if TRUE, skip assume message for consigns at the master
_slave_mapping_enabled TRUE TRUE enable slave mapping when TRUE
_slave_mapping_group_size 0 TRUE force the number of slave group in a slave mapper
_small_table_threshold 18563 TRUE threshold level of table size for direct reads
_smm_advice_enabled TRUE TRUE if TRUE, enable v$pga_advice
_smm_advice_log_size 0 TRUE overwrites default size of the PGA advice workarea history log
_smm_auto_cost_enabled TRUE TRUE if TRUE, use the AUTO size policy cost functions
_smm_auto_max_io_size 248 TRUE Maximum IO size (in KB) used by sort/hash-join in auto mode
_smm_auto_min_io_size 56 TRUE Minimum IO size (in KB) used by sort/hash-join in auto mode
_smm_bound 0 TRUE overwrites memory manager automatically computed bound
_smm_control 0 TRUE provides controls on the memory manager
_smm_freeable_retain 5120 TRUE value in KB of the instance freeable PGA memory to retain
_smm_isort_cap 102400 TRUE maximum work area for insertion sort(v1)
_smm_max_size 184320 TRUE maximum work area size in auto mode (serial)
_smm_min_size 1024 TRUE minimum work area size in auto mode
_smm_px_max_size 921600 TRUE maximum work area size in auto mode (global)
_smm_retain_size 0 TRUE work area retain size in SGA for shared server sessions (0 for AUTO)
_smm_trace 0 TRUE Turn on/off tracing for SQL memory manager
_smon_internal_errlimit 100 TRUE limit of SMON internal errors
_smon_undo_seg_rescan_limit 10 TRUE limit of SMON continous undo segments re-scan
_smu_debug_mode 0 TRUE <debug-flag> - set debug event for testing SMU operations
_smu_error_simulation_site 0 TRUE site ID of error simulation in KTU code
_smu_error_simulation_type 0 TRUE error type for error simulation in KTU code
_smu_timeouts Null value TRUE comma-separated *AND double-quoted* list of AUM timeouts: mql, tur, sess_exprn, qry_exprn, slot_intvl
_sort_elimination_cost_ratio 0 TRUE cost ratio for sort eimination under first_rows mode
_sort_multiblock_read_count 2 TRUE multi-block read count for sort
_spin_count 2000 TRUE Amount to spin waiting for a latch
_spr_max_rules 10000 TRUE maximum number of rules in sql spreadsheet
_spr_push_pred_refspr TRUE TRUE push predicates through reference spreadsheet
_spr_use_AW_AS TRUE TRUE enable AW for hash table in spreadsheet
_spr_use_hash_table FALSE TRUE use hash table for spreadsheet
_sql_connect_capability_override 0 TRUE SQL Connect Capability Table Override
_sql_connect_capability_table Null value TRUE SQL Connect Capability Table (testing only)
_sql_hash_debug 0 TRUE Hash value of the SQL statement to debug
_sql_model_unfold_forloops RUN_TIME TRUE specifies compile-time unfolding of sql model forloops
_sqlexec_progression_cost 1000 TRUE sql execution progression monitoring cost threshold
_sqltune_category_parsed DEFAULT TRUE Parsed category qualifier for applying hintsets
_sta_control 0 TRUE SQL Tuning Advisory control parameter
_stack_guard_level 0 TRUE stack guard level
_static_backgrounds Null value TRUE static backgrounds
_stn_trace 0 TRUE SQL tracing parameter
_streams_pool_max_size 0 TRUE streams pool maximum size when auto SGA enabled
_subquery_pruning_cost_factor 20 TRUE subquery pruning cost factor
_subquery_pruning_enabled TRUE TRUE enable the use of subquery predicates to perform pruning
_subquery_pruning_mv_enabled FALSE TRUE enable the use of subquery predicates with MVs to perform pruning
_subquery_pruning_reduction 50 TRUE subquery pruning reduction factor
_swrf_metric_frequent_mode FALSE TRUE Enable/disable SWRF Metric Frequent Mode Collection
_swrf_mmon_dbfus TRUE TRUE Enable/disable SWRF MMON DB Feature Usage
_swrf_mmon_flush TRUE TRUE Enable/disable SWRF MMON FLushing
_swrf_mmon_metrics TRUE TRUE Enable/disable SWRF MMON Metrics Collection
_swrf_on_disk_enabled TRUE TRUE Parameter to enable/disable SWRF
_swrf_test_action 0 TRUE test action parameter for SWRF
_swrf_test_dbfus FALSE TRUE Enable/disable DB Feature Usage Testing
_synonym_repoint_tracing FALSE TRUE whether to trace metadata comparisons for synonym repointing
_sysaux_test_param 1 TRUE test parameter for SYSAUX
_system_index_caching 0 TRUE optimizer percent system index caching
_system_trig_enabled TRUE TRUE are system triggers enabled
_ta_lns_wait_for_arch_log 20 TRUE LNS Wait time for arhcived version of online log
_table_lookup_prefetch_size 40 TRUE table lookup prefetch vector size
_table_lookup_prefetch_thresh 2 TRUE table lookup prefetch threshold
_table_scan_cost_plus_one TRUE TRUE bump estimated full table scan and index ffs cost by one
_target_rba_max_lag_percentage 90 TRUE target rba max log lag percentage
_tdb_debug_mode 16 TRUE set debug mode for testing transportable database
_temp_tran_block_threshold 100 TRUE number of blocks for a dimension before we temp transform
_temp_tran_cache TRUE TRUE determines if temp table is created with cache option
_test_ksusigskip 5 TRUE test the function ksusigskip
_test_param_1 25 TRUE test parmeter 1 - integer
_test_param_2 Null value TRUE test parameter 2 - string
_test_param_3 Null value TRUE test parameter 3 - string
_test_param_4 Null value TRUE test parameter 4 - string list
_test_param_5 25 TRUE test parmeter 5 - deprecated integer
_test_param_6 0 TRUE test parmeter 6 - size (ub8)
_third_spare_parameter Null value TRUE third spare parameter - integer
_threshold_alerts_enable 1 TRUE if 1, issue threshold-based alerts
_total_large_extent_memory 0 TRUE Total memory for allocating large extents
_tq_dump_period 0 TRUE time period for duping of TQ statistics (s)
_trace_archive FALSE TRUE start DIAG process
_trace_buffer_flushes FALSE TRUE trace buffer flushes if otrace cacheIO event is set
_trace_buffer_gets FALSE TRUE trace kcb buffer gets if otrace cacheIO event is set
_trace_buffer_wait_timeouts 0 TRUE trace buffer busy wait timeouts
_trace_buffer_wrap_timestamp TRUE TRUE enable KST timestamp on trace buffer wrap
_trace_buffers ALL:256 TRUE trace buffer sizes per process
_trace_cr_buffer_creates FALSE TRUE trace cr buffer creates if otrace cacheIO event is set
_trace_events Null value TRUE trace events enabled at startup
_trace_file_size 65536 TRUE maximum size of trace file (in bytes)
_trace_files_public FALSE TRUE Create publicly accessible trace files
_trace_flush_processes ALL TRUE trace data archived by DIAG for these processes
_trace_multi_block_reads FALSE TRUE trace multi_block reads if otrace cacheIO event is set
_trace_navigation_scope global TRUE enabling trace navigation linking
_trace_options text,multiple TRUE trace data flush options
_trace_pin_time 0 TRUE trace how long a current pin is held
_trace_processes ALL TRUE enable KST tracing in process
_transaction_auditing TRUE TRUE transaction auditing records generated in the redo log
_transaction_recovery_servers 0 TRUE max number of parallel recovery slaves that may be used
_truncate_optimization_enabled TRUE TRUE do truncate optimization if set to TRUE
_tsm_connect_string Null value TRUE TSM test connect string
_tsm_disable_auto_cleanup 1 TRUE Disable TSM auto cleanup actions
_tts_allow_charset_mismatch FALSE TRUE allow plugging in a tablespace with an incompatible character set
_two_pass TRUE TRUE enable two-pass thread recovery
_two_pass_reverse_polish_enabled TRUE TRUE uses two-pass reverse polish alg. to generate canonical forms
_uga_cga_large_extent_size 262144 TRUE UGA/CGA large extent size
_ultrafast_latch_statistics TRUE TRUE maintain fast-path statistics for ultrafast latches
_undo_autotune TRUE TRUE enable auto tuning of undo_retention
_undo_debug_mode 0 TRUE debug flag for undo related operations
_undo_debug_usage 0 TRUE invoke undo usage functions for testing
_union_rewrite_for_gs YES_GSET_MVS TRUE expand queries with GSets into UNIONs for rewrite
_unnest_subquery TRUE TRUE enables unnesting of correlated subqueries
_unused_block_compression TRUE TRUE enable unused block compression
_use_column_stats_for_function TRUE TRUE enable the use of column statistics for DDP functions
_use_ism TRUE TRUE Enable Shared Page Tables - ISM
_use_ism_for_pga TRUE TRUE Use ISM for allocating large extents
_use_nosegment_indexes FALSE TRUE use nosegment indexes in explain plan
_use_realfree_heap TRUE TRUE use real-free based allocator for PGA memory
_use_seq_process_cache TRUE TRUE whether to use process local seq cache
_use_vector_post TRUE TRUE use vector post
_validate_flashback_database FALSE TRUE Scan database to validate result of flashback database
_vendor_lib_loc Null value TRUE Vendor library search root directory
_verify_flashback_redo TRUE TRUE Verify that the redo logs needed for flashback are available
_verify_undo_quota FALSE TRUE TRUE - verify consistency of undo quota statistics
_very_large_partitioned_table 1024 TRUE very_large_partitioned_table
_wait_for_sync TRUE TRUE wait for sync on commit MUST BE ALWAYS TRUE
_walk_insert_threshold 0 TRUE maximum number of unusable blocks to walk across freelist
_watchpoint_on FALSE TRUE is the watchpointing feature turned on?
_wcr_control 0 TRUE Oracle internal test WCR parameter used ONLY for testing!
_windowfunc_optimization_settings 0 TRUE settings for window function optimizations
_write_clones 3 TRUE write clones flag
_xpl_peeked_binds_log_size 8192 TRUE maximum bytes for logging peeked bind values for V$SQL_PLAN (0 = OFF)
_xpl_trace 0 TRUE Explain Plan tracing parameter
_xsolapi_auto_materialization_bound 20 TRUE OLAP API lower bound for auto materialization.
_xsolapi_auto_materialization_type PRED_AND_RC TRUE OLAP API behavior for auto materialization
_xsolapi_debug_output Null value TRUE OLAP API debug output disposition
_xsolapi_densify_cubes TABULAR TRUE OLAP API cube densification
_xsolapi_dimension_group_creation OVERFETCH TRUE OLAP API symmetric overfetch
_xsolapi_fetch_type PARTIAL TRUE OLAP API fetch type
_xsolapi_generate_with_clause FALSE TRUE OLAP API generates WITH clause?
_xsolapi_hierarchy_value_type unique TRUE OLAP API hierarchy value type
_xsolapi_load_at_process_start NEVER TRUE When to load OLAP API library at server process start
_xsolapi_materialization_rowcache_min_rows_for_use 1 TRUE OLAP API min number of rows required to use rowcache in query materialization
_xsolapi_materialize_sources TRUE TRUE OLAP API Enable source materialization
_xsolapi_metadata_reader_mode ALL TRUE OLAP API metadata reader mode
_xsolapi_odbo_mode FALSE TRUE OLAP API uses ODBO mode?
_xsolapi_optimize_suppression TRUE TRUE OLAP API optimizes suppressions?
_xsolapi_precompute_subquery TRUE TRUE OLAP API precomputes subqueries?
_xsolapi_remove_columns_for_materialization TRUE TRUE OLAP API removes columns for materialization?
_xsolapi_set_nls TRUE TRUE OLAP API sets NLS?
_xsolapi_share_executors TRUE TRUE OLAP API share executors?
_xsolapi_source_trace FALSE TRUE OLAP API output Source definitions to trace file
_xsolapi_sql_all_multi_join_non_base_hints Null value TRUE OLAP API multi-join non-base hints
_xsolapi_sql_all_non_base_hints Null value TRUE OLAP API non-base hints
_xsolapi_sql_auto_dimension_hints FALSE TRUE OLAP API enable automatic dimension hints
_xsolapi_sql_auto_measure_hints TRUE TRUE OLAP API enable automatic measure hints
_xsolapi_sql_dimension_hints Null value TRUE OLAP API dimension hints
_xsolapi_sql_enable_aw_join TRUE TRUE OLAP API enables AW join?
_xsolapi_sql_enable_aw_qdr_merge TRUE TRUE OLAP API enables AW QDR merge?
_xsolapi_sql_hints Null value TRUE OLAP API generic hints
_xsolapi_sql_measure_hints Null value TRUE OLAP API measure hints
_xsolapi_sql_minus_threshold 1000 TRUE OLAP API SQL MINUS threshold
_xsolapi_sql_optimize TRUE TRUE OLAP API enable optimization
_xsolapi_sql_prepare_stmt_cache_size 16 TRUE OLAP API prepare statement cache size
_xsolapi_sql_remove_columns TRUE TRUE OLAP API enable remove unused columns optimizations
_xsolapi_sql_result_set_cache_size 32 TRUE OLAP API result set cache size
_xsolapi_sql_symmetric_predicate TRUE TRUE OLAP API enable symmetric predicate for dimension groups
_xsolapi_sql_top_dimension_hints Null value TRUE OLAP API top dimension hints
_xsolapi_sql_top_measure_hints Null value TRUE OLAP API top measure hints
_xsolapi_sql_use_bind_variables TRUE TRUE OLAP API enable bind variables optimization
_xsolapi_stringify_order_levels FALSE TRUE OLAP API stringifies order levels?
_xsolapi_suppression_aw_mask_threshold 1000 TRUE OLAP API suppression AW mask threshold
_xsolapi_suppression_chunk_size 4000 TRUE OLAP API suppression chunk size
_xsolapi_use_models TRUE TRUE OLAP API uses models?
_xsolapi_use_olap_dml TRUE TRUE OLAP API uses OLAP DML?
_xsolapi_use_olap_dml_for_rank FALSE TRUE OLAP API uses OLAP DML for rank?
_xt_coverage none TRUE external tables code coverage parameter
_xt_trace none TRUE external tables trace parameter
_xtbuffer_size 0 TRUE buffer size in KB needed for populate/query operation
_xtts_allow_pre10 FALSE TRUE allow cross platform for pre10 compatible tablespace
_xtts_set_platform_info FALSE TRUE set cross platform info during file header read
_yield_check_interval 100000 TRUE interval to check whether actses should yield

Back to top