System Parameters with Non-Default or Modified Values
Collected from GV$SYSTEM_PARAMETER2 where isdefault = 'FALSE' OR ismodified != 'FALSE'. "Is Default" = FALSE means the parameter was set in the spfile.
| # | Name | Inst | Ord | Is Default | Is Modified | Value | Display Value | Description |
|---|---|---|---|---|---|---|---|---|
| 1 | _aggregation_optimization_settings | 1 | 1 | FALSE | FALSE | settings for aggregation optimizations | ||
| 2 | _always_anti_join | 1 | 1 | FALSE | FALSE | CHOOSE | always use this method for anti-join when possible | |
| 3 | _always_semi_join | 1 | 1 | FALSE | FALSE | CHOOSE | always use this method for semi-join when possible | |
| 4 | _and_pruning_enabled | 1 | 1 | FALSE | FALSE | TRUE | allow partition pruning based on multiple mechanisms | |
| 5 | _b_tree_bitmap_plans | 1 | 1 | FALSE | FALSE | TRUE | enable the use of bitmap plans for tables w. only B-tree indexes | |
| 6 | _bloom_filter_enabled | 1 | 1 | FALSE | FALSE | TRUE | enables or disables bloom filter | |
| 7 | _bloom_folding_enabled | 1 | 1 | FALSE | FALSE | TRUE | Enable folding of bloom filter | |
| 8 | _bloom_pruning_enabled | 1 | 1 | FALSE | FALSE | TRUE | Enable partition pruning using bloom filtering | |
| 9 | _complex_view_merging | 1 | 1 | FALSE | FALSE | TRUE | enable complex view merging | |
| 10 | _compression_compatibility | 1 | 1 | FALSE | FALSE | 11.2.0 | Compression compatability | |
| 11 | _connect_by_use_union_all | 1 | 1 | FALSE | FALSE | TRUE | use union all for connect by | |
| 12 | _convert_set_to_join | 1 | 1 | FALSE | FALSE | FALSE | enables conversion of set operator to join | |
| 13 | _cost_equality_semi_join | 1 | 1 | FALSE | FALSE | TRUE | enables costing of equality semi-join | |
| 14 | _cpu_to_io | 1 | 1 | FALSE | FALSE | divisor for converting CPU cost to I/O cost | ||
| 15 | _dimension_skip_null | 1 | 1 | FALSE | FALSE | TRUE | control dimension skip when null feature | |
| 16 | _eliminate_common_subexpr | 1 | 1 | FALSE | FALSE | TRUE | enables elimination of common sub-expressions | |
| 17 | _enable_type_dep_selectivity | 1 | 1 | FALSE | FALSE | TRUE | enable type dependent selectivity estimates | |
| 18 | _fast_full_scan_enabled | 1 | 1 | FALSE | FALSE | TRUE | enable/disable index fast full scan | |
| 19 | _first_k_rows_dynamic_proration | 1 | 1 | FALSE | FALSE | TRUE | enable the use of dynamic proration of join cardinalities | |
| 20 | _gby_hash_aggregation_enabled | 1 | 1 | FALSE | FALSE | TRUE | enable group-by and aggregation using hash scheme | |
| 21 | _generalized_pruning_enabled | 1 | 1 | FALSE | FALSE | TRUE | controls extensions to partition pruning for general predicates | |
| 22 | _globalindex_pnum_filter_enabled | 1 | 1 | FALSE | FALSE | TRUE | enables filter for global index with partition extended syntax | |
| 23 | _gs_anti_semi_join_allowed | 1 | 1 | FALSE | FALSE | TRUE | enable anti/semi join for the GS query | |
| 24 | _improved_outerjoin_card | 1 | 1 | FALSE | FALSE | TRUE | improved outer-join cardinality calculation | |
| 25 | _improved_row_length_enabled | 1 | 1 | FALSE | FALSE | TRUE | enable the improvements for computing the average row length | |
| 26 | _index_join_enabled | 1 | 1 | FALSE | FALSE | TRUE | enable the use of index joins | |
| 27 | _ksb_restart_policy_times | 1 | 1 | FALSE | FALSE | process restart policy times in seconds | ||
| 28 | _ksb_restart_policy_times | 1 | 2 | FALSE | FALSE | 60 | process restart policy times in seconds | |
| 29 | _ksb_restart_policy_times | 1 | 3 | FALSE | FALSE | 120 | process restart policy times in seconds | |
| 30 | _ksb_restart_policy_times | 1 | 4 | FALSE | FALSE | 240 | process restart policy times in seconds | |
| 31 | _left_nested_loops_random | 1 | 1 | FALSE | FALSE | TRUE | enable random distribution method for left of nestedloops | |
| 32 | _local_communication_costing_enabled | 1 | 1 | FALSE | FALSE | TRUE | enable local communication costing when TRUE | |
| 33 | _minimal_stats_aggregation | 1 | 1 | FALSE | FALSE | TRUE | prohibit stats aggregation at compile/partition maintenance time | |
| 34 | _mmv_query_rewrite_enabled | 1 | 1 | FALSE | FALSE | TRUE | allow rewrites with multiple MVs and/or base tables | |
| 35 | _new_initial_join_orders | 1 | 1 | FALSE | FALSE | TRUE | enable initial join orders based on new ordering heuristics | |
| 36 | _new_sort_cost_estimate | 1 | 1 | FALSE | FALSE | TRUE | enables the use of new cost estimate for sort | |
| 37 | _nlj_batching_enabled | 1 | 1 | FALSE | FALSE | 1 | enable batching of the RHS IO in NLJ | |
| 38 | _optim_adjust_for_part_skews | 1 | 1 | FALSE | FALSE | TRUE | adjust stats for skews across partitions | |
| 39 | _optim_enhance_nnull_detection | 1 | 1 | FALSE | FALSE | TRUE | TRUE to enable index [fast] full scan more often | |
| 40 | _optim_new_default_join_sel | 1 | 1 | FALSE | FALSE | TRUE | improves the way default equijoin selectivity are computed | |
| 41 | _optim_peek_user_binds | 1 | 1 | FALSE | FALSE | TRUE | enable peeking of user binds | |
| 42 | _optimizer_adaptive_cursor_sharing | 1 | 1 | FALSE | FALSE | TRUE | optimizer adaptive cursor sharing | |
| 43 | _optimizer_better_inlist_costing | 1 | 1 | FALSE | FALSE | ALL | enable improved costing of index access using in-list(s) | |
| 44 | _optimizer_cbqt_no_size_restriction | 1 | 1 | FALSE | FALSE | TRUE | disable cost based transformation query size restriction | |
| 45 | _optimizer_coalesce_subqueries | 1 | 1 | FALSE | FALSE | TRUE | consider coalescing of subqueries optimization | |
| 46 | _optimizer_complex_pred_selectivity | 1 | 1 | FALSE | FALSE | TRUE | enable selectivity estimation for builtin functions | |
| 47 | _optimizer_compute_index_stats | 1 | 1 | FALSE | FALSE | TRUE | force index stats collection on index creation/rebuild | |
| 48 | _optimizer_connect_by_combine_sw | 1 | 1 | FALSE | FALSE | TRUE | combine no filtering connect by and start with | |
| 49 | _optimizer_connect_by_cost_based | 1 | 1 | FALSE | FALSE | TRUE | use cost-based transformation for connect by | |
| 50 | _optimizer_connect_by_elim_dups | 1 | 1 | FALSE | FALSE | TRUE | allow connect by to eliminate duplicates from input | |
| 51 | _optimizer_correct_sq_selectivity | 1 | 1 | FALSE | FALSE | TRUE | force correct computation of subquery selectivity | |
| 52 | _optimizer_cost_based_transformation | 1 | 1 | FALSE | FALSE | LINEAR | enables cost-based query transformation | |
| 53 | _optimizer_cost_hjsmj_multimatch | 1 | 1 | FALSE | FALSE | TRUE | add cost of generating result set when #rows per key > 1 | |
| 54 | _optimizer_cost_model | 1 | 1 | FALSE | FALSE | CHOOSE | optimizer cost model | |
| 55 | _optimizer_dim_subq_join_sel | 1 | 1 | FALSE | FALSE | TRUE | use join selectivity in choosing star transformation dimensions | |
| 56 | _optimizer_distinct_agg_transform | 1 | 1 | FALSE | FALSE | TRUE | Transforms Distinct Aggregates to non-distinct aggregates | |
| 57 | _optimizer_distinct_elimination | 1 | 1 | FALSE | FALSE | TRUE | Eliminates redundant SELECT DISTNCT's | |
| 58 | _optimizer_distinct_placement | 1 | 1 | FALSE | FALSE | TRUE | consider distinct placement optimization | |
| 59 | _optimizer_eliminate_filtering_join | 1 | 1 | FALSE | FALSE | TRUE | optimizer filtering join elimination enabled | |
| 60 | _optimizer_enable_density_improvements | 1 | 1 | FALSE | FALSE | TRUE | use improved density computation for selectivity estimation | |
| 61 | _optimizer_enable_extended_stats | 1 | 1 | FALSE | FALSE | TRUE | use extended statistics for selectivity estimation | |
| 62 | _optimizer_enable_table_lookup_by_nl | 1 | 1 | FALSE | FALSE | TRUE | consider table lookup by nl transformation | |
| 63 | _optimizer_enhanced_filter_push | 1 | 1 | FALSE | FALSE | TRUE | push filters before trying cost-based query transformation | |
| 64 | _optimizer_extend_jppd_view_types | 1 | 1 | FALSE | FALSE | TRUE | join pred pushdown on group-by, distinct, semi-/anti-joined view | |
| 65 | _optimizer_extended_cursor_sharing | 1 | 1 | FALSE | FALSE | UDO | optimizer extended cursor sharing | |
| 66 | _optimizer_extended_cursor_sharing_rel | 1 | 1 | FALSE | FALSE | SIMPLE | optimizer extended cursor sharing for relational operators | |
| 67 | _optimizer_extended_stats_usage_control | 1 | 1 | FALSE | FALSE | 192 | controls the optimizer usage of extended stats | |
| 68 | _optimizer_false_filter_pred_pullup | 1 | 1 | FALSE | FALSE | TRUE | optimizer false predicate pull up transformation | |
| 69 | _optimizer_fast_access_pred_analysis | 1 | 1 | FALSE | FALSE | TRUE | use fast algorithm to traverse predicates for physical optimizer | |
| 70 | _optimizer_fast_pred_transitivity | 1 | 1 | FALSE | FALSE | TRUE | use fast algorithm to generate transitive predicates | |
| 71 | _optimizer_filter_pred_pullup | 1 | 1 | FALSE | FALSE | TRUE | use cost-based flter predicate pull up transformation | |
| 72 | _optimizer_fkr_index_cost_bias | 1 | 1 | FALSE | FALSE | 10 | Optimizer index bias over FTS/IFFS under first K rows mode | |
| 73 | _optimizer_full_outer_join_to_outer | 1 | 1 | FALSE | FALSE | TRUE | enable/disable full outer to left outer join conversion | |
| 74 | _optimizer_group_by_placement | 1 | 1 | FALSE | FALSE | TRUE | consider group-by placement optimization | |
| 75 | _optimizer_improve_selectivity | 1 | 1 | FALSE | FALSE | TRUE | improve table and partial overlap join selectivity computation | |
| 76 | _optimizer_interleave_jppd | 1 | 1 | FALSE | FALSE | TRUE | interleave join predicate pushdown during CBQT | |
| 77 | _optimizer_join_elimination_enabled | 1 | 1 | FALSE | FALSE | TRUE | optimizer join elimination enabled | |
| 78 | _optimizer_join_factorization | 1 | 1 | FALSE | FALSE | TRUE | use join factorization transformation | |
| 79 | _optimizer_join_order_control | 1 | 1 | FALSE | FALSE | 3 | controls the optimizer join order search algorithm | |
| 80 | _optimizer_join_sel_sanity_check | 1 | 1 | FALSE | FALSE | TRUE | enable/disable sanity check for multi-column join selectivity | |
| 81 | _optimizer_max_permutations | 1 | 1 | FALSE | FALSE | 2000 | optimizer maximum join permutations per query block | |
| 82 | _optimizer_mode_force | 1 | 1 | FALSE | FALSE | TRUE | force setting of optimizer mode for user recursive SQL also | |
| 83 | _optimizer_multi_level_push_pred | 1 | 1 | FALSE | FALSE | TRUE | consider join-predicate pushdown that requires multi-level pushdown to base table | |
| 84 | _optimizer_native_full_outer_join | 1 | 1 | FALSE | FALSE | FORCE | execute full outer join using native implementaion | |
| 85 | _optimizer_new_join_card_computation | 1 | 1 | FALSE | FALSE | TRUE | compute join cardinality using non-rounded input values | |
| 86 | _optimizer_null_aware_antijoin | 1 | 1 | FALSE | FALSE | TRUE | null-aware antijoin parameter | |
| 87 | _optimizer_or_expansion | 1 | 1 | FALSE | FALSE | DEPTH | control or expansion approach used | |
| 88 | _optimizer_order_by_elimination_enabled | 1 | 1 | FALSE | FALSE | TRUE | Eliminates order bys from views before query transformation | |
| 89 | _optimizer_outer_join_to_inner | 1 | 1 | FALSE | FALSE | TRUE | enable/disable outer to inner join conversion | |
| 90 | _optimizer_outer_to_anti_enabled | 1 | 1 | FALSE | FALSE | TRUE | Enable transformation of outer-join to anti-join if possible | |
| 91 | _optimizer_push_down_distinct | 1 | 1 | FALSE | FALSE | push down distinct from query block to table | ||
| 92 | _optimizer_push_pred_cost_based | 1 | 1 | FALSE | FALSE | TRUE | use cost-based query transformation for push pred optimization | |
| 93 | _optimizer_rownum_bind_default | 1 | 1 | FALSE | FALSE | 10 | Default value to use for rownum bind | |
| 94 | _optimizer_rownum_pred_based_fkr | 1 | 1 | FALSE | FALSE | TRUE | enable the use of first K rows due to rownum predicate | |
| 95 | _optimizer_skip_scan_enabled | 1 | 1 | FALSE | FALSE | TRUE | enable/disable index skip scan | |
| 96 | _optimizer_sortmerge_join_inequality | 1 | 1 | FALSE | FALSE | TRUE | enable/disable sort-merge join using inequality predicates | |
| 97 | _optimizer_squ_bottomup | 1 | 1 | FALSE | FALSE | TRUE | enables unnesting of subquery in a bottom-up manner | |
| 98 | _optimizer_star_tran_in_with_clause | 1 | 1 | FALSE | FALSE | TRUE | enable/disable star transformation in with clause queries | |
| 99 | _optimizer_system_stats_usage | 1 | 1 | FALSE | FALSE | TRUE | system statistics usage | |
| 100 | _optimizer_table_expansion | 1 | 1 | FALSE | FALSE | TRUE | consider table expansion transformation | |
| 101 | _optimizer_transitivity_retain | 1 | 1 | FALSE | FALSE | TRUE | retain equi-join pred upon transitive equality pred generation | |
| 102 | _optimizer_try_st_before_jppd | 1 | 1 | FALSE | FALSE | TRUE | try Star Transformation before Join Predicate Push Down | |
| 103 | _optimizer_undo_cost_change | 1 | 1 | FALSE | FALSE | 11.2.0.3 | optimizer undo cost change | |
| 104 | _optimizer_unnest_corr_set_subq | 1 | 1 | FALSE | FALSE | TRUE | Unnesting of correlated set subqueries (TRUE/FALSE) | |
| 105 | _optimizer_unnest_disjunctive_subq | 1 | 1 | FALSE | FALSE | TRUE | Unnesting of disjunctive subqueries (TRUE/FALSE) | |
| 106 | _optimizer_use_cbqt_star_transformation | 1 | 1 | FALSE | FALSE | TRUE | use rewritten star transformation using cbqt framework | |
| 107 | _optimizer_use_feedback | 1 | 1 | FALSE | FALSE | TRUE | optimizer use feedback | |
| 108 | _or_expand_nvl_predicate | 1 | 1 | FALSE | FALSE | TRUE | enable OR expanded plan for NVL/DECODE predicate | |
| 109 | _ordered_nested_loop | 1 | 1 | FALSE | FALSE | TRUE | enable ordered nested loop costing | |
| 110 | _parallel_broadcast_enabled | 1 | 1 | FALSE | FALSE | TRUE | enable broadcasting of small inputs to hash and sort merge joins | |
| 111 | _partition_view_enabled | 1 | 1 | FALSE | FALSE | TRUE | enable/disable partitioned views | |
| 112 | _pivot_implementation_method | 1 | 1 | FALSE | FALSE | CHOOSE | pivot implementation method | |
| 113 | _pre_rewrite_push_pred | 1 | 1 | FALSE | FALSE | TRUE | push predicates into views before rewrite | |
| 114 | _pred_move_around | 1 | 1 | FALSE | FALSE | TRUE | enables predicate move-around | |
| 115 | _push_join_predicate | 1 | 1 | FALSE | FALSE | TRUE | enable pushing join predicate inside a view | |
| 116 | _push_join_union_view | 1 | 1 | FALSE | FALSE | TRUE | enable pushing join predicate inside a union all view | |
| 117 | _push_join_union_view2 | 1 | 1 | FALSE | FALSE | TRUE | enable pushing join predicate inside a union view | |
| 118 | _px_minus_intersect | 1 | 1 | FALSE | FALSE | TRUE | enables pq for minus/interect operators | |
| 119 | _px_partition_scan_enabled | 1 | 1 | FALSE | FALSE | TRUE | enables or disables parallel partition-based scan | |
| 120 | _px_pwg_enabled | 1 | 1 | FALSE | FALSE | TRUE | parallel partition wise group by enabled | |
| 121 | _px_ual_serial_input | 1 | 1 | FALSE | FALSE | TRUE | enables new pq for UNION operators | |
| 122 | _query_on_physical | 1 | 1 | FALSE | FALSE | FALSE | query on physical | |
| 123 | _query_rewrite_setopgrw_enable | 1 | 1 | FALSE | FALSE | TRUE | perform general rewrite using set operator summaries | |
| 124 | _remove_aggr_subquery | 1 | 1 | FALSE | FALSE | TRUE | enables removal of subsumed aggregated subquery | |
| 125 | _replace_virtual_columns | 1 | 1 | FALSE | FALSE | TRUE | replace expressions with virtual columns | |
| 126 | _right_outer_hash_enable | 1 | 1 | FALSE | FALSE | TRUE | Right Outer/Semi/Anti Hash Enabled | |
| 127 | _selfjoin_mv_duplicates | 1 | 1 | FALSE | FALSE | TRUE | control rewrite self-join algorithm | |
| 128 | _sql_model_unfold_forloops | 1 | 1 | FALSE | FALSE | RUN_TIME | specifies compile-time unfolding of sql model forloops | |
| 129 | _subquery_pruning_enabled | 1 | 1 | FALSE | FALSE | TRUE | enable the use of subquery predicates to perform pruning | |
| 130 | _subquery_pruning_mv_enabled | 1 | 1 | FALSE | FALSE | FALSE | enable the use of subquery predicates with MVs to perform pruning | |
| 131 | _table_scan_cost_plus_one | 1 | 1 | FALSE | FALSE | TRUE | bump estimated full table scan and index ffs cost by one | |
| 132 | _union_rewrite_for_gs | 1 | 1 | FALSE | FALSE | YES_GSET_MVS | expand queries with GSets into UNIONs for rewrite | |
| 133 | _unnest_subquery | 1 | 1 | FALSE | FALSE | TRUE | enables unnesting of complex subqueries | |
| 134 | _use_column_stats_for_function | 1 | 1 | FALSE | FALSE | TRUE | enable the use of column statistics for DDP functions | |
| 135 | audit_file_dest | 1 | 1 | FALSE | FALSE | /apps/oracle/diag/rdbms/klt2wdx0/KLT2WDX0/audit | Directory in which auditing files are to reside | |
| 136 | audit_trail | 1 | 1 | FALSE | FALSE | NONE | enable system auditing | |
| 137 | background_dump_dest | 1 | 1 | FALSE | FALSE | /apps/oracle/diag/rdbms/klt2wdx0/KLT2WDX0/trace | Detached process dump directory | |
| 138 | compatible | 1 | 1 | FALSE | FALSE | 11.2.0 | Database will be completely compatible with this software version | |
| 139 | control_file_record_keep_time | 1 | 1 | FALSE | FALSE | 30 | control file record keep time in days | |
| 140 | control_files | 1 | 1 | FALSE | FALSE | /apps/oradata01/KLT2WDX0/onlinelog/ctl01.ctl | control file names list | |
| 141 | control_files | 1 | 2 | FALSE | FALSE | /apps/oradata02/KLT2WDX0/onlinelog/ctl02.ctl | control file names list | |
| 142 | control_management_pack_access | 1 | 1 | FALSE | FALSE | DIAGNOSTIC+TUNING | declares which manageability packs are enabled | |
| 143 | core_dump_dest | 1 | 1 | FALSE | FALSE | /apps/oracle/diag/rdbms/klt2wdp0/KLT2WDX0/cdump | Core dump directory | |
| 144 | db_block_size | 1 | 1 | FALSE | FALSE | 8192 | Size of database block in bytes | |
| 145 | db_cache_size | 1 | 1 | FALSE | FALSE | 16777216 | 16M | Size of DEFAULT buffer pool for standard block size buffers |
| 146 | db_create_file_dest | 1 | 1 | FALSE | FALSE | /apps/oradata01 | default database location | |
| 147 | db_create_online_log_dest_1 | 1 | 1 | FALSE | FALSE | /apps/oradata01/ | online log/controlfile destination #1 | |
| 148 | db_create_online_log_dest_2 | 1 | 1 | FALSE | FALSE | /apps/oradata02/ | online log/controlfile destination #2 | |
| 149 | db_domain | 1 | 1 | FALSE | FALSE | directory part of global database name stored with CREATE DATABASE | ||
| 150 | db_file_name_convert | 1 | 1 | FALSE | FALSE | KLT2WDP0 | datafile name convert patterns and strings for standby/clone db | |
| 151 | db_file_name_convert | 1 | 2 | FALSE | FALSE | KLT2WDX0 | datafile name convert patterns and strings for standby/clone db | |
| 152 | db_name | 1 | 1 | FALSE | FALSE | KLT2WDX0 | database name specified in CREATE DATABASE | |
| 153 | db_recovery_file_dest | 1 | 1 | FALSE | FALSE | /apps/orafra/ | default database recovery file location | |
| 154 | db_recovery_file_dest_size | 1 | 1 | FALSE | FALSE | 98784247808 | 92G | database recovery files size limit |
| 155 | deferred_segment_creation | 1 | 1 | FALSE | FALSE | FALSE | defer segment creation to first insert | |
| 156 | diagnostic_dest | 1 | 1 | FALSE | FALSE | /apps/oracle | diagnostic base directory | |
| 157 | filesystemio_options | 1 | 1 | FALSE | FALSE | setall | IO operations on filesystem files | |
| 158 | job_queue_processes | 1 | 1 | FALSE | FALSE | 1 | maximum number of job queue slave processes | |
| 159 | large_pool_size | 1 | 1 | FALSE | FALSE | 33554432 | 32M | size in bytes of large pool |
| 160 | log_archive_format | 1 | 1 | FALSE | FALSE | KLT2WDX0_%r_%t_%s.arc | archival destination format | |
| 161 | log_buffer | 1 | 1 | FALSE | FALSE | 4923392 | redo circular buffer size | |
| 162 | log_file_name_convert | 1 | 1 | FALSE | FALSE | KLT2WDP0 | logfile name convert patterns and strings for standby/clone db | |
| 163 | log_file_name_convert | 1 | 2 | FALSE | FALSE | KLT2WDX0 | logfile name convert patterns and strings for standby/clone db | |
| 164 | memory_max_target | 1 | 1 | FALSE | FALSE | 2097152000 | 2000M | Max size for Memory Target |
| 165 | memory_target | 1 | 1 | FALSE | FALSE | 2097152000 | 2000M | Target size of Oracle SGA and PGA memory |
| 166 | open_cursors | 1 | 1 | FALSE | FALSE | 1500 | max # cursors per session | |
| 167 | optimizer_dynamic_sampling | 1 | 1 | FALSE | FALSE | 2 | optimizer dynamic sampling | |
| 168 | optimizer_mode | 1 | 1 | FALSE | FALSE | ALL_ROWS | optimizer mode | |
| 169 | plsql_warnings | 1 | 1 | FALSE | FALSE | DISABLE:ALL | PL/SQL compiler warnings settings | |
| 170 | processes | 1 | 1 | FALSE | FALSE | 300 | user processes | |
| 171 | query_rewrite_enabled | 1 | 1 | FALSE | FALSE | TRUE | allow rewrite of queries using materialized views if enabled | |
| 172 | remote_login_passwordfile | 1 | 1 | FALSE | FALSE | EXCLUSIVE | password file usage parameter | |
| 173 | result_cache_max_size | 1 | 1 | FALSE | FALSE | 5242880 | 5M | maximum amount of memory to be used by the cache |
| 174 | sec_case_sensitive_logon | 1 | 1 | FALSE | FALSE | FALSE | case sensitive password enabled for logon | |
| 175 | skip_unusable_indexes | 1 | 1 | FALSE | FALSE | TRUE | skip unusable indexes if set to TRUE | |
| 176 | undo_management | 1 | 1 | FALSE | FALSE | AUTO | instance runs in SMU mode if TRUE, else in RBU mode | |
| 177 | undo_retention | 1 | 1 | FALSE | FALSE | 1800 | undo retention in seconds | |
| 178 | undo_tablespace | 1 | 1 | FALSE | FALSE | UNDOTBS_1 | use/switch undo tablespace | |
| 179 | user_dump_dest | 1 | 1 | FALSE | FALSE | /apps/oracle/diag/rdbms/klt2wdx0/KLT2WDX0/trace | User process dump directory | |
| # | Name | Inst | Ord | Is Default | Is Modified | Value | Display Value | Description |
Instance Parameters
System Parameters collected from V$SYSTEM_PARAMETER2 for Instance number 1.
| # | Name | Ord | Is Default | Is Modified | Value | Display Value | Description |
|---|---|---|---|---|---|---|---|
| 1 | O7_DICTIONARY_ACCESSIBILITY | 1 | TRUE | FALSE | FALSE | Version 7 Dictionary Accessibility Support | |
| 2 | _aggregation_optimization_settings | 1 | FALSE | FALSE | settings for aggregation optimizations | ||
| 3 | _always_anti_join | 1 | FALSE | FALSE | CHOOSE | always use this method for anti-join when possible | |
| 4 | _always_semi_join | 1 | FALSE | FALSE | CHOOSE | always use this method for semi-join when possible | |
| 5 | _and_pruning_enabled | 1 | FALSE | FALSE | TRUE | allow partition pruning based on multiple mechanisms | |
| 6 | _b_tree_bitmap_plans | 1 | FALSE | FALSE | TRUE | enable the use of bitmap plans for tables w. only B-tree indexes | |
| 7 | _bloom_filter_enabled | 1 | FALSE | FALSE | TRUE | enables or disables bloom filter | |
| 8 | _bloom_folding_enabled | 1 | FALSE | FALSE | TRUE | Enable folding of bloom filter | |
| 9 | _bloom_pruning_enabled | 1 | FALSE | FALSE | TRUE | Enable partition pruning using bloom filtering | |
| 10 | _complex_view_merging | 1 | FALSE | FALSE | TRUE | enable complex view merging | |
| 11 | _compression_compatibility | 1 | FALSE | FALSE | 11.2.0 | Compression compatability | |
| 12 | _connect_by_use_union_all | 1 | FALSE | FALSE | TRUE | use union all for connect by | |
| 13 | _convert_set_to_join | 1 | FALSE | FALSE | FALSE | enables conversion of set operator to join | |
| 14 | _cost_equality_semi_join | 1 | FALSE | FALSE | TRUE | enables costing of equality semi-join | |
| 15 | _cpu_to_io | 1 | FALSE | FALSE | divisor for converting CPU cost to I/O cost | ||
| 16 | _dimension_skip_null | 1 | FALSE | FALSE | TRUE | control dimension skip when null feature | |
| 17 | _eliminate_common_subexpr | 1 | FALSE | FALSE | TRUE | enables elimination of common sub-expressions | |
| 18 | _enable_type_dep_selectivity | 1 | FALSE | FALSE | TRUE | enable type dependent selectivity estimates | |
| 19 | _fast_full_scan_enabled | 1 | FALSE | FALSE | TRUE | enable/disable index fast full scan | |
| 20 | _first_k_rows_dynamic_proration | 1 | FALSE | FALSE | TRUE | enable the use of dynamic proration of join cardinalities | |
| 21 | _gby_hash_aggregation_enabled | 1 | FALSE | FALSE | TRUE | enable group-by and aggregation using hash scheme | |
| 22 | _generalized_pruning_enabled | 1 | FALSE | FALSE | TRUE | controls extensions to partition pruning for general predicates | |
| 23 | _globalindex_pnum_filter_enabled | 1 | FALSE | FALSE | TRUE | enables filter for global index with partition extended syntax | |
| 24 | _gs_anti_semi_join_allowed | 1 | FALSE | FALSE | TRUE | enable anti/semi join for the GS query | |
| 25 | _improved_outerjoin_card | 1 | FALSE | FALSE | TRUE | improved outer-join cardinality calculation | |
| 26 | _improved_row_length_enabled | 1 | FALSE | FALSE | TRUE | enable the improvements for computing the average row length | |
| 27 | _index_join_enabled | 1 | FALSE | FALSE | TRUE | enable the use of index joins | |
| 28 | _ksb_restart_policy_times | 1 | FALSE | FALSE | process restart policy times in seconds | ||
| 29 | _ksb_restart_policy_times | 2 | FALSE | FALSE | 60 | process restart policy times in seconds | |
| 30 | _ksb_restart_policy_times | 3 | FALSE | FALSE | 120 | process restart policy times in seconds | |
| 31 | _ksb_restart_policy_times | 4 | FALSE | FALSE | 240 | process restart policy times in seconds | |
| 32 | _left_nested_loops_random | 1 | FALSE | FALSE | TRUE | enable random distribution method for left of nestedloops | |
| 33 | _local_communication_costing_enabled | 1 | FALSE | FALSE | TRUE | enable local communication costing when TRUE | |
| 34 | _minimal_stats_aggregation | 1 | FALSE | FALSE | TRUE | prohibit stats aggregation at compile/partition maintenance time | |
| 35 | _mmv_query_rewrite_enabled | 1 | FALSE | FALSE | TRUE | allow rewrites with multiple MVs and/or base tables | |
| 36 | _new_initial_join_orders | 1 | FALSE | FALSE | TRUE | enable initial join orders based on new ordering heuristics | |
| 37 | _new_sort_cost_estimate | 1 | FALSE | FALSE | TRUE | enables the use of new cost estimate for sort | |
| 38 | _nlj_batching_enabled | 1 | FALSE | FALSE | 1 | enable batching of the RHS IO in NLJ | |
| 39 | _optim_adjust_for_part_skews | 1 | FALSE | FALSE | TRUE | adjust stats for skews across partitions | |
| 40 | _optim_enhance_nnull_detection | 1 | FALSE | FALSE | TRUE | TRUE to enable index [fast] full scan more often | |
| 41 | _optim_new_default_join_sel | 1 | FALSE | FALSE | TRUE | improves the way default equijoin selectivity are computed | |
| 42 | _optim_peek_user_binds | 1 | FALSE | FALSE | TRUE | enable peeking of user binds | |
| 43 | _optimizer_adaptive_cursor_sharing | 1 | FALSE | FALSE | TRUE | optimizer adaptive cursor sharing | |
| 44 | _optimizer_better_inlist_costing | 1 | FALSE | FALSE | ALL | enable improved costing of index access using in-list(s) | |
| 45 | _optimizer_cbqt_no_size_restriction | 1 | FALSE | FALSE | TRUE | disable cost based transformation query size restriction | |
| 46 | _optimizer_coalesce_subqueries | 1 | FALSE | FALSE | TRUE | consider coalescing of subqueries optimization | |
| 47 | _optimizer_complex_pred_selectivity | 1 | FALSE | FALSE | TRUE | enable selectivity estimation for builtin functions | |
| 48 | _optimizer_compute_index_stats | 1 | FALSE | FALSE | TRUE | force index stats collection on index creation/rebuild | |
| 49 | _optimizer_connect_by_combine_sw | 1 | FALSE | FALSE | TRUE | combine no filtering connect by and start with | |
| 50 | _optimizer_connect_by_cost_based | 1 | FALSE | FALSE | TRUE | use cost-based transformation for connect by | |
| 51 | _optimizer_connect_by_elim_dups | 1 | FALSE | FALSE | TRUE | allow connect by to eliminate duplicates from input | |
| 52 | _optimizer_correct_sq_selectivity | 1 | FALSE | FALSE | TRUE | force correct computation of subquery selectivity | |
| 53 | _optimizer_cost_based_transformation | 1 | FALSE | FALSE | LINEAR | enables cost-based query transformation | |
| 54 | _optimizer_cost_hjsmj_multimatch | 1 | FALSE | FALSE | TRUE | add cost of generating result set when #rows per key > 1 | |
| 55 | _optimizer_cost_model | 1 | FALSE | FALSE | CHOOSE | optimizer cost model | |
| 56 | _optimizer_dim_subq_join_sel | 1 | FALSE | FALSE | TRUE | use join selectivity in choosing star transformation dimensions | |
| 57 | _optimizer_distinct_agg_transform | 1 | FALSE | FALSE | TRUE | Transforms Distinct Aggregates to non-distinct aggregates | |
| 58 | _optimizer_distinct_elimination | 1 | FALSE | FALSE | TRUE | Eliminates redundant SELECT DISTNCT's | |
| 59 | _optimizer_distinct_placement | 1 | FALSE | FALSE | TRUE | consider distinct placement optimization | |
| 60 | _optimizer_eliminate_filtering_join | 1 | FALSE | FALSE | TRUE | optimizer filtering join elimination enabled | |
| 61 | _optimizer_enable_density_improvements | 1 | FALSE | FALSE | TRUE | use improved density computation for selectivity estimation | |
| 62 | _optimizer_enable_extended_stats | 1 | FALSE | FALSE | TRUE | use extended statistics for selectivity estimation | |
| 63 | _optimizer_enable_table_lookup_by_nl | 1 | FALSE | FALSE | TRUE | consider table lookup by nl transformation | |
| 64 | _optimizer_enhanced_filter_push | 1 | FALSE | FALSE | TRUE | push filters before trying cost-based query transformation | |
| 65 | _optimizer_extend_jppd_view_types | 1 | FALSE | FALSE | TRUE | join pred pushdown on group-by, distinct, semi-/anti-joined view | |
| 66 | _optimizer_extended_cursor_sharing | 1 | FALSE | FALSE | UDO | optimizer extended cursor sharing | |
| 67 | _optimizer_extended_cursor_sharing_rel | 1 | FALSE | FALSE | SIMPLE | optimizer extended cursor sharing for relational operators | |
| 68 | _optimizer_extended_stats_usage_control | 1 | FALSE | FALSE | 192 | controls the optimizer usage of extended stats | |
| 69 | _optimizer_false_filter_pred_pullup | 1 | FALSE | FALSE | TRUE | optimizer false predicate pull up transformation | |
| 70 | _optimizer_fast_access_pred_analysis | 1 | FALSE | FALSE | TRUE | use fast algorithm to traverse predicates for physical optimizer | |
| 71 | _optimizer_fast_pred_transitivity | 1 | FALSE | FALSE | TRUE | use fast algorithm to generate transitive predicates | |
| 72 | _optimizer_filter_pred_pullup | 1 | FALSE | FALSE | TRUE | use cost-based flter predicate pull up transformation | |
| 73 | _optimizer_fkr_index_cost_bias | 1 | FALSE | FALSE | 10 | Optimizer index bias over FTS/IFFS under first K rows mode | |
| 74 | _optimizer_full_outer_join_to_outer | 1 | FALSE | FALSE | TRUE | enable/disable full outer to left outer join conversion | |
| 75 | _optimizer_group_by_placement | 1 | FALSE | FALSE | TRUE | consider group-by placement optimization | |
| 76 | _optimizer_improve_selectivity | 1 | FALSE | FALSE | TRUE | improve table and partial overlap join selectivity computation | |
| 77 | _optimizer_interleave_jppd | 1 | FALSE | FALSE | TRUE | interleave join predicate pushdown during CBQT | |
| 78 | _optimizer_join_elimination_enabled | 1 | FALSE | FALSE | TRUE | optimizer join elimination enabled | |
| 79 | _optimizer_join_factorization | 1 | FALSE | FALSE | TRUE | use join factorization transformation | |
| 80 | _optimizer_join_order_control | 1 | FALSE | FALSE | 3 | controls the optimizer join order search algorithm | |
| 81 | _optimizer_join_sel_sanity_check | 1 | FALSE | FALSE | TRUE | enable/disable sanity check for multi-column join selectivity | |
| 82 | _optimizer_max_permutations | 1 | FALSE | FALSE | 2000 | optimizer maximum join permutations per query block | |
| 83 | _optimizer_mode_force | 1 | FALSE | FALSE | TRUE | force setting of optimizer mode for user recursive SQL also | |
| 84 | _optimizer_multi_level_push_pred | 1 | FALSE | FALSE | TRUE | consider join-predicate pushdown that requires multi-level pushdown to base table | |
| 85 | _optimizer_native_full_outer_join | 1 | FALSE | FALSE | FORCE | execute full outer join using native implementaion | |
| 86 | _optimizer_new_join_card_computation | 1 | FALSE | FALSE | TRUE | compute join cardinality using non-rounded input values | |
| 87 | _optimizer_null_aware_antijoin | 1 | FALSE | FALSE | TRUE | null-aware antijoin parameter | |
| 88 | _optimizer_or_expansion | 1 | FALSE | FALSE | DEPTH | control or expansion approach used | |
| 89 | _optimizer_order_by_elimination_enabled | 1 | FALSE | FALSE | TRUE | Eliminates order bys from views before query transformation | |
| 90 | _optimizer_outer_join_to_inner | 1 | FALSE | FALSE | TRUE | enable/disable outer to inner join conversion | |
| 91 | _optimizer_outer_to_anti_enabled | 1 | FALSE | FALSE | TRUE | Enable transformation of outer-join to anti-join if possible | |
| 92 | _optimizer_push_down_distinct | 1 | FALSE | FALSE | push down distinct from query block to table | ||
| 93 | _optimizer_push_pred_cost_based | 1 | FALSE | FALSE | TRUE | use cost-based query transformation for push pred optimization | |
| 94 | _optimizer_rownum_bind_default | 1 | FALSE | FALSE | 10 | Default value to use for rownum bind | |
| 95 | _optimizer_rownum_pred_based_fkr | 1 | FALSE | FALSE | TRUE | enable the use of first K rows due to rownum predicate | |
| 96 | _optimizer_skip_scan_enabled | 1 | FALSE | FALSE | TRUE | enable/disable index skip scan | |
| 97 | _optimizer_sortmerge_join_inequality | 1 | FALSE | FALSE | TRUE | enable/disable sort-merge join using inequality predicates | |
| 98 | _optimizer_squ_bottomup | 1 | FALSE | FALSE | TRUE | enables unnesting of subquery in a bottom-up manner | |
| 99 | _optimizer_star_tran_in_with_clause | 1 | FALSE | FALSE | TRUE | enable/disable star transformation in with clause queries | |
| 100 | _optimizer_system_stats_usage | 1 | FALSE | FALSE | TRUE | system statistics usage | |
| 101 | _optimizer_table_expansion | 1 | FALSE | FALSE | TRUE | consider table expansion transformation | |
| 102 | _optimizer_transitivity_retain | 1 | FALSE | FALSE | TRUE | retain equi-join pred upon transitive equality pred generation | |
| 103 | _optimizer_try_st_before_jppd | 1 | FALSE | FALSE | TRUE | try Star Transformation before Join Predicate Push Down | |
| 104 | _optimizer_undo_cost_change | 1 | FALSE | FALSE | 11.2.0.3 | optimizer undo cost change | |
| 105 | _optimizer_unnest_corr_set_subq | 1 | FALSE | FALSE | TRUE | Unnesting of correlated set subqueries (TRUE/FALSE) | |
| 106 | _optimizer_unnest_disjunctive_subq | 1 | FALSE | FALSE | TRUE | Unnesting of disjunctive subqueries (TRUE/FALSE) | |
| 107 | _optimizer_use_cbqt_star_transformation | 1 | FALSE | FALSE | TRUE | use rewritten star transformation using cbqt framework | |
| 108 | _optimizer_use_feedback | 1 | FALSE | FALSE | TRUE | optimizer use feedback | |
| 109 | _or_expand_nvl_predicate | 1 | FALSE | FALSE | TRUE | enable OR expanded plan for NVL/DECODE predicate | |
| 110 | _ordered_nested_loop | 1 | FALSE | FALSE | TRUE | enable ordered nested loop costing | |
| 111 | _parallel_broadcast_enabled | 1 | FALSE | FALSE | TRUE | enable broadcasting of small inputs to hash and sort merge joins | |
| 112 | _partition_view_enabled | 1 | FALSE | FALSE | TRUE | enable/disable partitioned views | |
| 113 | _pivot_implementation_method | 1 | FALSE | FALSE | CHOOSE | pivot implementation method | |
| 114 | _pre_rewrite_push_pred | 1 | FALSE | FALSE | TRUE | push predicates into views before rewrite | |
| 115 | _pred_move_around | 1 | FALSE | FALSE | TRUE | enables predicate move-around | |
| 116 | _push_join_predicate | 1 | FALSE | FALSE | TRUE | enable pushing join predicate inside a view | |
| 117 | _push_join_union_view | 1 | FALSE | FALSE | TRUE | enable pushing join predicate inside a union all view | |
| 118 | _push_join_union_view2 | 1 | FALSE | FALSE | TRUE | enable pushing join predicate inside a union view | |
| 119 | _px_minus_intersect | 1 | FALSE | FALSE | TRUE | enables pq for minus/interect operators | |
| 120 | _px_partition_scan_enabled | 1 | FALSE | FALSE | TRUE | enables or disables parallel partition-based scan | |
| 121 | _px_pwg_enabled | 1 | FALSE | FALSE | TRUE | parallel partition wise group by enabled | |
| 122 | _px_ual_serial_input | 1 | FALSE | FALSE | TRUE | enables new pq for UNION operators | |
| 123 | _query_on_physical | 1 | FALSE | FALSE | FALSE | query on physical | |
| 124 | _query_rewrite_setopgrw_enable | 1 | FALSE | FALSE | TRUE | perform general rewrite using set operator summaries | |
| 125 | _remove_aggr_subquery | 1 | FALSE | FALSE | TRUE | enables removal of subsumed aggregated subquery | |
| 126 | _replace_virtual_columns | 1 | FALSE | FALSE | TRUE | replace expressions with virtual columns | |
| 127 | _right_outer_hash_enable | 1 | FALSE | FALSE | TRUE | Right Outer/Semi/Anti Hash Enabled | |
| 128 | _selfjoin_mv_duplicates | 1 | FALSE | FALSE | TRUE | control rewrite self-join algorithm | |
| 129 | _sql_model_unfold_forloops | 1 | FALSE | FALSE | RUN_TIME | specifies compile-time unfolding of sql model forloops | |
| 130 | _subquery_pruning_enabled | 1 | FALSE | FALSE | TRUE | enable the use of subquery predicates to perform pruning | |
| 131 | _subquery_pruning_mv_enabled | 1 | FALSE | FALSE | FALSE | enable the use of subquery predicates with MVs to perform pruning | |
| 132 | _table_scan_cost_plus_one | 1 | FALSE | FALSE | TRUE | bump estimated full table scan and index ffs cost by one | |
| 133 | _union_rewrite_for_gs | 1 | FALSE | FALSE | YES_GSET_MVS | expand queries with GSets into UNIONs for rewrite | |
| 134 | _unnest_subquery | 1 | FALSE | FALSE | TRUE | enables unnesting of complex subqueries | |
| 135 | _use_column_stats_for_function | 1 | FALSE | FALSE | TRUE | enable the use of column statistics for DDP functions | |
| 136 | active_instance_count | TRUE | FALSE | number of active instances in the cluster database | |||
| 137 | aq_tm_processes | 1 | TRUE | FALSE | 1 | number of AQ Time Managers to start | |
| 138 | archive_lag_target | 1 | TRUE | FALSE | Maximum number of seconds of redos the standby could lose | ||
| 139 | asm_diskgroups | TRUE | FALSE | disk groups to mount automatically | |||
| 140 | asm_diskstring | TRUE | FALSE | disk set locations for discovery | |||
| 141 | asm_power_limit | 1 | TRUE | FALSE | 1 | number of parallel relocations for disk rebalancing | |
| 142 | asm_preferred_read_failure_groups | TRUE | FALSE | preferred read failure groups | |||
| 143 | audit_file_dest | 1 | FALSE | FALSE | /apps/oracle/diag/rdbms/klt2wdx0/KLT2WDX0/audit | Directory in which auditing files are to reside | |
| 144 | audit_sys_operations | 1 | TRUE | FALSE | FALSE | enable sys auditing | |
| 145 | audit_syslog_level | TRUE | FALSE | Syslog facility and level | |||
| 146 | audit_trail | 1 | FALSE | FALSE | NONE | enable system auditing | |
| 147 | awr_snapshot_time_offset | 1 | TRUE | FALSE | Setting for AWR Snapshot Time Offset | ||
| 148 | background_core_dump | 1 | TRUE | FALSE | partial | Core Size for Background Processes | |
| 149 | background_dump_dest | 1 | FALSE | FALSE | /apps/oracle/diag/rdbms/klt2wdx0/KLT2WDX0/trace | Detached process dump directory | |
| 150 | backup_tape_io_slaves | 1 | TRUE | FALSE | FALSE | BACKUP Tape I/O slaves | |
| 151 | bitmap_merge_area_size | 1 | TRUE | FALSE | 1048576 | maximum memory allow for BITMAP MERGE | |
| 152 | blank_trimming | 1 | TRUE | FALSE | FALSE | blank trimming semantics parameter | |
| 153 | buffer_pool_keep | 1 | TRUE | FALSE | Number of database blocks/latches in keep buffer pool | ||
| 154 | buffer_pool_recycle | 1 | TRUE | FALSE | Number of database blocks/latches in recycle buffer pool | ||
| 155 | cell_offload_compaction | 1 | TRUE | FALSE | ADAPTIVE | Cell packet compaction strategy | |
| 156 | cell_offload_decryption | 1 | TRUE | FALSE | TRUE | enable SQL processing offload of encrypted data to cells | |
| 157 | cell_offload_parameters | 1 | TRUE | FALSE | Additional cell offload parameters | ||
| 158 | cell_offload_plan_display | 1 | TRUE | FALSE | AUTO | Cell offload explain plan display | |
| 159 | cell_offload_processing | 1 | TRUE | FALSE | TRUE | enable SQL processing offload to cells | |
| 160 | circuits | TRUE | FALSE | max number of circuits | |||
| 161 | client_result_cache_lag | 1 | TRUE | FALSE | 3000 | client result cache maximum lag in milliseconds | |
| 162 | client_result_cache_size | 1 | TRUE | FALSE | client result cache max size in bytes | ||
| 163 | clonedb | 1 | TRUE | FALSE | FALSE | clone database | |
| 164 | cluster_database | 1 | TRUE | FALSE | FALSE | if TRUE startup in cluster database mode | |
| 165 | cluster_database_instances | 1 | TRUE | FALSE | 1 | number of instances to use for sizing cluster db SGA structures | |
| 166 | cluster_interconnects | TRUE | FALSE | interconnects for RAC use | |||
| 167 | commit_logging | TRUE | FALSE | transaction commit log write behaviour | |||
| 168 | commit_point_strength | 1 | TRUE | FALSE | 1 | Bias this node has toward not preparing in a two-phase commit | |
| 169 | commit_wait | TRUE | FALSE | transaction commit log wait behaviour | |||
| 170 | commit_write | TRUE | FALSE | transaction commit log write behaviour | |||
| 171 | compatible | 1 | FALSE | FALSE | 11.2.0 | Database will be completely compatible with this software version | |
| 172 | control_file_record_keep_time | 1 | FALSE | FALSE | 30 | control file record keep time in days | |
| 173 | control_files | 1 | FALSE | FALSE | /apps/oradata01/KLT2WDX0/onlinelog/ctl01.ctl | control file names list | |
| 174 | control_files | 2 | FALSE | FALSE | /apps/oradata02/KLT2WDX0/onlinelog/ctl02.ctl | control file names list | |
| 175 | control_management_pack_access | 1 | FALSE | FALSE | DIAGNOSTIC+TUNING | declares which manageability packs are enabled | |
| 176 | core_dump_dest | 1 | FALSE | FALSE | /apps/oracle/diag/rdbms/klt2wdp0/KLT2WDX0/cdump | Core dump directory | |
| 177 | cpu_count | 1 | TRUE | FALSE | 16 | number of CPUs for this instance | |
| 178 | create_bitmap_area_size | 1 | TRUE | FALSE | 8388608 | size of create bitmap buffer for bitmap index | |
| 179 | create_stored_outlines | TRUE | FALSE | create stored outlines for DML statements | |||
| 180 | cursor_bind_capture_destination | 1 | TRUE | FALSE | memory+disk | Allowed destination for captured bind variables | |
| 181 | cursor_sharing | 1 | TRUE | FALSE | EXACT | cursor sharing mode | |
| 182 | cursor_space_for_time | 1 | TRUE | FALSE | FALSE | use more memory in order to get faster execution | |
| 183 | db_16k_cache_size | 1 | TRUE | FALSE | Size of cache for 16K buffers | ||
| 184 | db_2k_cache_size | 1 | TRUE | FALSE | Size of cache for 2K buffers | ||
| 185 | db_32k_cache_size | 1 | TRUE | FALSE | Size of cache for 32K buffers | ||
| 186 | db_4k_cache_size | 1 | TRUE | FALSE | Size of cache for 4K buffers | ||
| 187 | db_8k_cache_size | 1 | TRUE | FALSE | Size of cache for 8K buffers | ||
| 188 | db_block_buffers | 1 | TRUE | FALSE | Number of database blocks cached in memory | ||
| 189 | db_block_checking | 1 | TRUE | FALSE | FALSE | header checking and data and index block checking | |
| 190 | db_block_checksum | 1 | TRUE | FALSE | TYPICAL | store checksum in db blocks and check during reads | |
| 191 | db_block_size | 1 | FALSE | FALSE | 8192 | Size of database block in bytes | |
| 192 | db_cache_advice | 1 | TRUE | FALSE | ON | Buffer cache sizing advisory | |
| 193 | db_cache_size | 1 | FALSE | FALSE | 16777216 | 16M | Size of DEFAULT buffer pool for standard block size buffers |
| 194 | db_create_file_dest | 1 | FALSE | FALSE | /apps/oradata01 | default database location | |
| 195 | db_create_online_log_dest_1 | 1 | FALSE | FALSE | /apps/oradata01/ | online log/controlfile destination #1 | |
| 196 | db_create_online_log_dest_2 | 1 | FALSE | FALSE | /apps/oradata02/ | online log/controlfile destination #2 | |
| 197 | db_create_online_log_dest_3 | 1 | TRUE | FALSE | online log/controlfile destination #3 | ||
| 198 | db_create_online_log_dest_4 | 1 | TRUE | FALSE | online log/controlfile destination #4 | ||
| 199 | db_create_online_log_dest_5 | 1 | TRUE | FALSE | online log/controlfile destination #5 | ||
| 200 | db_domain | 1 | FALSE | FALSE | directory part of global database name stored with CREATE DATABASE | ||
| 201 | db_file_multiblock_read_count | 1 | TRUE | FALSE | 128 | db block to be read each IO | |
| 202 | db_file_name_convert | 1 | FALSE | FALSE | KLT2WDP0 | datafile name convert patterns and strings for standby/clone db | |
| 203 | db_file_name_convert | 2 | FALSE | FALSE | KLT2WDX0 | datafile name convert patterns and strings for standby/clone db | |
| 204 | db_files | 1 | TRUE | FALSE | 200 | max allowable # db files | |
| 205 | db_flash_cache_file | 1 | TRUE | FALSE | flash cache file for default block size | ||
| 206 | db_flash_cache_size | 1 | TRUE | FALSE | flash cache size for db_flash_cache_file | ||
| 207 | db_flashback_retention_target | 1 | TRUE | FALSE | 1440 | Maximum Flashback Database log retention time in minutes. | |
| 208 | db_keep_cache_size | 1 | TRUE | FALSE | Size of KEEP buffer pool for standard block size buffers | ||
| 209 | db_lost_write_protect | 1 | TRUE | FALSE | NONE | enable lost write detection | |
| 210 | db_name | 1 | FALSE | FALSE | KLT2WDX0 | database name specified in CREATE DATABASE | |
| 211 | db_recovery_file_dest | 1 | FALSE | FALSE | /apps/orafra/ | default database recovery file location | |
| 212 | db_recovery_file_dest_size | 1 | FALSE | FALSE | 98784247808 | 92G | database recovery files size limit |
| 213 | db_recycle_cache_size | 1 | TRUE | FALSE | Size of RECYCLE buffer pool for standard block size buffers | ||
| 214 | db_securefile | 1 | TRUE | FALSE | PERMITTED | permit securefile storage during lob creation | |
| 215 | db_ultra_safe | 1 | TRUE | FALSE | OFF | Sets defaults for other parameters that control protection levels | |
| 216 | db_unique_name | 1 | TRUE | FALSE | KLT2WDX0 | Database Unique Name | |
| 217 | db_unrecoverable_scn_tracking | 1 | TRUE | FALSE | TRUE | Track nologging SCN in controlfile | |
| 218 | db_writer_processes | 1 | TRUE | FALSE | 1 | number of background database writer processes to start | |
| 219 | dbwr_io_slaves | 1 | TRUE | FALSE | DBWR I/O slaves | ||
| 220 | ddl_lock_timeout | 1 | TRUE | FALSE | timeout to restrict the time that ddls wait for dml lock | ||
| 221 | deferred_segment_creation | 1 | FALSE | FALSE | FALSE | defer segment creation to first insert | |
| 222 | dg_broker_config_file1 | 1 | TRUE | FALSE | /apps/oracle/11203/rdb/std/dbs/dr1KLT2WDX0.dat | data guard broker configuration file #1 | |
| 223 | dg_broker_config_file2 | 1 | TRUE | FALSE | /apps/oracle/11203/rdb/std/dbs/dr2KLT2WDX0.dat | data guard broker configuration file #2 | |
| 224 | dg_broker_start | 1 | TRUE | FALSE | FALSE | start Data Guard broker (DMON process) | |
| 225 | diagnostic_dest | 1 | FALSE | FALSE | /apps/oracle | diagnostic base directory | |
| 226 | disk_asynch_io | 1 | TRUE | FALSE | TRUE | Use asynch I/O for random access devices | |
| 227 | dispatchers | TRUE | FALSE | specifications of dispatchers | |||
| 228 | distributed_lock_timeout | 1 | TRUE | FALSE | 60 | number of seconds a distributed transaction waits for a lock | |
| 229 | dml_locks | 1 | TRUE | FALSE | 2076 | dml locks - one for each table modified in a transaction | |
| 230 | dst_upgrade_insert_conv | 1 | TRUE | FALSE | TRUE | Enables/Disables internal conversions during DST upgrade | |
| 231 | enable_ddl_logging | 1 | TRUE | FALSE | FALSE | enable ddl logging | |
| 232 | event | 1 | TRUE | FALSE | debug event control - default null string | ||
| 233 | fal_client | 1 | TRUE | FALSE | FAL client | ||
| 234 | fal_server | 1 | TRUE | FALSE | FAL server list | ||
| 235 | fast_start_io_target | 1 | TRUE | FALSE | Upper bound on recovery reads | ||
| 236 | fast_start_mttr_target | 1 | TRUE | FALSE | MTTR target in seconds | ||
| 237 | fast_start_parallel_rollback | 1 | TRUE | FALSE | LOW | max number of parallel recovery slaves that may be used | |
| 238 | file_mapping | 1 | TRUE | FALSE | FALSE | enable file mapping | |
| 239 | fileio_network_adapters | TRUE | FALSE | Network Adapters for File I/O | |||
| 240 | filesystemio_options | 1 | FALSE | FALSE | setall | IO operations on filesystem files | |
| 241 | fixed_date | 1 | TRUE | FALSE | fixed SYSDATE value | ||
| 242 | gcs_server_processes | 1 | TRUE | FALSE | number of background gcs server processes to start | ||
| 243 | global_context_pool_size | 1 | TRUE | FALSE | Global Application Context Pool Size in Bytes | ||
| 244 | global_names | 1 | TRUE | FALSE | FALSE | enforce that database links have same name as remote database | |
| 245 | global_txn_processes | 1 | TRUE | FALSE | 1 | number of background global transaction processes to start | |
| 246 | hash_area_size | 1 | TRUE | FALSE | 131072 | size of in-memory hash work area | |
| 247 | hi_shared_memory_address | 1 | TRUE | FALSE | SGA starting address (high order 32-bits on 64-bit platforms) | ||
| 248 | hs_autoregister | 1 | TRUE | FALSE | TRUE | enable automatic server DD updates in HS agent self-registration | |
| 249 | ifile | TRUE | FALSE | include file in init.ora | |||
| 250 | instance_groups | TRUE | FALSE | list of instance group names | |||
| 251 | instance_name | 1 | TRUE | FALSE | KLT2WDX0 | instance name supported by the instance | |
| 252 | instance_number | 1 | TRUE | FALSE | instance number | ||
| 253 | instance_type | 1 | TRUE | FALSE | RDBMS | type of instance to be executed | |
| 254 | java_jit_enabled | 1 | TRUE | FALSE | TRUE | Java VM JIT enabled | |
| 255 | java_max_sessionspace_size | 1 | TRUE | FALSE | max allowed size in bytes of a Java sessionspace | ||
| 256 | java_pool_size | 1 | TRUE | FALSE | size in bytes of java pool | ||
| 257 | java_soft_sessionspace_limit | 1 | TRUE | FALSE | warning limit on size in bytes of a Java sessionspace | ||
| 258 | job_queue_processes | 1 | FALSE | FALSE | 1 | maximum number of job queue slave processes | |
| 259 | large_pool_size | 1 | FALSE | FALSE | 33554432 | 32M | size in bytes of large pool |
| 260 | ldap_directory_access | 1 | TRUE | FALSE | NONE | RDBMS's LDAP access option | |
| 261 | ldap_directory_sysauth | 1 | TRUE | FALSE | no | OID usage parameter | |
| 262 | license_max_sessions | 1 | TRUE | FALSE | maximum number of non-system user sessions allowed | ||
| 263 | license_max_users | 1 | TRUE | FALSE | maximum number of named users that can be created in the database | ||
| 264 | license_sessions_warning | 1 | TRUE | FALSE | warning level for number of non-system user sessions | ||
| 265 | listener_networks | TRUE | FALSE | listener registration networks | |||
| 266 | local_listener | TRUE | FALSE | local listener | |||
| 267 | lock_name_space | TRUE | FALSE | lock name space used for generating lock names for standby/clone database | |||
| 268 | lock_sga | 1 | TRUE | FALSE | FALSE | Lock entire SGA in physical memory | |
| 269 | log_archive_config | 1 | TRUE | FALSE | log archive config parameter | ||
| 270 | log_archive_dest | 1 | TRUE | FALSE | archival destination text string | ||
| 271 | log_archive_dest_1 | 1 | TRUE | FALSE | archival destination #1 text string | ||
| 272 | log_archive_dest_10 | 1 | TRUE | FALSE | archival destination #10 text string | ||
| 273 | log_archive_dest_11 | 1 | TRUE | FALSE | archival destination #11 text string | ||
| 274 | log_archive_dest_12 | 1 | TRUE | FALSE | archival destination #12 text string | ||
| 275 | log_archive_dest_13 | 1 | TRUE | FALSE | archival destination #13 text string | ||
| 276 | log_archive_dest_14 | 1 | TRUE | FALSE | archival destination #14 text string | ||
| 277 | log_archive_dest_15 | 1 | TRUE | FALSE | archival destination #15 text string | ||
| 278 | log_archive_dest_16 | 1 | TRUE | FALSE | archival destination #16 text string | ||
| 279 | log_archive_dest_17 | 1 | TRUE | FALSE | archival destination #17 text string | ||
| 280 | log_archive_dest_18 | 1 | TRUE | FALSE | archival destination #18 text string | ||
| 281 | log_archive_dest_19 | 1 | TRUE | FALSE | archival destination #19 text string | ||
| 282 | log_archive_dest_2 | 1 | TRUE | FALSE | archival destination #2 text string | ||
| 283 | log_archive_dest_20 | 1 | TRUE | FALSE | archival destination #20 text string | ||
| 284 | log_archive_dest_21 | 1 | TRUE | FALSE | archival destination #21 text string | ||
| 285 | log_archive_dest_22 | 1 | TRUE | FALSE | archival destination #22 text string | ||
| 286 | log_archive_dest_23 | 1 | TRUE | FALSE | archival destination #23 text string | ||
| 287 | log_archive_dest_24 | 1 | TRUE | FALSE | archival destination #24 text string | ||
| 288 | log_archive_dest_25 | 1 | TRUE | FALSE | archival destination #25 text string | ||
| 289 | log_archive_dest_26 | 1 | TRUE | FALSE | archival destination #26 text string | ||
| 290 | log_archive_dest_27 | 1 | TRUE | FALSE | archival destination #27 text string | ||
| 291 | log_archive_dest_28 | 1 | TRUE | FALSE | archival destination #28 text string | ||
| 292 | log_archive_dest_29 | 1 | TRUE | FALSE | archival destination #29 text string | ||
| 293 | log_archive_dest_3 | 1 | TRUE | FALSE | archival destination #3 text string | ||
| 294 | log_archive_dest_30 | 1 | TRUE | FALSE | archival destination #30 text string | ||
| 295 | log_archive_dest_31 | 1 | TRUE | FALSE | archival destination #31 text string | ||
| 296 | log_archive_dest_4 | 1 | TRUE | FALSE | archival destination #4 text string | ||
| 297 | log_archive_dest_5 | 1 | TRUE | FALSE | archival destination #5 text string | ||
| 298 | log_archive_dest_6 | 1 | TRUE | FALSE | archival destination #6 text string | ||
| 299 | log_archive_dest_7 | 1 | TRUE | FALSE | archival destination #7 text string | ||
| 300 | log_archive_dest_8 | 1 | TRUE | FALSE | archival destination #8 text string | ||
| 301 | log_archive_dest_9 | 1 | TRUE | FALSE | archival destination #9 text string | ||
| 302 | log_archive_dest_state_1 | 1 | TRUE | FALSE | enable | archival destination #1 state text string | |
| 303 | log_archive_dest_state_10 | 1 | TRUE | FALSE | enable | archival destination #10 state text string | |
| 304 | log_archive_dest_state_11 | 1 | TRUE | FALSE | enable | archival destination #11 state text string | |
| 305 | log_archive_dest_state_12 | 1 | TRUE | FALSE | enable | archival destination #12 state text string | |
| 306 | log_archive_dest_state_13 | 1 | TRUE | FALSE | enable | archival destination #13 state text string | |
| 307 | log_archive_dest_state_14 | 1 | TRUE | FALSE | enable | archival destination #14 state text string | |
| 308 | log_archive_dest_state_15 | 1 | TRUE | FALSE | enable | archival destination #15 state text string | |
| 309 | log_archive_dest_state_16 | 1 | TRUE | FALSE | enable | archival destination #16 state text string | |
| 310 | log_archive_dest_state_17 | 1 | TRUE | FALSE | enable | archival destination #17 state text string | |
| 311 | log_archive_dest_state_18 | 1 | TRUE | FALSE | enable | archival destination #18 state text string | |
| 312 | log_archive_dest_state_19 | 1 | TRUE | FALSE | enable | archival destination #19 state text string | |
| 313 | log_archive_dest_state_2 | 1 | TRUE | FALSE | enable | archival destination #2 state text string | |
| 314 | log_archive_dest_state_20 | 1 | TRUE | FALSE | enable | archival destination #20 state text string | |
| 315 | log_archive_dest_state_21 | 1 | TRUE | FALSE | enable | archival destination #21 state text string | |
| 316 | log_archive_dest_state_22 | 1 | TRUE | FALSE | enable | archival destination #22 state text string | |
| 317 | log_archive_dest_state_23 | 1 | TRUE | FALSE | enable | archival destination #23 state text string | |
| 318 | log_archive_dest_state_24 | 1 | TRUE | FALSE | enable | archival destination #24 state text string | |
| 319 | log_archive_dest_state_25 | 1 | TRUE | FALSE | enable | archival destination #25 state text string | |
| 320 | log_archive_dest_state_26 | 1 | TRUE | FALSE | enable | archival destination #26 state text string | |
| 321 | log_archive_dest_state_27 | 1 | TRUE | FALSE | enable | archival destination #27 state text string | |
| 322 | log_archive_dest_state_28 | 1 | TRUE | FALSE | enable | archival destination #28 state text string | |
| 323 | log_archive_dest_state_29 | 1 | TRUE | FALSE | enable | archival destination #29 state text string | |
| 324 | log_archive_dest_state_3 | 1 | TRUE | FALSE | enable | archival destination #3 state text string | |
| 325 | log_archive_dest_state_30 | 1 | TRUE | FALSE | enable | archival destination #30 state text string | |
| 326 | log_archive_dest_state_31 | 1 | TRUE | FALSE | enable | archival destination #31 state text string | |
| 327 | log_archive_dest_state_4 | 1 | TRUE | FALSE | enable | archival destination #4 state text string | |
| 328 | log_archive_dest_state_5 | 1 | TRUE | FALSE | enable | archival destination #5 state text string | |
| 329 | log_archive_dest_state_6 | 1 | TRUE | FALSE | enable | archival destination #6 state text string | |
| 330 | log_archive_dest_state_7 | 1 | TRUE | FALSE | enable | archival destination #7 state text string | |
| 331 | log_archive_dest_state_8 | 1 | TRUE | FALSE | enable | archival destination #8 state text string | |
| 332 | log_archive_dest_state_9 | 1 | TRUE | FALSE | enable | archival destination #9 state text string | |
| 333 | log_archive_duplex_dest | 1 | TRUE | FALSE | duplex archival destination text string | ||
| 334 | log_archive_format | 1 | FALSE | FALSE | KLT2WDX0_%r_%t_%s.arc | archival destination format | |
| 335 | log_archive_local_first | 1 | TRUE | FALSE | TRUE | Establish EXPEDITE attribute default value | |
| 336 | log_archive_max_processes | 1 | TRUE | FALSE | 4 | maximum number of active ARCH processes | |
| 337 | log_archive_min_succeed_dest | 1 | TRUE | FALSE | 1 | minimum number of archive destinations that must succeed | |
| 338 | log_archive_start | 1 | TRUE | FALSE | FALSE | start archival process on SGA initialization | |
| 339 | log_archive_trace | 1 | TRUE | FALSE | Establish archivelog operation tracing level | ||
| 340 | log_buffer | 1 | FALSE | FALSE | 4923392 | redo circular buffer size | |
| 341 | log_checkpoint_interval | 1 | TRUE | FALSE | # redo blocks checkpoint threshold | ||
| 342 | log_checkpoint_timeout | 1 | TRUE | FALSE | 1800 | Maximum time interval between checkpoints in seconds | |
| 343 | log_checkpoints_to_alert | 1 | TRUE | FALSE | FALSE | log checkpoint begin/end to alert file | |
| 344 | log_file_name_convert | 1 | FALSE | FALSE | KLT2WDP0 | logfile name convert patterns and strings for standby/clone db | |
| 345 | log_file_name_convert | 2 | FALSE | FALSE | KLT2WDX0 | logfile name convert patterns and strings for standby/clone db | |
| 346 | max_dispatchers | TRUE | FALSE | max number of dispatchers | |||
| 347 | max_dump_file_size | 1 | TRUE | FALSE | unlimited | Maximum size (in bytes) of dump file | |
| 348 | max_enabled_roles | 1 | TRUE | FALSE | 150 | max number of roles a user can have enabled | |
| 349 | max_shared_servers | TRUE | FALSE | max number of shared servers | |||
| 350 | memory_max_target | 1 | FALSE | FALSE | 2097152000 | 2000M | Max size for Memory Target |
| 351 | memory_target | 1 | FALSE | FALSE | 2097152000 | 2000M | Target size of Oracle SGA and PGA memory |
| 352 | nls_calendar | 1 | TRUE | FALSE | NLS calendar system name | ||
| 353 | nls_comp | 1 | TRUE | FALSE | BINARY | NLS comparison | |
| 354 | nls_currency | 1 | TRUE | FALSE | NLS local currency symbol | ||
| 355 | nls_date_format | 1 | TRUE | FALSE | NLS Oracle date format | ||
| 356 | nls_date_language | 1 | TRUE | FALSE | NLS date language name | ||
| 357 | nls_dual_currency | 1 | TRUE | FALSE | Dual currency symbol | ||
| 358 | nls_iso_currency | 1 | TRUE | FALSE | NLS ISO currency territory name | ||
| 359 | nls_language | 1 | TRUE | FALSE | AMERICAN | NLS language name | |
| 360 | nls_length_semantics | 1 | TRUE | FALSE | BYTE | create columns using byte or char semantics by default | |
| 361 | nls_nchar_conv_excp | 1 | TRUE | FALSE | FALSE | NLS raise an exception instead of allowing implicit conversion | |
| 362 | nls_numeric_characters | 1 | TRUE | FALSE | NLS numeric characters | ||
| 363 | nls_sort | 1 | TRUE | FALSE | NLS linguistic definition name | ||
| 364 | nls_territory | 1 | TRUE | FALSE | AMERICA | NLS territory name | |
| 365 | nls_time_format | 1 | TRUE | FALSE | time format | ||
| 366 | nls_time_tz_format | 1 | TRUE | FALSE | time with timezone format | ||
| 367 | nls_timestamp_format | 1 | TRUE | FALSE | time stamp format | ||
| 368 | nls_timestamp_tz_format | 1 | TRUE | FALSE | timestamp with timezone format | ||
| 369 | object_cache_max_size_percent | 1 | TRUE | FALSE | 10 | percentage of maximum size over optimal of the user session's object cache | |
| 370 | object_cache_optimal_size | 1 | TRUE | FALSE | 102400 | optimal size of the user session's object cache in bytes | |
| 371 | olap_page_pool_size | 1 | TRUE | FALSE | size of the olap page pool in bytes | ||
| 372 | open_cursors | 1 | FALSE | FALSE | 1500 | max # cursors per session | |
| 373 | open_links | 1 | TRUE | FALSE | 4 | max # open links per session | |
| 374 | open_links_per_instance | 1 | TRUE | FALSE | 4 | max # open links per instance | |
| 375 | optimizer_capture_sql_plan_baselines | 1 | TRUE | FALSE | FALSE | automatic capture of SQL plan baselines for repeatable statements | |
| 376 | optimizer_dynamic_sampling | 1 | FALSE | FALSE | 2 | optimizer dynamic sampling | |
| 377 | optimizer_features_enable | 1 | TRUE | FALSE | 11.2.0.3 | optimizer plan compatibility parameter | |
| 378 | optimizer_index_caching | 1 | TRUE | FALSE | optimizer percent index caching | ||
| 379 | optimizer_index_cost_adj | 1 | TRUE | FALSE | 100 | optimizer index cost adjustment | |
| 380 | optimizer_mode | 1 | FALSE | FALSE | ALL_ROWS | optimizer mode | |
| 381 | optimizer_secure_view_merging | 1 | TRUE | FALSE | TRUE | optimizer secure view merging and predicate pushdown/movearound | |
| 382 | optimizer_use_invisible_indexes | 1 | TRUE | FALSE | FALSE | Usage of invisible indexes (TRUE/FALSE) | |
| 383 | optimizer_use_pending_statistics | 1 | TRUE | FALSE | FALSE | Control whether to use optimizer pending statistics | |
| 384 | optimizer_use_sql_plan_baselines | 1 | TRUE | FALSE | TRUE | use of SQL plan baselines for captured sql statements | |
| 385 | os_authent_prefix | 1 | TRUE | FALSE | ops$ | prefix for auto-logon accounts | |
| 386 | os_roles | 1 | TRUE | FALSE | FALSE | retrieve roles from the operating system | |
| 387 | parallel_adaptive_multi_user | 1 | TRUE | FALSE | TRUE | enable adaptive setting of degree for multiple user streams | |
| 388 | parallel_automatic_tuning | 1 | TRUE | FALSE | FALSE | enable intelligent defaults for parallel execution parameters | |
| 389 | parallel_degree_limit | 1 | TRUE | FALSE | CPU | limit placed on degree of parallelism | |
| 390 | parallel_degree_policy | 1 | TRUE | FALSE | MANUAL | policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO) | |
| 391 | parallel_execution_message_size | 1 | TRUE | FALSE | 16384 | message buffer size for parallel execution | |
| 392 | parallel_force_local | 1 | TRUE | FALSE | FALSE | force single instance execution | |
| 393 | parallel_instance_group | 1 | TRUE | FALSE | instance group to use for all parallel operations | ||
| 394 | parallel_io_cap_enabled | 1 | TRUE | FALSE | FALSE | enable capping DOP by IO bandwidth | |
| 395 | parallel_max_servers | 1 | TRUE | FALSE | 285 | maximum parallel query servers per instance | |
| 396 | parallel_min_percent | 1 | TRUE | FALSE | minimum percent of threads required for parallel query | ||
| 397 | parallel_min_servers | 1 | TRUE | FALSE | minimum parallel query servers per instance | ||
| 398 | parallel_min_time_threshold | 1 | TRUE | FALSE | AUTO | threshold above which a plan is a candidate for parallelization (in seconds) | |
| 399 | parallel_server | 1 | TRUE | FALSE | FALSE | if TRUE startup in parallel server mode | |
| 400 | parallel_server_instances | 1 | TRUE | FALSE | 1 | number of instances to use for sizing OPS SGA structures | |
| 401 | parallel_servers_target | 1 | TRUE | FALSE | 256 | instance target in terms of number of parallel servers | |
| 402 | parallel_threads_per_cpu | 1 | TRUE | FALSE | 2 | number of parallel execution threads per CPU | |
| 403 | permit_92_wrap_format | 1 | TRUE | FALSE | TRUE | allow 9.2 or older wrap format in PL/SQL | |
| 404 | pga_aggregate_target | 1 | TRUE | FALSE | Target size for the aggregate PGA memory consumed by the instance | ||
| 405 | plscope_settings | 1 | TRUE | FALSE | IDENTIFIERS:NONE | plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data | |
| 406 | plsql_ccflags | 1 | TRUE | FALSE | PL/SQL ccflags | ||
| 407 | plsql_code_type | 1 | TRUE | FALSE | INTERPRETED | PL/SQL code-type | |
| 408 | plsql_debug | 1 | TRUE | FALSE | FALSE | PL/SQL debug | |
| 409 | plsql_optimize_level | 1 | TRUE | FALSE | 2 | PL/SQL optimize level | |
| 410 | plsql_v2_compatibility | 1 | TRUE | FALSE | FALSE | PL/SQL version 2.x compatibility flag | |
| 411 | plsql_warnings | 1 | FALSE | FALSE | DISABLE:ALL | PL/SQL compiler warnings settings | |
| 412 | pre_page_sga | 1 | TRUE | FALSE | FALSE | pre-page sga for process | |
| 413 | processes | 1 | FALSE | FALSE | 300 | user processes | |
| 414 | processor_group_name | TRUE | FALSE | Name of the processor group that this instance should run in. | |||
| 415 | query_rewrite_enabled | 1 | FALSE | FALSE | TRUE | allow rewrite of queries using materialized views if enabled | |
| 416 | query_rewrite_integrity | 1 | TRUE | FALSE | enforced | perform rewrite using materialized views with desired integrity | |
| 417 | rdbms_server_dn | 1 | TRUE | FALSE | RDBMS's Distinguished Name | ||
| 418 | read_only_open_delayed | 1 | TRUE | FALSE | FALSE | if TRUE delay opening of read only files until first access | |
| 419 | recovery_parallelism | 1 | TRUE | FALSE | number of server processes to use for parallel recovery | ||
| 420 | recyclebin | 1 | TRUE | FALSE | on | recyclebin processing | |
| 421 | redo_transport_user | 1 | TRUE | FALSE | Data Guard transport user when using password file | ||
| 422 | remote_dependencies_mode | 1 | TRUE | FALSE | TIMESTAMP | remote-procedure-call dependencies mode parameter | |
| 423 | remote_listener | TRUE | FALSE | remote listener | |||
| 424 | remote_login_passwordfile | 1 | FALSE | FALSE | EXCLUSIVE | password file usage parameter | |
| 425 | remote_os_authent | 1 | TRUE | FALSE | FALSE | allow non-secure remote clients to use auto-logon accounts | |
| 426 | remote_os_roles | 1 | TRUE | FALSE | FALSE | allow non-secure remote clients to use os roles | |
| 427 | replication_dependency_tracking | 1 | TRUE | FALSE | TRUE | tracking dependency for Replication parallel propagation | |
| 428 | resource_limit | 1 | TRUE | FALSE | FALSE | master switch for resource limit | |
| 429 | resource_manager_cpu_allocation | 1 | TRUE | FALSE | 4 | Resource Manager CPU allocation | |
| 430 | resource_manager_plan | 1 | TRUE | FALSE | resource mgr top plan | ||
| 431 | result_cache_max_result | 1 | TRUE | FALSE | 5 | maximum result size as percent of cache size | |
| 432 | result_cache_max_size | 1 | FALSE | FALSE | 5242880 | 5M | maximum amount of memory to be used by the cache |
| 433 | result_cache_mode | 1 | TRUE | FALSE | MANUAL | result cache operator usage mode | |
| 434 | result_cache_remote_expiration | 1 | TRUE | FALSE | maximum life time (min) for any result using a remote object | ||
| 435 | resumable_timeout | 1 | TRUE | FALSE | set resumable_timeout | ||
| 436 | rollback_segments | TRUE | FALSE | undo segment list | |||
| 437 | sec_case_sensitive_logon | 1 | FALSE | FALSE | FALSE | case sensitive password enabled for logon | |
| 438 | sec_max_failed_login_attempts | 1 | TRUE | FALSE | 10 | maximum number of failed login attempts on a connection | |
| 439 | sec_protocol_error_further_action | 1 | TRUE | FALSE | CONTINUE | TTC protocol error continue action | |
| 440 | sec_protocol_error_trace_action | 1 | TRUE | FALSE | TRACE | TTC protocol error action | |
| 441 | sec_return_server_release_banner | 1 | TRUE | FALSE | FALSE | whether the server retruns the complete version information | |
| 442 | serial_reuse | 1 | TRUE | FALSE | disable | reuse the frame segments | |
| 443 | service_names | 1 | TRUE | FALSE | KLT2WDX0 | service names supported by the instance | |
| 444 | session_cached_cursors | 1 | TRUE | FALSE | 50 | Number of cursors to cache in a session. | |
| 445 | session_max_open_files | 1 | TRUE | FALSE | 10 | maximum number of open files allowed per session | |
| 446 | sessions | 1 | TRUE | FALSE | 472 | user and system sessions | |
| 447 | sga_max_size | 1 | TRUE | FALSE | 2097152000 | 2000M | max total SGA size |
| 448 | sga_target | 1 | TRUE | FALSE | Target size of SGA | ||
| 449 | shadow_core_dump | 1 | TRUE | FALSE | partial | Core Size for Shadow Processes | |
| 450 | shared_memory_address | 1 | TRUE | FALSE | SGA starting address (low order 32-bits on 64-bit platforms) | ||
| 451 | shared_pool_reserved_size | 1 | TRUE | FALSE | 23488102 | size in bytes of reserved area of shared pool | |
| 452 | shared_pool_size | 1 | TRUE | FALSE | size in bytes of shared pool | ||
| 453 | shared_server_sessions | TRUE | FALSE | max number of shared server sessions | |||
| 454 | shared_servers | 1 | TRUE | FALSE | number of shared servers to start up | ||
| 455 | skip_unusable_indexes | 1 | FALSE | FALSE | TRUE | skip unusable indexes if set to TRUE | |
| 456 | smtp_out_server | TRUE | FALSE | utl_smtp server and port configuration parameter | |||
| 457 | sort_area_retained_size | 1 | TRUE | FALSE | size of in-memory sort work area retained between fetch calls | ||
| 458 | sort_area_size | 1 | TRUE | FALSE | 65536 | size of in-memory sort work area | |
| 459 | spfile | 1 | TRUE | FALSE | /apps/oracle/11203/rdb/std/dbs/spfileKLT2WDX0.ora | server parameter file | |
| 460 | sql92_security | 1 | TRUE | FALSE | FALSE | require select privilege for searched update/delete | |
| 461 | sql_trace | 1 | TRUE | FALSE | FALSE | enable SQL trace | |
| 462 | sqltune_category | 1 | TRUE | FALSE | DEFAULT | Category qualifier for applying hintsets | |
| 463 | standby_archive_dest | 1 | TRUE | FALSE | ?/dbs/arch | standby database archivelog destination text string | |
| 464 | standby_file_management | 1 | TRUE | FALSE | MANUAL | if auto then files are created/dropped automatically on standby | |
| 465 | star_transformation_enabled | 1 | TRUE | FALSE | FALSE | enable the use of star transformation | |
| 466 | statistics_level | 1 | TRUE | FALSE | TYPICAL | statistics level | |
| 467 | streams_pool_size | 1 | TRUE | FALSE | size in bytes of the streams pool | ||
| 468 | tape_asynch_io | 1 | TRUE | FALSE | TRUE | Use asynch I/O requests for tape devices | |
| 469 | thread | 1 | TRUE | FALSE | Redo thread to mount | ||
| 470 | timed_os_statistics | 1 | TRUE | FALSE | internal os statistic gathering interval in seconds | ||
| 471 | timed_statistics | 1 | TRUE | FALSE | TRUE | maintain internal timing statistics | |
| 472 | trace_enabled | 1 | TRUE | FALSE | TRUE | enable in memory tracing | |
| 473 | tracefile_identifier | TRUE | FALSE | trace file custom identifier | |||
| 474 | transactions | 1 | TRUE | FALSE | 519 | max. number of concurrent active transactions | |
| 475 | transactions_per_rollback_segment | 1 | TRUE | FALSE | 5 | number of active transactions per rollback segment | |
| 476 | undo_management | 1 | FALSE | FALSE | AUTO | instance runs in SMU mode if TRUE, else in RBU mode | |
| 477 | undo_retention | 1 | FALSE | FALSE | 1800 | undo retention in seconds | |
| 478 | undo_tablespace | 1 | FALSE | FALSE | UNDOTBS_1 | use/switch undo tablespace | |
| 479 | use_indirect_data_buffers | 1 | TRUE | FALSE | FALSE | Enable indirect data buffers (very large SGA on 32-bit platforms) | |
| 480 | use_large_pages | 1 | TRUE | FALSE | TRUE | Use large pages if available (TRUE/FALSE/ONLY) | |
| 481 | use_sigio | 1 | TRUE | FALSE | TRUE | Use SIGIO signal | |
| 482 | user_dump_dest | 1 | FALSE | FALSE | /apps/oracle/diag/rdbms/klt2wdx0/KLT2WDX0/trace | User process dump directory | |
| 483 | utl_file_dir | TRUE | FALSE | utl_file accessible directories list | |||
| 484 | workarea_size_policy | 1 | TRUE | FALSE | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | |
| 485 | xml_db_events | 1 | TRUE | FALSE | enable | are XML DB events enabled |
![oracle 9i 10g 11g 升级路线图[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)