oracle 隐含参数

对于oracle，有一些参数参数是隐含的，可能对于大家常规参数都知道什么意思，但是，当oracle需要处理一些不是常规能解决的问题的时候，可能就需要了解隐含参数了，下面这个参数基本包含了oracle所有的隐含参数。这个参是虽然是到oracle 9i，但是oracle10g以后也基本可以使用

O7_DICTIONARY_ACCESSIBILITY803, 804, 805, 806, 815, 816, 817, 901, 920Version 7 Dictionary Accessibility Support_DECUnix_reserved_1732, 803, 804, 805, 806 _DECUnix_reserved_2732, 733, 734, 803, 804, 805, 806 _DECUnix_reserved_3732, 733, 734, 734, 803, 804, 805, 806 _DECUnix_reserved_4732, 733, 734, 734, 803, 804, 805, 806 _DECUnix_reserved_5732, 733, 734, 734, 803, 804, 805, 806 _DECUnix_reserved_6732, 733, 734, 734, 803, 804, 805, 806 _DECUnix_reserved_7732, 733, 734, 734, 803, 804, 805, 806 _NUMA_instance_mapping815, 816, 817, 901, 920Set of nodes that this instance should run on_NUMA_pool_size815, 816, 817, 901, 920aggregate size in bytes of NUMA pool_PX_use_large_pool815, 816, 817, 901, 920Use Large Pool as source of PX buffers_abort_recovery_on_join901, 920if TRUE, abort recovery on join reconfigurations_active_standby_fast_reconfiguration815, 816, 817, 901, 920if TRUE optimize dlm reconfiguration for active/standby OPS_adaptive_direct_read901, 920Adaptive Direct Read_adaptive_fetch_enabled901, 920enable/disable adaptive fetch in parallel group by_advanced_dss_features803, 804, 805, 806, 815, 816, 817, 901enable advanced dss features_affinity_on733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920enable/disable affinity at run time_all_shared_dblinks803, 804, 805, 806, 815, 816, 817, 901, 920treat all dblinks as shared_allocate_creation_order815, 816, 817, 901, 920should files be examined in creation order during allocation_allocation_update_interval901, 920interval at which successful search in L1 should be updated_allow_error_simulation816, 817, 901, 920Allow error simulation for testing_allow_read_only_corruption815, 816, 817, 901, 920allow read-only open even if database is corrupt_allow_resetlogs_corruption716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920allow resetlogs even if it will cause corruption_allow_terminal_recovery_corruption920Finish terminal recovery even if it may cause corruption_always_anti_join901, 920always use this method for anti-join when possible_always_semi_join901, 920always use this method for semi-join when possible_always_star_transformation803, 804, 805, 806, 815, 816, 817, 901, 920always favor use of star transformation_app_ctx_vers920enable app ctx versioning_aq_tm_scanlimit817, 901scan limit for Time Managers to clean up IOT_arch_io_slaves815, 816, 817, 901, 920ARCH I/O slaves_async_bsp816, 817, 901if TRUE, BSP flushes log asynchronously (DFS)_average_dirties_half_life815, 816, 817 _async_recovery_claims901, 920if TRUE, issue recovery claims asynchronouslyif TRUE, issue recovery claims asynchronously (DFS)_async_recovery_reads901, 920if TRUE, issue recovery reads asynchronouslyif TRUE, issue recovery reads asynchronously (DFS)_avoid_prepare901, 920if TRUE, do not prepare a buffer when the master is localif TRUE, do not prepare a buffer when the master is local (DFS)_b_tree_bitmap_plans815, 816, 817, 901, 920enable the use of bitmap plans for tables w. only B-tree indexes_backup_disk_io_slaves815, 816, 817, 901, 920BACKUP Disk I/O slaves_backup_io_pool_size815, 816, 817, 901, 920memory to reserve from the large pool_bsp_log_flush816, 817, 901if TRUE, flush redo log before serving a CR buffer (DFS)_bitmap_or_improvement_enabled920controls extensions to partition pruning for general predicates_bump_highwater_mark_count732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920how many blocks should we allocate per free list on advancing HW_cache_db_files716, 723, 732, 733, 734 _bwr_for_flushed_pi920if TRUE, generate a BWR for a flushed PI (DFS)_cgs_send_timeout901, 920CGS send timeout value_check_block_after_checksum816, 817, 901, 920perform block check after checksum if both are turned on_cleanup_rollback_entries815, 816, 817, 901, 920no. of undo entries to apply per transaction cleanup_close_cached_open_cursors815, 816, 817, 901, 920close cursors cached by PL/SQL at each commit_collect_undo_stats901, 920Collect Statistics v$undostat_column_elimination_off803, 804, 805, 806, 815, 816, 817, 901, 920turn off predicate-only column elimination_column_tracking_level901, 920column usage tracking_compatible_no_recovery815, 816, 817, 901, 920Database will be compatible unless crash or media recovery is ne_complex_view_merging815, 816, 817, 901, 920enable complex view merging_controlfile_enqueue_timeout716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920control file enqueue timeout in seconds_corrupt_blocks_on_stuck_recovery716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _corrupted_rollback_segments716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920corrupted undo segment list_cost_equality_semi_join920enables costing of equality semi-join_cpu_count716, 901, 920current number of cpu's for this instance_cpu_to_io815, 816, 817, 901, 920divisor for converting CPU cost to I/O cost_cr_deadtime733, 734, 803, 804, 805, 806 _cr_server815, 816, 817 _cr_server_extn817 _cr_grant_global_role901, 920if TRUE, grant lock for CR requests when block is in global role_cr_grant_local_role901, 920if TRUE, grant lock for CR using 3way ping when block in local r_cr_server_log_flush920if TRUE, flush redo log before serving a CR buffer (DFS)_cursor_db_buffers_pinned803, 804, 805, 806, 815, 816, 817, 901, 920additional number of buffers a cursor can pin at once_cursor_plan_enabled901, 920enable collection and display of cursor plans_db_aging_cool_count815, 816, 817, 901, 920Touch count set when buffer cooled_db_aging_freeze_cr815, 816, 817, 901, 920Make CR buffers always be too cold to keep in cache_db_aging_hot_criteria815, 816, 817, 901, 920Touch count which sends a buffer to head of replacement list_db_aging_stay_count815, 816, 817, 901, 920Touch count set when buffer moved to head of replacement list_db_aging_touch_time815, 816, 817, 901, 920Touch count which sends a buffer to head of replacement list_db_always_check_system_ts816, 817, 901, 920Always perform block check and checksum for System tablespace_db_block_buffers901, 920Number of database blocks cached in memory: hidden parameter_db_block_cache_clone716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Always clone data blocks on get (for debugging)_db_block_cache_map803, 804, 805, 806, 815, 816, 817, 901Map / unmap and track reference counts on blocks (for debugging)_db_block_cache_num_umap920number of unmapped buffers (for tracking swap calls on blocks)_db_block_cache_protect716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920protect database blocks (true only when debugging)_db_block_check_for_debug816, 817, 901, 920Check more and dump block before image for debugging_db_block_compute_checksums716 _db_block_granule_interval901, 920number of lru latches_db_block_hash_buckets716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Number of database block hash buckets_db_block_hash_latches816, 817, 901, 920Number of database block hash latches_db_block_hi_priority_batch_size803, 804, 805, 806, 815, 816, 817, 901, 920Fraction of writes for high priority reasons_db_block_lru_latches901, 920number of lru latches_db_block_max_cr_dba723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Maximum Allowed Number of CR buffers per dba_db_block_max_scan_cnt716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _db_block_max_dirty_target901, 920Upper bound on modified buffers/recovery reads_db_block_max_scan_pct901, 920Percentage of buffers to inspect when looking for free_db_block_med_priority_batch_size803, 804, 805, 806, 815, 816, 817, 901, 920Fraction of writes for medium priority reasons_db_block_multiple_hashchain_latches716, 723, 732, 733, 734 _db_block_no_idle_writes732, 733, 734, 803, 804, 805, 806 _db_block_numa815, 816, 817, 901, 920Number of NUMA nodes_db_block_write_batch716, 723, 732, 733, 734, 803, 804, 805, 806 _db_cache_advice817 _db_block_prefetch_quota901, 920Prefetch quota as a percent of cache size_db_block_trace_protect901, 920trace buffer protect calls_db_cache_advice_batch_size920cache advisory simulation batch size_db_cache_advice_sample_factor920cache advisory sampling factor_db_file_direct_io_count901, 920Sequential I/O buf size_db_file_noncontig_mblock_read_count815, 816, 817, 901, 920number of noncontiguous db blocks to be prefetched_db_handles716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920System-wide simultaneous buffer operations_db_handles_cached716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Buffer handles cached each process_db_large_dirty_queue716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Number of buffers which force dirty queue to be written_db_no_mount_lock716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901do not get a mount lock_db_mttr_advice920MTTR advisory_db_mttr_partitions920number of partitions for MTTR advisory_db_mttr_sample_factor920MTTR simulation sampling factor_db_mttr_sim_target920MTTR simulation targets_db_mttr_sim_trace_size920MTTR simulation trace size_db_mttr_trace_to_alert920dump trace entries to alert file_db_percent_hot_default815, 816, 817, 901, 920Percent of default buffer pool considered hot_db_percent_hot_keep815, 816, 817, 901, 920Percent of keep buffer pool considered hot_db_percent_hot_recycle815, 816, 817, 901, 920Percent of recycle buffer pool considered hot_db_writer_chunk_writes815, 816, 817, 901, 920Number of writes DBWR should wait for_db_writer_histogram_statistics815, 816, 817, 901, 920maintain dbwr histogram statistics in x$kcbbhs_db_writer_max_writes815, 816, 817, 901, 920Max number of outstanding DB Writer IOs_db_writer_scan_depth716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _db_writer_scan_depth_decrement716, 723, 732, 733, 734, 803, 804, 805, 806, 815 _db_writer_scan_depth_increment716, 723, 732, 733, 734, 803, 804, 805, 806, 815 _db_writer_scan_depth_pct901, 920Percentage of LRU buffers for dbwr to scan when looking for dirt_dbg_proc_startup920debug process startup_dbwr_async_io815, 816, 817, 901, 920Enable dbwriter asynchronous writes_dbwr_scan_interval816, 817, 901, 920dbwriter scan interval_dbwr_slave_batch_size723, 732, 733, 734 _dbwr_tracing815, 816, 817, 901, 920Enable dbwriter tracing_debug_sga716, 723, 732, 733, 734, 803, 804, 805, 806 _default_non_equality_sel_check817, 901, 920sanity check on default selectivity for like/range predicate_defer_multiple_waiters815, 816, 817, 901, 920if TRUE, defer down converts when there were waiters (DFS)_disable_blocking_waiters716, 723, 732, 733, 734 _diag_daemon901, 920start DIAG daemon_disable_file_locks815, 816, 817, 901, 920disable file locks for control, data, redo log files_disable_incremental_checkpoints803, 804, 805, 806, 815, 816, 817, 901, 920Disable incremental checkpoints for thread recovery_disable_kcbhxor_osd920disable kcbh(c)xor OSD functionality_disable_latch_free_SCN_writes_via_32cas803, 804, 805, 806, 815, 816, 817, 901, 920disable latch-free SCN writes using 32-bit compare & swap_disable_latch_free_SCN_writes_via_64cas803, 804, 805, 806, 815, 816, 817, 901, 920disable latch-free SCN writes using 64-bit compare & swap_disable_logging716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Disable logging_disable_oracle_resilvering733, 734 _disable_multiple_block_sizes901, 920disable multiple block size support (for debugging)_disable_odm920disable odm feature_disable_recoverable_recovery920Disable the new recoverable recovery mechanism_disable_sun_rsm901, 920Disable IPC OSD support for Sun RSMAPI_disable_system_state920disable system state dump_discrete_transactions_enabled815, 816, 817, 901, 920enable OLTP mode_disk_get_lock816, 817 _dispatcher_rate_scale901, 920scale to display rate statistic (100ths of a second)_dispatcher_rate_ttl901, 920time-to-live for rate statistic (100ths of a second)_distributed_lock_timeout815, 816, 817, 901number of seconds a distributed transaction waits for a lock_distributed_recovery_connection_hold_ti815, 816, 817 _dlm_domain716, 723, 732, 733, 734, 803, 804, 805, 806 _distributed_recovery_connection_hold_time901, 920number of seconds RECO holds outbound connections open_dlmtrace901, 920Trace string of lock types(s)_domain_index_batch_size815, 816, 817, 901, 920maximum number of rows from one call to domain index fetch routi_domain_index_dml_batch_size815, 816, 817, 901, 920maximum number of rows for one call to domain index dml routines_dss_cache_flush803, 804, 805, 806, 815, 816, 817, 901, 920enable full cache flush for parallel execution_dump_MTTR_to_trace815, 816, 817, 901, 920Dump High Availability MTTR infromation to CKPT trace file_dump_system_state_scope920scope of sysstate dump during instance termination_dynamic_rls_policies920rls policies are dynamic_dynamic_stats_threshold803, 804, 805, 806, 815, 816, 817, 901, 920delay threshold (in seconds) between sending statistics messages_eliminate_common_subexpr816, 817, 901, 920enables elimination of common sub-expressions_enable_NUMA_optimization815, 816, 817, 901, 920Enable NUMA specific optimizations_enable_block_level_transaction_recovery815, 816, 817, 901, 920enable block level recovery_enable_cscn_caching803, 804, 805, 806, 815, 816, 817, 901, 920enable commit SCN caching for all transactions_enable_dba_locking732, 733, 734 _enable_default_affinity815, 816, 817, 901, 920to enable default implementation of affinity osds_enable_kgh_policy901, 920temporary to disable/enable kgh policy_enable_list_io815, 816, 817, 901, 920Enable List I/O_enable_multi_statement_pdml803, 804, 805, 806 _enable_multitable_sampling815, 816, 817, 901, 920enable multitable sampling_enable_type_dep_selectivity816, 817, 901, 920enable type dependent selectivity estimates_enqueue_debug_multi_instance716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920debug enqueue multi instance_enqueue_hash716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920enqueue hash table length_enqueue_hash_chain_latches732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920enqueue hash chain latches_enqueue_locks716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920locks for managed enqueues_explain_rewrite_mode901, 920allow additional messages to be generated during explain rewrite_fairness_pi901if TRUE, allow spontaneous PI buffers_fairness_threshold815, 816, 817, 901, 920number of times to CR serve before downgrading lock (DFS)_fast_full_scan_enabled803, 804, 805, 806, 815, 816, 817, 901, 920enable/disable index fast full scan_fifth_spare_parameter815, 816, 817, 901, 920fifth spare parameter - string_filesystemio_options817, 901IO operations on filesystem files_first_spare_parameter815, 816, 817, 901, 920first spare parameter - integer_foreground_locks815 _force_datefold_trunc920force use of trunc for datefolding rewrite_force_temptables_for_gsets901, 920executes concatenation of rollups using temp tables_fourth_spare_parameter815, 816, 817, 901, 920fourth spare parameter - string_freeze_DB_for_fast_instance_recovery815, 816, 817 _full_pwise_join_enabled815, 816, 817, 901, 920enable full partition-wise join when TRUE_gc_bsp_procs816, 817, 901number of buffer server processes to start (DFS)_gc_class_locks803, 804, 805, 806, 815, 816, 817 _gby_onekey_enabled920enable use of one comparison of all group by keys_gc_defer_time901, 920how long to defer down converts for hot buffers (DFS)_gc_integrity_checks920if TRUE, enable expensive integrity checks (DFS)_gc_latches815, 816, 817, 901, 920number of latches per lock process (DFS)number of latches per LMS process (DFS)_gc_lck_procs815, 816, 817, 901number of background parallel server lock processes to start_gc_recovery_scan_smon723, 732, 733, 734 _gc_releasable_locks901number of global cache locks (DFS)_gcs_fast_reconfig920if TRUE, enable fast reconfiguration for gcs locks_gcs_latches920number of gcs resource hash latches to be allocated_gcs_resources920number of gcs resources to be allocated_generalized_pruning_enabled920controls extensions to partition pruning for general predicates_groupby_nopushdown_cut_ratio815, 816, 817, 901, 920groupby nopushdown cut ratio_groupby_orderby_combine816, 817, 901, 920groupby/orderby don't combine threshold_gs_anti_semi_join_allowed901, 920enable anti/semi join for the GS query_hard_protection920if TRUE enable H.A.R.D specific format changes_hash_multiblock_io_count901, 920number of blocks hash join will read/write at once_high_server_threshold815, 816, 817, 901, 920high server thresholds_huge_sga_base_address716 _idl_conventional_index_maintenance803, 804, 805, 806, 815, 816, 817, 901, 920enable conventional index maintenance for insert direct load_ignore_desc_in_index816, 817, 901, 920ignore DESC in indexes, sort those columns ascending anyhow_ignore_failed_escalates803, 804, 805, 806 _improved_outerjoin_card816, 817, 901, 920improved outer-join cardinality calculation_improved_row_length_enabled815, 816, 817, 901, 920enable the improvements for computing the average row length_imr_active901, 920Activate Instance Membership Recovery feature_imr_max_reconfig_delay901, 920Maximum Reconfiguration delay (seconds)_imr_splitbrain_res_wait920Maximum wait for split-brain resolution (seconds)_index_join_enabled816, 817, 901, 920enable the use of index joins_index_prefetch_factor815, 816, 817, 901, 920index prefetching factor_init_sql_file716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920File containing SQL statements to execute upon database creation_insert_enable_hwm_brokered901, 920during parallel inserts high water marks are brokered_inst_locking_period901, 920period an instance can retain a newly acquired level1 bitmap_instance_type920type of instance to be executed_interconnect_checksum816, 817, 901, 920if TRUE, checksum interconnect blocks (DFS)_intrapart_pdml_enabled920Enable intra-partition updates/deletes_io_slaves_disabled803, 804, 805, 806, 815, 816, 817, 901, 920Do not use I/O slaves_ioslave_batch_count803, 804, 805, 806, 815, 816, 817, 901, 920Per attempt IOs picked_ioslave_issue_count803, 804, 805, 806, 815, 816, 817, 901, 920IOs issued before completion check_ipc_fail_network816, 817, 901, 920Simulate cluster network failer_ipc_test_failover816, 817, 901, 920Test transparent cluster network failover_ipc_test_mult_nets816, 817, 901, 920simulate multiple cluster networks_ipq_use_udp733, 734 _job_queue_interval901, 920Wakeup interval in seconds for job queue co-ordinator_kcl_commit920if TRUE, call kjbcommit (DFS)_kcl_conservative_log_flush920if TRUE, conservatively log flush before CR serving (DFS)_kcl_debug815, 816, 817, 901, 920if TRUE, record le history (DFS)_kcl_dispatch901if TRUE, dispatch requests to bsp and lck (DFS)_kcl_index_split920if TRUE, reject pings on blocks in middle of a split (DFS)_kcl_local_file_time920how often to check for local files (DFS)_kcl_name_table_latches901, 920number of name table latches (DFS)_kcl_partition901if TRUE, dynamically remaster partitioned files (DFS)_kcl_recovery_read_batch920recovery read batch size (DFS)_kcl_undo_grouping920grouping for undo block locks (DFS)_kcl_undo_locks920number of locks per undo segment (DFS)_kcl_use_cr901, 920if TRUE, use Fusion CR buffers (DFS)_kdbl_enable_post_allocation901, 920allocate dbas after populating data buffers_keep_recovery_buffers901, 920if TRUE, make recovery buffers currentif TRUE, make recovery buffers current (DFS)_keep_remote_column_size901, 920remote column size does not get modified_kghdsidx_count901, 920max kghdsidx count_kgl_bucket_count723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920index to the bucket count array_kgl_latch_count723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920number of library cache latches_kgl_multi_instance_invalidation716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920whether KGL to support multi-instance invalidations_kgl_multi_instance_lock716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920whether KGL to support multi-instance locks_kgl_multi_instance_pin716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920whether KGL to support multi-instance pins_kglsim_maxmem_percent920max percentage of shared pool size to be used for KGL advice_kkfi_trace815, 816, 817, 901, 920trace expression substitution_kolfuseslf920allow kolf to use slffopen_ksdxw_cini_flg920ksdxw context initialization flag_ksdxw_nbufs920ksdxw number of buffers in buffered mode_ksdxw_num_pgw920number of watchpoints on a per-process basis_ksdxw_num_sgw920number of watchpoints to be shared by all processes_ksdxw_stack_depth920number of PCs to collect in the stack when watchpoint is hit_ksi_trace816, 817, 901, 920KSI trace string of lock type(s)_ksmg_granule_locking_status920granule locking status_ksmg_granule_size901, 920granule size in bytes_ksu_diag_kill_time901, 920number of seconds ksuitm waits before killing diag_ktc_latches920number of ktc latches_ktu_latches920number of KTU latches_large_pool_min_alloc815, 816, 817, 901, 920minimum allocation size in bytes for the large allocation pool_last_allocation_period901, 920period over which an instance can retain an active level1 bitmap_latch_class_0920latch class 0_latch_class_1920latch class 1_latch_class_2920latch class 2_latch_class_3920latch class 3_latch_class_4920latch class 4_latch_class_5920latch class 5_latch_class_6920latch class 6_latch_class_7920latch class 7_latch_classes920latch classes override_latch_miss_stat_sid815, 816, 817, 901, 920Sid of process for which to collect latch stats_latch_recovery_alignment716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920align latch recovery structures_latch_spin_count716, 723, 732, 733, 734 _latch_wait_posting716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _lazy_freelist_close815, 816, 817 _le_lru_scan817 _ldr_io_size901, 920size of write IOs used during a load operation_left_nested_loops_random815, 816, 817, 901, 920enable random distribution method for left of nestedloops_lgwr_async_io815, 816, 817, 901, 920LGWR Asynchronous IO enabling boolean flag_lgwr_delay_write920LGWR write delay for debugging_lgwr_io_slaves815, 816, 817, 901, 920LGWR I/O slaves_lgwr_max_ns_wt901, 920Maximum wait time for lgwr to allow NetServer to progress_lgwr_ns_nl_max901, 920Variable to simulate network latency_lgwr_ns_nl_min901, 920Variable to simulate network latency_lgwr_ns_sim_err901, 920Variable to simulate errors during lgwr-network server testingVariable to simulate errors lgwrns_library_cache_advice920whether KGL advice should be turned on_like_with_bind_as_equality816, 817, 901, 920treat LIKE predicate with bind as an equality predicate_lm_ast_option803, 804, 805, 806, 815, 816, 817 _lm_activate_lms_threshold901, 920threshold value to activate an additional lms_lm_cache_lvl0_cleanup920how often to cleanup level 0 cache res (in sec)_lm_cache_res_cleanup816, 817, 901, 920percentage of cached resources should be cleanup_lm_cache_res_type920cache resource: string of lock types(s)_lm_dd_interval816, 817, 901, 920dd time interval in seconds_lm_direct_sends803, 804, 805, 806, 815, 816, 817, 901, 920Processes which will do direct lock manager sendsProcesses which will do direct sends_lm_dlmd_procs803, 804, 805, 806, 815, 816, 817 _lm_domains803, 804, 805, 806, 815, 816, 817 _lm_groups803, 804, 805, 806, 815, 816, 817 _lm_dispatch_nonpcm901dispatching non-pcm messages to LMS_lm_dispatch_pcm901dispatching pcm messages to LMS_lm_drm_window920dynamic remastering bucket window size_lm_dynamic_lms901, 920dynamic lms invocation_lm_dynamic_load920dynamic load adjustment_lm_dynamic_remastering901, 920if TRUE enables dynamic remastering_lm_enq_lock_freelist920Number of ges enqueue element freelist_lm_enq_rcfg920if TRUE enables enqueue reconfiguration_lm_enqeue_freelist920Number of enqueue freelist_lm_file_affinity920mapping between file id and master instance number_lm_lmd_waittime920default wait time for lmd_lm_lms901, 920number of background lock manager server processes to startnumber of background global cache server processes to start_lm_lms_waittime920default wait time for lms_lm_locks901, 920number of locks configured for the lock managernumber of enqueues configured for cluster database_lm_master_weight901, 920master resource weight for this instance_lm_max_lms901, 920max. number of background lock manager server processesmax. number of background global cache server processes_lm_min_lms901, 920min. number of background lock manager server processesmin. number of background global cache server processes_lm_msg_batch_size901, 920DLM batch message sizeGES batch message size_lm_msg_cache_thresholds920GES message buffer caching threshold_lm_msg_cleanup_interval920GES message buffer cleanup interval time_lm_node_join_opt901, 920lock manager node join optimization in reconfigcluster database node join optimization in reconfig_lm_non_fault_tolerant803, 804, 805, 806, 815, 816, 817, 901, 920disable lock manager fault-tolerance modedisable cluster database fault-tolerance mode_lm_num_pcmhv_latches920number of latches covering the PCM HV buckets in cgs_lm_proc_freeze_timeout901, 920reconfiguration: process freeze timeout_lm_process_batching920GES implicit process batching for IPC messages_lm_procs816, 817, 901, 920number of client processes configured for the lock managernumber of client processes configured for cluster database_lm_rcfg_timeout920Reconfiguration timeout_lm_rcv_buffer_size816, 817, 901, 920the size of receive buffer_lm_res_cache817 _lm_res_cache_interval817 _lm_res_hash_bucket920number of resource hash buckets_lm_res_part901, 920number of resource partition configured for the lock managernumber of resource partition configured for gcs_lm_ress901, 920number of resources configured for the lock managernumber of resources configured for cluster database_lm_send_buffers803, 804, 805, 806, 815, 816, 817, 901, 920number of lock manager send buffersnumber of cluster database send buffers_lm_statistics803, 804, 805, 806, 815, 816, 817 _lm_send_queue_batching920GES send queue message batching_lm_send_queue_length901, 920KJCT send queue maximum lengthGES send queue maximum length_lm_share_lock_opt920if TRUE enables share lock optimization_lm_sq_batch_factor920GES send queue minimum batching factor_lm_sync_timeout816, 817, 901, 920Synchronization timeout for DLM reconfiguration steps_lm_ticket_active_sendback817, 901, 920Flow control ticket active sendback threshold_lm_tickets901, 920DLM messaging ticketsGES messaging tickets_lm_tx_delta901, 920TX lock localization delta_lm_validate_resource_type901, 920if TRUE enables resource name validation_lm_xids803, 804, 805, 806, 815, 816, 817, 901, 920number of transaction IDs configured for the lock managernumber of transaction IDs configured for cluster database_load_without_compile920Load PL/SQL or Database objects without compilation_local_communication_costing_enabled901, 920enable local communication costing when TRUE_local_communication_ratio901, 920set the ratio between global and local communication (0..100)_lock_sga_areas815, 816, 817, 901, 920Lock specified areas of the SGA in physical memory_log_archive_buffer_size815, 816, 817, 901, 920Size of each archival buffer in log file blocks_log_archive_buffers815, 816, 817, 901, 920Number of buffers to allocate for archiving_log_archive_callout920archival callout_log_archive_delta_sync_wait920iterative sleep time in centiseconds seconds when SYNC=PARALLEL_log_archive_net_timeout920maximum network wait time in seconds when SYNC=PARALLEL_log_blocks_during_backup716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920log block images when changed during backup_log_buffers_corrupt816, 817, 901, 920corrupt redo buffers before write_log_buffers_debug716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920debug redo buffers (slows things down)_log_checkpoint_recovery_check716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920# redo blocks to verify after checkpoint_log_committime_block_cleanout920Log commit-time block cleanout_log_debug_multi_instance716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920debug redo multi instance code_log_entry_prebuild_threshold716, 723, 732, 733, 734, 803, 804, 805, 806 _log_file_block_size733, 734 _log_io_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920automatically initiate log write if this many redo blocks in buf_log_simultaneous_copies815, 816, 817, 901, 920number of simultaneous copies into redo buffer(# of copy latches_log_space_errors723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920should we report space errors to alert log_log_switch_timeout901, 920Maximum number of seconds redos in the current log could span_low_server_threshold815, 816, 817, 901, 920low server thresholds_master_direct_sends901, 920direct sends for messages from master (DFS)_mav_refresh_consistent_read920refresh materialized views using consistent read snapshot_mav_refresh_double_count_prevented920materialized view MAV refreshes avoid double counting_mav_refresh_opt901, 920optimizations during refresh of materialized views_mav_refresh_unionall_tables901, 920# tables for union all expansion during materialized view refres_max_exponential_sleep716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max sleep during exponential backoff_max_sleep_holding_latch716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max time to sleep while holding a latch_max_transaction_branches815, 816, 817 _messages716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920message queue resources - dependent on # processes & # buffers_minimal_stats_aggregation817, 901, 920prohibit stats aggregation at compile/partition maintenance time_minimum_giga_scn723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Minimum SCN to start with in 2^30 units_mts_fastpath716, 723, 732, 733, 734 _mts_listener_retry716, 723, 732, 733, 734 _mts_load_constants716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _mts_rate_log_size815 _mts_rate_scale815, 816, 817 _mts_rate_ttl816, 817 _multi_join_key_table_lookup901, 920TRUE iff multi-join-key table lookup prefetch is enabled_mv_refresh_delta_fraction901, 920delta mv as fractional percentage of size of mv_mv_refresh_eut901, 920refresh materialized views using EUT(partition)-based algorithm_mv_refresh_new_setup_disabled920materialized view MV refresh new setup disabling_mv_refresh_selections817, 901, 920create materialized views with selections and fast refresh_mv_refresh_use_stats901, 920pass cardinality hints to refresh queries_nchar_imp_cnv901, 920NLS allow Implicit Conversion between CHAR and NCHAR_ncmb_readahead_enabled815, 816, 817, 901, 920enable multi-block readahead for an index scan_ncmb_readahead_tracing815, 816, 817, 901, 920turn on multi-block readahead tracing_nested_loop_fudge815, 816, 817, 901, 920nested loop fudge_new_connect_by_enabled816, 817 _nested_mav_fast_oncommit_enabled920nested MAV refresh fast on commit allowed_new_initial_join_orders817, 901, 920enable initial join orders based on new ordering heuristics_new_sort_cost_estimate901, 920enables the use of new cost estimate for sort_no_objects803, 804, 805, 806, 815, 816, 817, 901, 920no object features are used_no_or_expansion815, 816, 817, 901, 920OR expansion during optimization disabled_no_preempt803, 804, 805, 806 _no_status_for_current815 _ns_max_flush_wt901, 920Flush wait time for NetServer to flush oustanding writes_num_longop_child_latches920number of child latches for long op array_number_cached_attributes732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920maximum number of cached attributes per instance_object_statistics920enable the object level statistics collection_offline_rollback_segments716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920offline undo segment list_ogms_home815, 816, 817, 901, 920GMS home directory_olap_aggregate_buffer_size920OLAP Aggregate max buffer size_olap_aggregate_child_fragment_size920OLAP Aggregate child fragment size_olap_aggregate_child_max_size920OLAP Aggregate child list max size_olap_aggregate_function_cache_enabled920OLAP Aggregate function cache enabler_olap_aggregate_function_merge_threshold920OLAP Aggregate function merge threshold_olap_aggregate_max_thread_tuples920OLAP Aggregate max thread tuples creation_olap_aggregate_min_buffer_size920OLAP Aggregate min buffer size_olap_aggregate_min_thread_status920OLAP Aggregate minimum cardinality of dimensions for thread_olap_aggregate_statlen_thresh920OLAP Aggregate status array usage threshold_olap_aggregate_store_probability920OLAP Aggregate function storeback probability_olap_aggregate_work_per_thread920OLAP Aggregate max work parents_olap_aggregate_worklist_max920OLAP Aggregate max worklists generated at once_olap_allocate_errorlog_format920OLAP Allocate Errorlog Format_olap_allocate_errorlog_header920OLAP Allocate Errorlog Header format_olap_continuous_trace_file920Specify TRUE to enable continuous OLAP tracing - otherwise only_olap_dimsave_restore_cache_values920OLAP Dimsave restores cached dimension values_olap_eif_export_lob_size920OLAP EIF Export BLOB size_olap_parallel_update_threshold920OLAP parallel update threshold in pages_olap_poutlog_echo_to_eventlog920OLAP POutLog copy output to event log (tracefile)_old_connect_by_enabled901, 920enable/disable old connect by_omf920enable/disable OMF_oneside_colstat_for_equijoins817, 901, 920sanity check on default selectivity for like/range predicate_open_files_limit803, 804, 805, 806, 815, 816, 817, 901, 920Limit on number of files opened by I/O subsystem_optim_adjust_for_part_skews920adjust stats for skews across partitions_optim_enhance_nnull_detection816, 817, 901, 920TRUE to enable index [fast] full scan more often_optim_new_default_join_sel901, 920improves the way default equijoin selectivity are computed_optim_peek_user_binds901, 920enable peeking of user binds_optimizer_adjust_for_nulls816, 817, 901, 920adjust selectivity for null values_optimizer_choose_permutation816, 817, 901, 920force the optimizer to use the specified permutation_optimizer_cost_model901, 920optimizer cost model_optimizer_degree816, 817, 901, 920force the optimizer to use the same degree of parallelism_optimizer_dyn_smp_blks920number of blocks for optimizer dynamic sampling_optimizer_mode_force816, 817, 901, 920force setting of optimizer mode for user recursive SQL also_optimizer_new_mbio901enables the use of new costing I/O with mbio_optimizer_new_join_card_computation920compute join cardinality using non-rounded input values_optimizer_percent_parallel901, 920optimizer percent parallel_optimizer_search_limit816, 817, 901, 920optimizer search limit_optimizer_system_stats_usage920system statistics usage_optimizer_undo_changes716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920undo changes to query optimizer_optimizer_undo_cost_change920optimizer undo cost change_or_expand_nvl_predicate816, 817, 901, 920enable OR expanded plan for NVL/DECODE predicate_oracle_trace_events732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Oracle TRACE event flags_oracle_trace_facility_version732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Oracle TRACE facility version_ordered_nested_loop815, 816, 817, 901, 920enable ordered nested loop costing_ordered_semijoin816, 817, 901, 920enable ordered semi-join subquery_parallel_adaptive_max_users815, 816, 817, 901, 920maximum number of users running with default DOP_parallel_allocation716, 723, 732, 733, 734 _parallel_broadcast_enabled920enable broadcasting of small inputs to hash and sort merge joins_parallel_default_max_instances815, 816, 817, 901, 920default maximum number of instances for parallel query_parallel_execution_message_align815, 816, 817, 901, 920Alignment of PX buffers to OS page boundary_parallel_fake_class_pct815, 816, 817, 901, 920fake db-scheduler percent used for testing_parallel_load_bal_unit815, 816, 817, 901, 920number of threads to allocate per instance_parallel_load_balancing815, 816, 817, 901, 920parallel execution load balanced slave allocation_parallel_min_message_pool732, 733, 734, 815, 816, 817, 901, 920minimum size of shared pool memory to reserve for pq servers_parallel_recovery_stopat815, 816, 817, 901, 920stop at -position- to step through SMON_parallel_server_idle_time815, 816, 817, 901, 920idle time before parallel query server dies_parallel_server_sleep_time716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920sleep time between dequeue timeouts (in 1/100ths)_parallel_txn_global816, 817, 901, 920enable parallel_txn hint with updates and deletes_parallelism_cost_fudge_factor815, 816, 817, 901, 920set the parallelism cost fudge factor_partial_pwise_join_enabled815, 816, 817, 901, 920enable partial partition-wise join when TRUE_passwordfile_enqueue_timeout716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920password file enqueue timeout in seconds_pcm_fast_reconfig901if TRUE, enable fast reconfiguration for pcm locks_pcm_latches901number of pcm resource hash latches to be allocated_pcm_resources901number of pcm resources to be allocated_pcm_shadow_locks901, 920number of pcm shadow locks to be allocated_pct_refresh_double_count_prevented920materialized view PCT refreshes avoid double counting_pdml_gim_sampling815, 816, 817, 901, 920control separation of global index maintenance for PDML_pdml_gim_staggered816, 817, 901, 920slaves start on different index when doing index maint_pdml_slaves_diff_part815, 816, 817, 901, 920slaves start on different partition when doing index maint_pga_max_size901, 920Maximum size of the PGA memory for one process_ping_level901, 920fusion ping level (DFS)_plsql_dump_buffer_events815, 816, 817, 901, 920conditions upon which the PL/SQL circular buffer is dumped_plsql_load_without_compile816, 817, 901PL/SQL load without compilation flag_pmon_load_constants901, 920server load balancing constants (S,P,D,I,L,C,M)_pre_rewrite_push_pred920push predicates into views before rewrite_precompute_gid_values920precompute gid values and copy them before returning a row_pred_move_around901, 920enables predicate move-around_predicate_elimination_enabled803, 804, 805, 806, 815, 816, 817, 901, 920allow predicate elimination if set to TRUE_project_view_columns815, 816, 817, 901, 920enable projecting out unreferenced columns of a view_push_join_predicate815, 816, 817, 901, 920enable pushing join predicate inside a view_push_join_union_view816, 817, 901, 920enable pushing join predicate inside a union view_px_async_getgranule817, 901, 920asynchronous get granule in the slave_px_broadcast_fudge_factor815, 816, 817, 901, 920set the tq broadcasting fudge factor percentage_px_broadcast_trace815 _px_disable_broadcast803, 804, 805, 806 _px_dynamic_opt920turn off/on restartable qerpx dynamic optimization_px_dynamic_sample_size920num of samples for restartable qerpx dynamic optimization_px_granule_size815, 816, 817, 901, 920default size of a rowid range granule (in KB)_px_index_sampling815, 816, 817, 901, 920parallel query sampling for index create (100000 = 100%)_px_kxib_tracing815, 816, 817, 901, 920turn on kxib tracing_px_load_publish_interval815, 816, 817, 901, 920interval at which LMON will check whether to publish PX load_px_max_granules_per_slave815, 816, 817, 901, 920maximum number of rowid range granules to generate per slave_px_min_granules_per_slave815, 816, 817, 901, 920minimum number of rowid range granules to generate per slave_px_no_stealing815, 816, 817, 901, 920prevent parallel granule stealing in shared nothing environment_px_trace901, 920px trace parameter_query_cost_rewrite815, 816, 817, 901, 920perform the cost based rewrite with materialized views_query_rewrite_1901, 920perform query rewrite before&after or only before view merging_query_rewrite_2815, 816, 817, 901, 920perform query rewrite before&after or only after view merging_query_rewrite_drj920mv rewrite and drop redundant joins_query_rewrite_expression816, 817, 901, 920rewrite with cannonical form for expressions_query_rewrite_fpc920mv rewrite fresh partition containment_query_rewrite_fudge816, 817, 901, 920cost based query rewrite with MVs fudge factor_query_rewrite_jgmigrate920mv rewrite with jg migration_query_rewrite_maxdisjunct920query rewrite max disjuncts_query_rewrite_or_error901, 920allow query rewrite, if referenced tables are not dataless_query_rewrite_vop_cleanup816, 817, 901, 920prune frocol chain before rewrite after view-merging_realfree_heap_free_threshold901, 920threshold for performing real-free, in Kbytes_realfree_heap_max_size901, 920minimum max total heap size, in Kbytes_realfree_heap_mode920mode flags for real-free heap_recovery_asserts920if TRUE, enable expensive recovery sanity checks (DFS)_recovery_claim_batch_size901, 920number of messages to batch in a recovery claim message (DFS)_recovery_percentage901, 920recovery buffer cache percentage_release_insert_threshold716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920maximum number of unusable blocks to unlink from freelist_reliable_block_sends901, 920if TRUE, block sends across interconnect are reliable_reuse_index_loop716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920number of blocks being examine for index block reuse_rollback_segment_count716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920number of undo segments_rollback_segment_initial716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920starting undo segment number_row_cache_buffer_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901size of row cache circular buffer_row_cache_cursors815, 816, 817, 901, 920number of cached cursors for row cache management_row_cache_instance_locks716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901number of row cache instance locks_save_escalates803, 804, 805, 806, 815 _row_cr920enable row cr for all sql_rowsource_execution_statistics920if TRUE, Oracle will collect rowsource level statistics_scn_scheme815, 816, 817, 901, 920SCN scheme_second_spare_parameter815, 816, 817, 901, 920second spare parameter - integer_send_ast_to_foreground920if TRUE, send ast message to foreground_send_close_with_block901, 920if TRUE, send close with block even with direct sends_send_requests_to_PI920if TRUE, try to send CR requests to PI buffers (DFS)_serial_direct_read815, 816, 817, 901, 920enable direct read in serial_session_idle_bit_latches732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920one latch per session or a latch per group of sessions_seventh_spare_parameter901, 920seventh spare parameter - string list_shared_pool_reserved_min_alloc815, 816, 817, 901, 920minimum allocation size in bytes for reserved area of shared poo_shared_session_sort_fetch_buffer723, 732, 733, 734, 803, 804, 805, 806 _shared_pool_reserved_pct901, 920percentage memory of the shared pool allocated for the reserved_shrunk_aggs_disable_threshold901, 920percentage of exceptions at which to switch to full length aggs_shrunk_aggs_enabled901, 920enable use of variable sized buffers for non-distinct aggregates_side_channel_batch_size901, 920number of messages to batch in a side channel message (DFS)_side_channel_batch_timeout920timeout before shipping out all the batched side channel message_single_process732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920run without detached processes_sixth_spare_parameter901, 920sixth spare parameter - string list_skip_assume_msg901, 920if TRUE, skip assume message for consigns at the master_slave_mapping_enabled901, 920enable slave mapping when TRUE_slave_mapping_group_size901, 920force the number of slave group in a slave mapper_small_table_threshold716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920threshold level of table size for direct reads_smm_advice_enabled920if TRUE, enable v$pga_advice_smm_advice_log_size920overwrites default size of the PGA advice workarea history log_smm_auto_cost_enabled901, 920if TRUE, use the AUTO size policy cost functions_smm_auto_max_io_size901, 920Maximum IO size (in KB) used by sort/hash-join in auto mode_smm_auto_min_io_size901, 920Minimum IO size (in KB) used by sort/hash-join in auto mode_smm_bound901, 920overwrites memory manager automatically computed bound_smm_control901, 920provides controls on the memory manager_smm_max_size901, 920maximum work area size in auto mode (serial)_smm_min_size901, 920minimum work area size in auto mode_smm_px_max_size901, 920maximum work area size in auto mode (global)_smm_trace901, 920Turn on/off tracing for SQL memory manager_smon_consume_post920consume any extra posts after completion of transaction recovery_smon_internal_errlimit901, 920limit of SMON internal errors_smu_debug_mode901, 920<debug-flag> - set debug event for testing SMU operations_smu_error_simulation_site901, 920site ID of error simulation in KTU code_smu_error_simulation_type901, 920error type for error simulation in KTU code_sort_elimination_cost_ratio816, 817, 901, 920cost ratio for sort eimination under first_rows mode_sort_multiblock_read_count901, 920multi-block read count for sort_sort_space_for_write_buffers815, 816, 817, 901, 920tenths of sort_area_size devoted to direct write buffers_sort_use_os_files_as_temporaries716, 723, 732 _sortmerge_inequality_join_off817, 901, 920turns off sort-merge join on inequality_spin_count815, 816, 817, 901, 920Amount to spin waiting for a latch_spin_cpu_yield_freq803, 804, 805, 806 _sql_connect_capability_code716 _sql_connect_capability_override716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920SQL Connect Capability Table Override_sql_connect_capability_table716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920SQL Connect Capability Table (testing only)_sqlexec_progression_cost816, 817, 901, 920sql execution progression monitoring cost threshold_standby_lock_name_space732, 733, 734 _star_transformation_enabled733, 734 _subquery_pruning_cost_factor816, 817, 901, 920subquery pruning cost factor_subquery_pruning_enabled816, 817, 901, 920enable the use of subquery predicates to perform pruning_subquery_pruning_mv_enabled920enable the use of subquery predicates with MVs to perform prunin_subquery_pruning_reduction816, 817, 901, 920subquery pruning reduction factor_switch_on_stuck_recovery716, 723 _system_index_caching901, 920optimizer percent system index caching_system_trig_enabled815, 816, 817, 901, 920are system triggers enabled_table_lookup_prefetch_size901, 920table lookup prefetch vector size_table_lookup_prefetch_thresh920table lookup prefetch threshold_table_scan_cost_plus_one816, 817, 901, 920bump estimated full table scan cost by onebump estimated full table scan and index ffs cost by one_temp_tran_block_threshold816, 817, 901, 920number of blocks for a dimension before we temp transform_temp_tran_cache816, 817, 901, 920determines if temp table is created with cache option_test_ksusigskip920test the function ksusigskip_test_param_1732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920test parmeter 1 - integer_test_param_2732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920test parameter 2 - string_test_param_3732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920test parameter 3 - string_test_param_4901, 920test parameter 4 - string list_test_param_5901, 920test parmeter 5 - deprecated integer_test_param_6901, 920test parmeter 6 - size (ub8)_third_spare_parameter815, 816, 817, 901, 920third spare parameter - integer_tq_dump_period815, 816, 817, 901, 920time period for duping of TQ statistics (s)_trace_archive_dest716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _trace_archive_start716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _trace_block_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _trace_archive901, 920start DIAG process_trace_buffer_flushes815, 816, 817, 901, 920trace buffer flushes if otrace cacheIO event is set_trace_buffer_gets817, 901, 920trace kcb buffer gets if otrace cacheIO event is set_trace_buffers_per_process716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _trace_buffers901, 920trace buffer sizes per process. Indicates the number of trace records for a process. Default is 256. Can specifcy different values per process (=<proc-spec>:<size>;)trace buffer sizes per process_trace_cr_buffer_creates815, 816, 817, 901, 920trace cr buffer creates if otrace cacheIO event is set_trace_enabled716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _trace_events716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920trace events enabled at startup.trace events enabled at startup_trace_file_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920maximum size of trace file (in number of trace records). 64K defaultmaximum size of trace file (in number of trace records)_trace_files_public716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Create publicly accessible trace files_trace_flushing716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _trace_flush_processes901, 920trace data archived by DIAG for these processes. Can turn the tracing on per process.trace data archived by DIAG for these processes_trace_instance_termination716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920trace instance termination actions_trace_multi_block_reads815, 816, 817, 901, 920trace multi_block reads if otrace cacheIO event is set_trace_write_batch_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 _trace_options901, 920trace data flush options [binary|text],[multiple|single]trace data flush options_trace_pin_time920trace how long a current pin is held_trace_processes901, 920enable KST tracing in process. Default is ALLenable KST tracing in process_transaction_recovery_servers815, 816, 817, 901, 920max number of parallel recovery slaves that may be used_tts_allow_nchar_mismatch816, 817, 901, 920allow plugging in a tablespace with a different national charact_two_pass901, 920enable two-pass thread recovery_two_pass_reverse_polish_enabled920uses two-pass reverse polish alg. to generate canonical forms_union_rewrite_for_gs920expand queries with GSets into UNIONs for rewrite_unnest_notexists_sq920unnest NOT EXISTS subquery with one or more tables if possible_unnest_subquery816, 817, 901, 920enables unnesting of correlated subqueries_upconvert_from_ast803, 804, 805, 806 _use_column_stats_for_function816, 817, 901, 920enable the use of column statistics for DDP functions_use_ism815, 816, 817, 901, 920Enable Shared Page Tables - ISM_use_new_explain_plan901, 920if TRUE, use the AUTO size policy cost functions_use_nosegment_indexes816, 817, 901, 920use nosegment indexes in explain plan_use_realfree_heap901, 920use real-free based allocator for PGA memory_use_seq_process_cache920whether to use process local seq cache_use_vector_post803, 804, 805, 806, 815, 816, 817, 901, 920use vector post_verify_undo_quota901, 920TRUE - verify consistency of undo quota statistics_wait_for_sync716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920wait for sync on commit MUST BE ALWAYS TRUE_walk_insert_threshold716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920maximum number of unusable blocks to walk across freelist_watchpoint_on920is the watchpointing feature turned on?_write_clones815, 816, 817, 901, 920write clones flag_yield_check_interval815, 816, 817, 901, 920interval to check whether actses should yieldactive_instance_count816, 817, 901, 920number of active instances in the parallel servernumber of active instances in the cluster databaseallow_partial_sn_results803, 804, 805, 806 always_anti_join732, 733, 734, 803, 804, 805, 806, 815, 816, 817 always_semi_join815, 816, 817 aq_tm_processes803, 804, 805, 806, 815, 816, 817, 901, 920number of AQ Time Managers to startarch_io_slaves803, 804, 805, 806 async_read  async_write716, 723, 732, 733, 734 archive_lag_target901, 920Maximum number of seconds of redos the standby could loseaudit_file_dest716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Directory in which auditing files are to resideaudit_sys_operations920enable sys auditingaudit_trail716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920enable system auditingauto_mounting  b_tree_bitmap_plans732, 733, 734, 803, 804, 805, 806 background_core_dump716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Core Size for Background Processesbackground_dump_dest716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Detached process dump directorybackup_disk_io_slaves803, 804, 805, 806 backup_tape_io_slaves803, 804, 805, 806, 815, 816, 817, 901, 920BACKUP Tape I/O slavesbitmap_merge_area_size732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920maximum memory allow for BITMAP MERGEblank_trimming716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920blank trimming semantics parameterbuffer_pool_keep803, 804, 805, 806, 815, 816, 817, 901, 920Number of database blocks/latches in keep buffer poolbuffer_pool_recycle803, 804, 805, 806, 815, 816, 817, 901, 920Number of database blocks/latches in recycle buffer poolcache_size_threshold716, 723, 732, 733, 734, 803, 804, 805, 806 calls_to_get_snapshot_scn_kcmgss  ccf_io_size716, 723, 732, 733, 734 checkpoint_process716, 723, 732, 733, 734 cleanup_rollback_entries716, 723, 732, 733, 734, 803, 804, 805, 806 cleanouts_and_rollbacks_consistent_read_gets  close_cached_open_cursors716, 723, 732, 733, 734, 803, 804, 805, 806 circuits901, 920max number of circuitscluster_database920if TRUE startup in cluster database modecluster_database_instances920number of instances to use for sizing cluster db SGA structurescluster_interconnects901, 920interconnects for RAC usecommit_point_strength716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Bias this node has toward not preparing in a two-phase commitcompatible716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Database will be completely compatible with this software versiocompatible_no_recovery716, 723, 732, 733, 734, 803, 804, 805, 806 control_file_record_keep_time803, 804, 805, 806, 815, 816, 817, 901, 920control file record keep time in dayscontrol_files716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920control file names listcore_dump_dest716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Core dump directorycpu_count723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920initial number of cpu's for this instancecreate_bitmap_area_size732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920size of create bitmap buffer for bitmap indexcursor_sharing816, 817, 901, 920cursor sharing modecursor_space_for_time716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920use more memory in order to get faster executiondb_16k_cache_size901, 920Size of cache for 16K buffersdb_2k_cache_size901, 920Size of cache for 2K buffersdb_32k_cache_size901, 920Size of cache for 32K buffersdb_4k_cache_size901, 920Size of cache for 4K buffersdb_8k_cache_size901, 920Size of cache for 8K buffersdb_block_buffers716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Number of database blocks cached in memorydb_block_checking815, 816, 817, 901, 920data and index block checkingdb_block_checkpoint_batch716, 723, 732, 733, 734, 803, 804, 805, 806 db_block_checksum723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920store checksum in db blocks and check during readsdb_block_lru_extended_statistics716, 723, 732, 733, 734, 803, 804, 805, 806 db_block_lru_latches732, 733, 734, 803, 804, 805, 806, 815, 816, 817 db_block_lru_statistics716, 723, 732, 733, 734, 803, 804, 805, 806 db_block_max_dirty_target803, 804, 805, 806, 815, 816, 817 db_block_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Size of database block in bytesdb_cache_advice901, 920Buffer cache sizing advisorydb_cache_size901, 920Size of DEFAULT buffer pool for standard block size buffersdb_create_file_dest901, 920default database locationdb_create_online_log_dest_1901, 920online log/controlfile destination #1db_create_online_log_dest_2901, 920online log/controlfile destination #2db_create_online_log_dest_3901, 920online log/controlfile destination #3db_create_online_log_dest_4901, 920online log/controlfile destination #4db_create_online_log_dest_5901, 920online log/controlfile destination #5db_domain716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920directory part of global database name stored with CREATE DATABAdb_file_direct_io_count803, 804, 805, 806, 815, 816, 817 db_file_multiblock_read_count716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920db block to be read each IOdb_file_name_convert803, 804, 805, 806, 815, 816, 817, 901, 920datafile name convert patterns and strings for standby/clone dbdb_file_simultaneous_writes716, 723, 732, 733, 734, 803, 804, 805, 806 db_file_standby_name_convert732, 733, 734 db_files716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max allowable # db filesdb_keep_cache_size901, 920Size of KEEP buffer pool for standard block size buffersdb_name716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920database name specified in CREATE DATABASEdb_recycle_cache_size901, 920Size of RECYCLE buffer pool for standard block size buffersdb_writer_processes815, 816, 817, 901, 920number of background database writer processes to startdb_writers716, 723, 732, 733, 734 dblink_encrypt_login716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920enforce password for distributed login always be encrypteddbwr_io_slaves803, 804, 805, 806, 815, 816, 817, 901, 920DBWR I/O slavesdelayed_logging_block_cleanouts732, 733, 734, 803, 804, 805, 806 discrete_transactions_enabled716, 723, 732, 733, 734, 803, 804, 805, 806 dg_broker_config_file1920data guard broker configuration file #1dg_broker_config_file2920data guard broker configuration file #2dg_broker_start920start Data Guard broker framework (DMON process)disk_asynch_io803, 804, 805, 806, 815, 816, 817, 901, 920Use asynch I/O for random access devicesdispatchers920specifications of dispatchersdistributed_lock_timeout716, 723, 732, 733, 734, 803, 804, 805, 806, 920number of seconds a distributed transaction waits for a lockdistributed_recovery_connection_hold_tim716, 723, 732, 733, 734, 803, 804, 805, 806 dispatchers901specifications of dispatchersdistributed_transactions716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901max. number of concurrent distributed transactionsdml_locks716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920dml locks - one for each table modified in a transactiondrs_start901, 920start DR Server framework (DMON process)start DG Broker monitor (DMON process)enqueue_resources716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920resources for enqueuesent_domain_name815 event716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920debug event control - default null stringfal_client901, 920FAL clientfal_server901, 920FAL server listfast_start_io_target816, 817, 901, 920Upper bound on recovery readsfast_start_mttr_target901, 920MTTR target of forward crash recovery in secondsfast_start_parallel_rollback816, 817, 901, 920max number of parallel recovery slaves that may be usedfile_mapping920enable file mappingfilesystemio_options920IO operations on filesystem filesfixed_date716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920fixed SYSDATE valuefreeze_DB_for_fast_instance_recovery803, 804, 805, 806 gc_db_locks716, 723, 732, 733, 734 gc_defer_time803, 804, 805, 806, 815, 816, 817 gc_files_to_locks716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920mapping between file numbers and global cache locks (DFS)gc_freelist_groups732, 733, 734 gc_lck_procs716, 723, 732, 733, 734, 803, 804, 805, 806 gc_releasable_locks732, 733, 734, 803, 804, 805, 806, 815, 816, 817 gc_rollback_locks716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 gc_rollback_segments716, 723, 732, 733, 734 gc_save_rollback_locks716, 723, 732, 733, 734 gc_segments716, 723, 732, 733, 734 gc_tablespaces716, 723, 732, 733, 734 global_context_pool_size901, 920Global Application Context Pool Size in Bytesglobal_names716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920enforce that database links have same name as remote databasehash_area_size732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920size of in-memory hash work areahash_join_enabled732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920enable/disable hash joinhash_multiblock_io_count732, 733, 734, 803, 804, 805, 806, 815, 816, 817 hi_shared_memory_address815, 816, 817, 901, 920SGA starting address (high order 32-bits on 64-bit platforms)hs_autoregister815, 816, 817, 901, 920enable automatic server DD updates in HS agent self-registrationifile716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920include file in init.orainstance_groups803, 804, 805, 806, 815, 816, 817, 901, 920list of instance group namesinstance_name815, 816, 817, 901, 920instance name supported by the instanceinstance_number716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920instance numberipq_net733, 734 java_max_sessionspace_size816, 817, 901, 920max allowed size in bytes of a Java sessionspacejava_pool_size815, 816, 817, 901, 920size in bytes of the Java pooljava_soft_sessionspace_limit816, 817, 901, 920warning limit on size in bytes of a Java sessionspacejob_queue_interval716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817 job_queue_keep_connections716, 723, 732, 733, 734, 803, 804, 805, 806 job_queue_processes716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920number of job queue slave processeslarge_pool_min_alloc803, 804, 805, 806 large_pool_size803, 804, 805, 806, 815, 816, 817, 901, 920size in bytes of the large allocation poollgwr_io_slaves803, 804, 805, 806 license_max_sessions716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920maximum number of non-system user sessions allowedlicense_max_users716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920maximum number of named users that can be created in the databaslicense_sessions_warning716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920warning level for number of non-system user sessionslm_locks803, 804, 805, 806, 815, 816, 817 lm_procs803, 804, 805, 806, 815 lm_ress803, 804, 805, 806, 815, 816, 817 local_listener803, 804, 805, 806, 815, 816, 817, 901, 920local listenerlock_name_space803, 804, 805, 806, 815, 816, 817, 901, 920lock name space used for generating lock names for standby/clonelock_sga815, 816, 817, 901, 920Lock entire SGA in physical memorylog_archive_buffer_size716, 723, 732, 733, 734, 803, 804, 805, 806 log_archive_buffers716, 723, 732, 733, 734, 803, 804, 805, 806 log_archive_dest716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920archival destination text stringlog_archive_dest_n815, 816, 817 log_archive_dest_1815, 816, 817, 901, 920archival destination #1 text stringlog_archive_dest_10901, 920archival destination #10 text stringlog_archive_dest_2815, 816, 817, 901, 920archival destination #2 text stringlog_archive_dest_3815, 816, 817, 901, 920archival destination #3 text stringlog_archive_dest_4815, 816, 817, 901, 920archival destination #4 text stringlog_archive_dest_5815, 816, 817, 901, 920archival destination #5 text stringlog_archive_dest_state_n815, 816, 817 log_archive_dest_6901, 920archival destination #6 text stringlog_archive_dest_7901, 920archival destination #7 text stringlog_archive_dest_8901, 920archival destination #8 text stringlog_archive_dest_9901, 920archival destination #9 text stringlog_archive_dest_state_1815, 816, 817, 901, 920archival destination #1 state text stringlog_archive_dest_state_10901, 920archival destination #10 state text stringlog_archive_dest_state_2815, 816, 817, 901, 920archival destination #2 state text stringlog_archive_dest_state_3815, 816, 817, 901, 920archival destination #3 state text stringlog_archive_dest_state_4815, 816, 817, 901, 920archival destination #4 state text stringlog_archive_dest_state_5815, 816, 817, 901, 920archival destination #5 state text stringlog_archive_dest_state_6901, 920archival destination #6 state text stringlog_archive_dest_state_7901, 920archival destination #7 state text stringlog_archive_dest_state_8901, 920archival destination #8 state text stringlog_archive_dest_state_9901, 920archival destination #9 state text stringlog_archive_duplex_dest803, 804, 805, 806, 815, 816, 817, 901, 920duplex archival destination text stringlog_archive_format716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920archival destination formatlog_archive_max_processes815, 816, 817, 901, 920maximum number of active ARCH processeslog_archive_min_succeed_dest803, 804, 805, 806, 815, 816, 817, 901, 920minimum number of archive destinations that must succeedlog_archive_start716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920start archival process on SGA initializationlog_archive_trace816, 817, 901, 920Establish archivelog operation tracing levellog_block_checksum723, 732, 733, 734, 803, 804, 805, 806 log_buffer716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920redo circular buffer sizelog_checkpoint_interval716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920# redo blocks checkpoint thresholdlog_checkpoint_timeout716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Maximum time interval between checkpoints in secondslog_checkpoints_to_alert716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920log checkpoint begin/end to alert filelog_file_name_convert803, 804, 805, 806, 815, 816, 817, 901, 920logfile name convert patterns and strings for standby/clone dblog_file_standby_name_convert732, 733, 734 log_files716, 723, 732, 733, 734, 803, 804, 805, 806 log_simultaneous_copies716, 723, 732, 733, 734, 803, 804, 805, 806 log_small_entry_max_size716, 723, 732, 733, 734, 803, 804, 805, 806 log_parallelism920Number of log buffer strandslogmnr_max_persistent_sessions901, 920maximum number of threads to minemax_commit_propagation_delay716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Max age of new snapshot in .01 secondsmax_dispatchers901, 920max number of dispatchersmax_dump_file_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Maximum size (blocks) of dump filemax_enabled_roles716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max number of roles a user can have enabledmax_rollback_segments716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max. number of rollback segments in SGA cachemax_shared_servers901, 920max number of shared serversmax_transaction_branches716, 723, 732, 733, 734, 803, 804, 805, 806, 901max. number of branches per distributed transactionmts_circuits816, 817, 901, 920max number of circuitsmts_dispatchers716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920specifications of dispatchersmts_listener_address716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920address(es) of network listenermts_max_dispatchers716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max number of dispatchersmts_max_servers716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max number of shared serversmts_multiple_listeners732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Are multiple listeners enabled?mts_rate_log_size803, 804, 805, 806 mts_rate_scale803, 804, 805, 806 mts_servers716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920number of shared servers to start upmts_service716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920service supported by dispatchersmts_sessions816, 817, 901, 920max number of shared server sessionsnls_calendar815, 816, 817, 901, 920NLS calendar system namenls_comp815, 816, 817, 901, 920NLS comparisonnls_currency716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920NLS local currency symbolnls_date_format716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920NLS Oracle date formatnls_date_language716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920NLS date language namenls_dual_currency815, 816, 817, 901, 920Dual currency symbolnls_iso_currency716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920NLS ISO currency territory namenls_language716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920NLS language namenls_length_semantics901, 920create columns using byte or char semantics by defaultnls_nchar_conv_excp901, 920NLS raise an exception instead of allowing implicit conversionnls_numeric_characters716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920NLS numeric charactersnls_sort716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920NLS linguistic definition namenls_territory716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920NLS territory namenls_time_format815, 816, 817, 901, 920time formatnls_time_tz_format815, 816, 817, 901, 920time with timezone formatnls_timestamp_format815, 816, 817, 901, 920time stamp formatnls_timestamp_tz_format815, 816, 817, 901, 920timestampe with timezone formatobject_cache_max_size_percent803, 804, 805, 806, 815, 816, 817, 901, 920percentage of maximum size over optimal of the user session's obobject_cache_optimal_size803, 804, 805, 806, 815, 816, 817, 901, 920optimal size of the user session's object cache in bytesolap_page_pool_size920size of the olap page pool in bytesopen_cursors716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max # cursors per sessionopen_links716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max # open links per sessionopen_links_per_instance803, 804, 805, 806, 815, 816, 817, 901, 920max # open links per instanceops_admin_group803, 804, 805, 806 ops_interconnects817 optimizer_comp_weight716 optimizer_dynamic_sampling920optimizer dynamic samplingoptimizer_features_enable815, 816, 817, 901, 920optimizer plan compatibility parameteroptimizer_index_caching815, 816, 817, 901, 920optimizer percent index cachingoptimizer_index_cost_adj815, 816, 817, 901, 920optimizer index cost adjustmentoptimizer_max_permutations815, 816, 817, 901, 920optimizer maximum join permutations per query blockoptimizer_mode716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920optimizer modeoptimizer_percent_parallel732, 733, 734, 803, 804, 805, 806, 815, 816, 817 optimizer_search_limit733, 734, 803, 804, 805, 806, 815 oracle_trace_collection_name732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Oracle TRACE default collection nameoracle_trace_collection_path732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Oracle TRACE collection pathoracle_trace_collection_size732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Oracle TRACE collection file max. sizeoracle_trace_enable732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Oracle Trace enabled/disabledoracle_trace_facility_name732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Oracle TRACE default facility nameoracle_trace_facility_path732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Oracle TRACE facility pathos_authent_prefix716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920prefix for auto-logon accountsos_roles716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920retrieve roles from the operating systemparallel_adaptive_multi_user815, 816, 817, 901, 920enable adaptive setting of degree for multiple user streamsparallel_automatic_tuning815, 816, 817, 901, 920enable intelligent defaults for parallel execution parametersparallel_broadcast_enabled815, 816, 817, 901enable broadcasting of small inputs to hash and sort merge joinsparallel_default_max_instances716, 723, 732, 733, 734, 803, 804, 805, 806 parallel_default_max_scans716, 723 parallel_default_scansize716, 723 parallel_execution_message_size815, 816, 817, 901, 920message buffer size for parallel executionparallel_instance_group803, 804, 805, 806, 815, 816, 817, 901, 920instance group to use for all parallel operationsparallel_max_servers716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920maximum parallel query servers per instanceparallel_min_message_pool803, 804, 805, 806 parallel_min_percent732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920minimum percent of threads required for parallel queryparallel_min_servers716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920minimum parallel query servers per instanceparallel_server803, 804, 805, 806, 815, 816, 817, 901, 920if TRUE startup in parallel server modeparallel_server_idle_time716, 723, 732, 733, 734, 803, 804, 805, 806 parallel_server_instances815, 816, 817, 901, 920number of instances to use for sizing OPS SGA structuresparallel_threads_per_cpu815, 816, 817, 901, 920number of parallel execution threads per CPUparallel_transaction_recovery815 parallel_transaction_resource_timeout803, 804, 805, 806 partition_view_enabled732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920enable/disable partitioned viewsplsql_load_without_compile815 pga_aggregate_target901, 920Target size for the aggregate PGA memory consumed by the instancplsql_compiler_flags901, 920PL/SQL compiler flagsplsql_native_c_compiler901, 920plsql native C compilerplsql_native_library_dir901, 920plsql native library dirplsql_native_library_subdir_count901, 920plsql native library number of subdirectoriesplsql_native_linker901, 920plsql native linkerplsql_native_make_file_name901, 920plsql native compilation make fileplsql_native_make_utility901, 920plsql native compilation make utilityplsql_v2_compatibility803, 804, 805, 806, 815, 816, 817, 901, 920PL/SQL version 2.x compatibility flagpre_page_sga716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920pre-page sga for processprocesses716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920user processesquery_rewrite_enabled815, 816, 817, 901, 920allow rewrite of queries using materialized views if enabledquery_rewrite_integrity815, 816, 817, 901, 920perform rewrite using materialized views with desired integrityrdbms_server_dn815, 816, 817, 901, 920RDBMS's Distinguished Nameread_only_open_delayed815, 816, 817, 901, 920if TRUE delay opening of read only files until first accessrecovery_parallelism716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920number of server processes to use for parallel recoveryremote_archive_enable901, 920remote archivelog destinations enabledremote archival enable settingremote_dependencies_mode732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920remote-procedure-call dependencies mode parameterremote_listener901, 920remote listenerremote_login_passwordfile716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920password file usage parameterremote_os_authent716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920allow non-secure remote clients to use auto-logon accountsremote_os_roles716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920allow non-secure remote clients to use os rolesreplication_dependency_tracking803, 804, 805, 806, 815, 816, 817, 901, 920tracking dependency for Replication parallel propagationresource_limit716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920master switch for resource limitresource_manager_plan815, 816, 817, 901, 920resource mgr top planrollback_segments716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920undo segment listrow_cache_cursors716, 723, 732, 733, 734, 803, 804, 805, 806 row_locking716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920row-lockingsequence_cache_entries716, 723, 732, 733, 734, 803, 804, 805, 806 sequence_cache_hash_buckets716, 723, 732, 733, 734, 803, 804, 805, 806 serial_reuse803, 804, 805, 806, 815, 816, 817, 901, 920reuse the frame segmentsserializable716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920serializableservice_names815, 816, 817, 901, 920service names supported by the instancesession_cached_cursors716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920number of cursors to save in the session cursor cachesession_max_open_files803, 804, 805, 806, 815, 816, 817, 901, 920maximum number of open files allowed per sessionsessions716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920user and system sessionssga_max_size901, 920max total SGA sizeshadow_core_dump716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Core Size for Shadow Processesshared_memory_address716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920SGA starting address (low order 32-bits on 64-bit platforms)shared_pool_reserved_min_alloc716, 723, 732, 733, 734, 803, 804, 805, 806 shared_pool_reserved_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920size in bytes of reserved area of shared poolshared_pool_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920size in bytes of shared poolsingle_process716, 723 snapshot_refresh_interval716, 723, 732, 733, 734, 803, 804, 805, 806 snapshot_refresh_keep_connections716, 723, 732, 733, 734, 803, 804, 805, 806 snapshot_refresh_processes716, 723, 732, 733, 734, 803, 804, 805, 806 shared_server_sessions901, 920max number of shared server sessionsshared_servers901, 920number of shared servers to start upsort_area_retained_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920size of in-memory sort work area retained between fetch callssort_area_size716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920size of in-memory sort work areasort_direct_writes723, 732, 733, 734, 803, 804, 805, 806 sort_mts_buffer_for_fetch_size716 sort_multiblock_read_count815, 816, 817 sort_read_fac716, 723, 732, 733, 734, 803, 804, 805, 806 sort_spacemap_size716, 723, 732, 733, 734, 803, 804, 805, 806 sort_write_buffer_size723, 732, 733, 734, 803, 804, 805, 806 sort_write_buffers723, 732, 733, 734, 803, 804, 805, 806 spin_count716, 723, 732, 733, 734, 803, 804, 805, 806 spread_extents803, 804, 805, 806 spfile901, 920server parameter filesql92_security716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920require select privilege for searched update/deletesql_trace716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920enable SQL tracesql_version816, 817, 901, 920sql language version parameter for compatibility issuesstandby_archive_dest815, 816, 817, 901, 920standby database archivelog destination text stringstandby_file_management901, 920if auto then files are created/dropped automatically on standbystandby_preserves_names901File names on standby are the same as on the primary.star_transformation_enabled803, 804, 805, 806, 815, 816, 817, 901, 920enable the use of star transformationstatistics_level920statistics leveltape_asynch_io803, 804, 805, 806, 815, 816, 817, 901, 920Use asynch I/O requests for tape devicestemporary_sort_file_dest716, 723, 732 temporary_table_locks716, 723, 732, 733, 734, 803, 804, 805, 806 text_enable732, 733, 734, 803, 804, 805, 806, 815, 816, 817 thread716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920Redo thread to mounttimed_os_statistics803, 804, 805, 806, 815, 816, 817, 901, 920internal os statistic gathering interval in secondstimed_statistics716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920maintain internal timing statisticstrace_enabled901, 920enable KST tracingtracefile_identifier817, 901, 920trace file custom identifiertransaction_auditing803, 804, 805, 806, 815, 816, 817, 901, 920transaction auditing records generated in the redo logtransactions716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920max. number of concurrent active transactionstransactions_per_rollback_segment716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920number of active transactions per rollback segmentunlimited_rollback_segments733, 734 undo_management901, 920instance runs in SMU mode if TRUE, else in RBU modeundo_retention901, 920undo retention in secondsundo_suppress_errors901, 920Suppress RBU errors in SMU modeundo_tablespace901, 920use/switch undo tablespaceuse_indirect_data_buffers815, 816, 817, 901, 920Enable indirect data buffers (very large SGA on 32-bit platformsuse_readv716, 723, 732, 733, 734 use_sigio733, 734 user_dump_dest716, 723, 732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920User process dump directoryutl_file_dir732, 733, 734, 803, 804, 805, 806, 815, 816, 817, 901, 920utl_file accessible directories listv733_plans_enabled732, 733, 734 vlm_sga_base_address723, 732, 733, 734, 803, 804, 805, 806 workarea_size_policy901, 920policy used to size SQL working areas (MANUAL/AUTO)