对Oracle系统的Initial troubleshooting(Oracle 系统参数的检查)

平台：

      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                                                                                        
==========================================================================================                             

可以看到，系统中的一些参数设置需要修改；