欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入 _dimension_skip_null=true _eliminate_common_subexpr=true _enable_type_dep_selectivity=true _fast_full_scan_enabled=true _first_k_rows_dynamic_proration=true _gby_hash_aggregation_enabl
欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入
_dimension_skip_null=true
    _eliminate_common_subexpr=true
    _enable_type_dep_selectivity=true
    _fast_full_scan_enabled=true
    _first_k_rows_dynamic_proration=true
    _gby_hash_aggregation_enabled=true
    _generalized_pruning_enabled=true
    _globalindex_pnum_filter_enabled=true
    _gs_anti_semi_join_allowed=true
    _improved_outerjoin_card=true
    _improved_row_length_enabled=true
    _index_join_enabled=true
    _ksb_restart_policy_times='0'
    _ksb_restart_policy_times='60'
    _ksb_restart_policy_times='120'
    _ksb_restart_policy_times='240'# internal update to set default
    _left_nested_loops_random=true
    _local_communication_costing_enabled=true
    _minimal_stats_aggregation=true
    _mmv_query_rewrite_enabled=true
    _new_initial_join_orders=true
    _new_sort_cost_estimate=true
    _nlj_batching_enabled=1
    _optim_adjust_for_part_skews=true
    _optim_enhance_nnull_detection=true
    _optim_new_default_join_sel=true
    _optim_peek_user_binds=true
    _optimizer_adaptive_cursor_sharing=true
    _optimizer_better_inlist_costing='all'
    _optimizer_cbqt_no_size_restriction=true
    _optimizer_coalesce_subqueries=true
    _optimizer_complex_pred_selectivity=true
    _optimizer_compute_index_stats=true
    _optimizer_connect_by_combine_sw=true
    _optimizer_connect_by_cost_based=true
    _optimizer_connect_by_elim_dups=true
    _optimizer_correct_sq_selectivity=true
    _optimizer_cost_based_transformation='linear'
    _optimizer_cost_hjsmj_multimatch=true
    _optimizer_cost_model='choose'
    _optimizer_dim_subq_join_sel=true
    _optimizer_distinct_agg_transform=true
    _optimizer_distinct_elimination=true
    _optimizer_distinct_placement=true
    _optimizer_eliminate_filtering_join=true
    _optimizer_enable_density_improvements=true
    _optimizer_enable_extended_stats=true
    _optimizer_enable_table_lookup_by_nl=true
    _optimizer_enhanced_filter_push=true
    _optimizer_extend_jppd_view_types=true
    _optimizer_extended_cursor_sharing='udo'
    _optimizer_extended_cursor_sharing_rel='simple'
    _optimizer_extended_stats_usage_control=192
    _optimizer_false_filter_pred_pullup=true
    _optimizer_fast_access_pred_analysis=true
    _optimizer_fast_pred_transitivity=true
    _optimizer_filter_pred_pullup=true
    _optimizer_fkr_index_cost_bias=10
    _optimizer_full_outer_join_to_outer=true
    _optimizer_group_by_placement=true
    _optimizer_improve_selectivity=true
    _optimizer_interleave_jppd=true
    _optimizer_join_elimination_enabled=true
    _optimizer_join_factorization=true
    _optimizer_join_order_control=3
    _optimizer_join_sel_sanity_check=true
    _optimizer_max_permutations=2000
    _optimizer_mode_force=true
    _optimizer_multi_level_push_pred=true
    _optimizer_native_full_outer_join='force'
    _optimizer_new_join_card_computation=true
    _optimizer_null_aware_antijoin=true
    _optimizer_or_expansion='depth'
    _optimizer_order_by_elimination_enabled=true
    _optimizer_outer_join_to_inner=true
    _optimizer_outer_to_anti_enabled=true
    _optimizer_push_down_distinct=0
    _optimizer_push_pred_cost_based=true
    _optimizer_rownum_bind_default=10
    _optimizer_rownum_pred_based_fkr=true
    _optimizer_skip_scan_enabled=true
    _optimizer_sortmerge_join_inequality=true
    _optimizer_squ_bottomup=true
    _optimizer_star_tran_in_with_clause=true
    _optimizer_system_stats_usage=true
    _optimizer_table_expansion=true
    _optimizer_transitivity_retain=true
    _optimizer_try_st_before_jppd=true
    _optimizer_undo_cost_change='11.2.0.3'
    _optimizer_unnest_corr_set_subq=true
    _optimizer_unnest_disjunctive_subq=true
    _optimizer_use_cbqt_star_transformation=true
    _optimizer_use_feedback=true
    _or_expand_nvl_predicate=true
    _ordered_nested_loop=true
    _parallel_broadcast_enabled=true
    _partition_view_enabled=true
    _pivot_implementation_method='choose'
    _pre_rewrite_push_pred=true
    _pred_move_around=true
    _push_join_predicate=true
    _push_join_union_view=true
    _push_join_union_view2=true
    _px_minus_intersect=true
    _px_partition_scan_enabled=true
    _px_pwg_enabled=true
    _px_ual_serial_input=true
    _query_rewrite_setopgrw_enable=true
    _remove_aggr_subquery=true
    _replace_virtual_columns=true
    _right_outer_hash_enable=true
    _selfjoin_mv_duplicates=true
    _sql_model_unfold_forloops='run_time'
    _sqltune_category_parsed='default'# parsed sqltune_category
    _subquery_pruning_enabled=true
    _subquery_pruning_mv_enabled=false
    _table_scan_cost_plus_one=true
    _union_rewrite_for_gs='yes_gset_mvs'
    _unnest_subquery=true
    _use_column_stats_for_function=true
    audit_file_dest='/u01/app/oracle/admin/dave/adump'
    audit_trail='db'
    background_dump_dest='/u01/app/oracle/diag/rdbms/dave_st/dave/trace'#deprecate parameter
    compatible='11.2.0.0.0'
    control_files='/u01/app/oracle/oradata/dave/control01.ctl'
    control_files='/u01/app/oracle/fast_recovery_area/dave/control02.ctl'# restore controlfile
    core_dump_dest='/u01/app/oracle/diag/rdbms/dave_st/dave/cdump'
    db_block_size=8192
    db_create_file_dest='/u01/app/oracle/oradata/dave'
    db_domain=''
    db_file_multiblock_read_count=16
    db_file_name_convert='+data/dave/datafile'
    db_file_name_convert='/u01/app/oracle/oradata/dave'
    db_file_name_convert='+data/dave/tempfile'
    db_file_name_convert='/u01/app/oracle/oradata/dave'
    db_name='dave'
    db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
    db_recovery_file_dest_size=1018937856
    db_unique_name='dave_st'
    fal_client='dave_st'
    fal_server='dave_pd1'
    fal_server='dave_pd2'
    log_archive_config='dg_config=（dave,dave_st）'
    log_archive_dest_1='location=/u01/archvalid_for=（all_logfiles,all_roles） db_unique_name=dave_st'
    log_archive_dest_2='service=davevalid_for=（online_logfiles,primary_role） db_unique_name=dave'
    log_archive_dest_state_1='enable'
    log_archive_dest_state_2='enable'
    log_buffer=2736128 # logbuffer update
    log_file_name_convert='+fra/dave/onlinelog'
    log_file_name_convert='/u01/app/oracle/oradata/dave'
    memory_target=688m
    open_cursors=300
    optimizer_dynamic_sampling=2
    optimizer_mode='all_rows'
    plsql_warnings='disable:all' #pl/sql warnings at init.ora
    processes=150
    query_rewrite_enabled='true'
    remote_login_passwordfile='exclusive'
    resource_manager_plan='scheduler[0x318f]:default_maintenance_plan'
    result_cache_max_size=1792k
    skip_unusable_indexes=true
    standby_file_management='auto'
    undo_tablespace='undotbs1'
    user_dump_dest='/u01/app/oracle/diag/rdbms/dave_st/dave/trace'#deprecate parameter
    从上面的结果，也知道是什么原因了，从内存来创建pfile,会把一些隐含参数也写进来。
    我这里的默认值是：
    _compression_compatibility='11.2.0.0.0'
    而朋友这里的默认值是：
    _compression_compatibility='11.2.0.1.0'
    这个参数就是朋友数据库启动报：ora-00600: internal errorcode, arguments: [kck_rls_check must use （11,0,0,0,0） or lower] 错误的原因。
    将这个参数改成：_compression_compatibility=11.2.0,在启动数据库，即可正常。
    实际上，这个问题是oracle 11g 中遗留的一个小问题。 在11.2.0.1 和11.0.2.0.2 中都会有这种问题。
    在oracle 11.2.0.3的版本中，这个_compression_compatibility参数的默认值就是11.2.0.0.0了，那么在从内存创建pfile,就不会在报ora-600的错误了。
    这也是我创建启动没报错，朋友启动创建启动报错的原因，因为我的数据库版本是11.2.0.3的。
    还有一点，就是我们使用内存创建数据库参数的时候，可以把前面的隐含参数全部删除掉，哪些参数太繁琐了，使用默认值就好。
  [1] [2]