<!-- Oracle Remote Diagnostic Agent / Data Collection Results 4.17 -->
<!-- Module:S201DBA Version:1.57 Report:vparameters OS:linux -->
---+!! Database Parameters
%TOC%
---+ 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%|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|
[[#Top][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%|TRUE|FALSE|
|aq_tm_processes|0|TRUE|FALSE|
|archive_lag_target|0|TRUE|FALSE|
|asm_diskgroups|%NULL%|TRUE|FALSE|
|asm_diskstring|%NULL%|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%|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%|TRUE|FALSE|
|buffer_pool_recycle|%NULL%|TRUE|FALSE|
|circuits|%NULL%|TRUE|FALSE|
|cluster_database|FALSE|TRUE|FALSE|
|cluster_database_instances|1|TRUE|FALSE|
|cluster_interconnects|%NULL%|TRUE|FALSE|
|commit_point_strength|1|TRUE|FALSE|
|commit_write|%NULL%|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%|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%|TRUE|FALSE|
|db_create_online_log_dest_1|%NULL%|TRUE|FALSE|
|db_create_online_log_dest_2|%NULL%|TRUE|FALSE|
|db_create_online_log_dest_3|%NULL%|TRUE|FALSE|
|db_create_online_log_dest_4|%NULL%|TRUE|FALSE|
|db_create_online_log_dest_5|%NULL%|TRUE|FALSE|
|db_domain|%NULL%|FALSE|FALSE|
|db_file_multiblock_read_count|16|FALSE|FALSE|
|db_file_name_convert|%NULL%|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%|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%|TRUE|FALSE|
|filesystemio_options|none|TRUE|FALSE|
|fixed_date|%NULL%|TRUE|FALSE|
|gc_files_to_locks|%NULL%|TRUE|FALSE|
|gcs_server_processes|0|TRUE|FALSE|
|global_context_pool_size|%NULL%|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%|TRUE|FALSE|
|instance_groups|%NULL%|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%|TRUE|FALSE|
|lock_sga|FALSE|TRUE|FALSE|
|log_archive_config|DG_CONFIG=(pcard,pcarddr)|FALSE|FALSE|
|log_archive_dest|%NULL%|TRUE|FALSE|
|log_archive_dest_1|LOCATION=/dbpcardarch/pcard1/PCARD/archivelog|FALSE|FALSE|
|log_archive_dest_10|%NULL%|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%|TRUE|FALSE|
|log_archive_dest_4|%NULL%|TRUE|FALSE|
|log_archive_dest_5|%NULL%|TRUE|FALSE|
|log_archive_dest_6|%NULL%|TRUE|FALSE|
|log_archive_dest_7|%NULL%|TRUE|FALSE|
|log_archive_dest_8|%NULL%|TRUE|FALSE|
|log_archive_dest_9|%NULL%|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%|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%|TRUE|FALSE|
|logmnr_max_persistent_sessions|1|TRUE|FALSE|
|max_commit_propagation_delay|0|TRUE|FALSE|
|max_dispatchers|%NULL%|TRUE|FALSE|
|max_dump_file_size|UNLIMITED|TRUE|FALSE|
|max_enabled_roles|150|TRUE|FALSE|
|max_shared_servers|%NULL%|TRUE|FALSE|
|nls_calendar|%NULL%|TRUE|FALSE|
|nls_comp|%NULL%|TRUE|FALSE|
|nls_currency|%NULL%|TRUE|FALSE|
|nls_date_format|%NULL%|TRUE|FALSE|
|nls_date_language|%NULL%|TRUE|FALSE|
|nls_dual_currency|%NULL%|TRUE|FALSE|
|nls_iso_currency|%NULL%|TRUE|FALSE|
|nls_language|AMERICAN|TRUE|FALSE|
|nls_length_semantics|BYTE|TRUE|FALSE|
|nls_nchar_conv_excp|FALSE|TRUE|FALSE|
|nls_numeric_characters|%NULL%|TRUE|FALSE|
|nls_sort|%NULL%|TRUE|FALSE|
|nls_territory|AMERICA|TRUE|FALSE|
|nls_time_format|%NULL%|TRUE|FALSE|
|nls_time_tz_format|%NULL%|TRUE|FALSE|
|nls_timestamp_format|%NULL%|TRUE|FALSE|
|nls_timestamp_tz_format|%NULL%|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%|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%|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%|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%|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%|TRUE|FALSE|
|resumable_timeout|0|TRUE|FALSE|
|rollback_segments|%NULL%|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%|TRUE|FALSE|
|shared_servers|1|TRUE|FALSE|
|skip_unusable_indexes|TRUE|TRUE|FALSE|
|smtp_out_server|%NULL%|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%|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%|TRUE|FALSE|
|workarea_size_policy|AUTO|TRUE|FALSE|
[[#Top][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%|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%|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%|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%|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%|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%|TRUE|control file initial section size|
|_controlfile_section_max_expand|%NULL%|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%|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%|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%|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%|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%|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%|TRUE|scale to display rate statistic (100ths of a second)|
|_dispatcher_rate_ttl|%NULL%|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%|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%|TRUE|fifth spare parameter - string|
|_filemap_dir|%NULL%|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%|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%|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%|TRUE|number of gcs resources to be allocated|
|_gcs_shadow_locks|%NULL%|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%|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%|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%|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%|TRUE|latch class 0|
|_latch_class_1|%NULL%|TRUE|latch class 1|
|_latch_class_2|%NULL%|TRUE|latch class 2|
|_latch_class_3|%NULL%|TRUE|latch class 3|
|_latch_class_4|%NULL%|TRUE|latch class 4|
|_latch_class_5|%NULL%|TRUE|latch class 5|
|_latch_class_6|%NULL%|TRUE|latch class 6|
|_latch_class_7|%NULL%|TRUE|latch class 7|
|_latch_classes|%NULL%|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%|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%|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%|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%|TRUE|Synchronization timeout for DLM reconfiguration steps|
|_lm_ticket_active_sendback|%NULL%|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%|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%|TRUE|offline undo segment list|
|_ogms_home|%NULL%|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%BR%%-8d %-8s %-8b Description%BR%-------- -------- -------- -----------|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%|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%|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%|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%|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%|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%|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%|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%|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%|TRUE|_shared_server_spare_param1|
|_shared_server_spare_param2|%NULL%|TRUE|_shared_server_spare_param2|
|_shared_server_spare_param3|%NULL%|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%|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%|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%|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%|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%|TRUE|test parameter 2 - string|
|_test_param_3|%NULL%|TRUE|test parameter 3 - string|
|_test_param_4|%NULL%|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%|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%|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%|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%|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%|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%|TRUE|OLAP API multi-join non-base hints|
|_xsolapi_sql_all_non_base_hints|%NULL%|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%|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%|TRUE|OLAP API generic hints|
|_xsolapi_sql_measure_hints|%NULL%|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%|TRUE|OLAP API top dimension hints|
|_xsolapi_sql_top_measure_hints|%NULL%|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|
[[#Top][Back to top]]
