平台:
IBM AIX5.1
Oracle 9i
Oracle AS
操作:
对于Oracle DBA来说,如何检查Oracle的init.ora参数是否正确对系统来说是至关重要的事情,除了丰富的实际和理论知识后,再需对系统有深入的了解。Oracle 9i环境中系统提供了AFCHKCBO.SQL脚本来检查Oracle参数的设置:
# sqlplus apps/xxx@test
SQL> spool afchkcbo.txt; -- 输出检查的报告文件
SQL> start $FND_TOP/SQL/AFCHKCBO.SQL
SQL> spool off;
SQL> quit;
以下是对系统的检查情况:
==========================================================================================
Parameter Name Current Value Required Value
==========================================================================================
_sort_elimination_cost_ratio 5 5
_optimizer_mode_force Not set Not required
_fast_full_scan_enabled FALSE FALSE
_ordered_nested_loop Not set Not required
_complex_view_merging Not set Not required
_push_join_predicate Not set Not required
_use_column_stats_for_function Not set Not required
_push_join_union_view Not set Not required
_like_with_bind_as_equality TRUE TRUE
_or_expand_nvl_predicate Not set Not required
_table_scan_cost_plus_one Not set Not required
_optimizer_undo_changes Not set Not required
db_file_multiblock_read_count 8 8
optimizer_max_permutations 2000 Not required (*)
optimizer_mode CHOOSE CHOOSE
optimizer_percent_parallel Not set Not required
query_rewrite_enabled true Not required (*)
always_anti_join Not set Not required
always_semi_join Not set Not required
pga_aggregate_target 524288000 524288000
workarea_size_policy AUTO auto (*)
sort_area_size 65536 Not required (**)
hash_area_size 131072 Not required (**)
optimizer_index_caching 0 0
optimizer_index_cost_adj 100 100
optimizer_features_enable 9.2.0 9.2.0
compatible 9.2.0 9.2.0
_new_initial_join_orders Not set Not required
_sqlexec_progression_cost 0 Not required (*)
==========================================================================================
Legend:
(*) : Required value
(**): Recommended default value
==========================================================================================
可以看到,系统中的一些参数设置需要修改;