Oracle show parameter 命令的小技巧，下午無意中發現的

今天無意中發現了一個Oracle參數查詢命令show parameter的一個小技巧，可以使用模糊查詢，比如我想查詢包含db_的參數，那麼我就可以用：SQL> show parameter db_;

NAME                                 TYPE        VALUE                                              
------------------------------------ ----------- ------------------------------                     
db_16k_cache_size                    big integer 0                                                  
db_2k_cache_size                     big integer 0                                                  
db_32k_cache_size                    big integer 0                                                  
db_4k_cache_size                     big integer 0                                                  
db_8k_cache_size                     big integer 0                                                  
db_block_buffers                     integer     0                                                  
db_block_checking                    string      FALSE                                              
db_block_checksum                    string      TRUE                                               
db_block_size                        integer     8192                                               
db_cache_advice                      string      ON                                                 
db_cache_size                        big integer 0                                                  

NAME                                 TYPE        VALUE                                              
------------------------------------ ----------- ------------------------------                     
db_create_file_dest                  string                                                         
db_create_online_log_dest_1          string                                                         
db_create_online_log_dest_2          string                                                         
db_create_online_log_dest_3          string                                                         
db_create_online_log_dest_4          string                                                         
db_create_online_log_dest_5          string                                                         
db_domain                            string                                                         
db_file_multiblock_read_count        integer     8                                                  
db_file_name_convert                 string                                                         
db_files                             integer     200                                                
db_flashback_retention_target        integer     1440                                               

NAME                                 TYPE        VALUE                                              
------------------------------------ ----------- ------------------------------                     
db_keep_cache_size                   big integer 0                                                  
db_name                              string      Ora813                                             
db_recovery_file_dest                string      d:\oracle\product\10.2.0/flash                     
                                                 _recovery_area                                     
db_recovery_file_dest_size           big integer 2G                                                 
db_recycle_cache_size                big integer 0                                                  
db_unique_name                       string      Ora813                                             
db_writer_processes                  integer     1                                                  
dbwr_io_slaves                       integer     0                                                  
rdbms_server_dn                      string                                                         
standby_archive_dest                 string      %ORACLE_HOME%\RDBMS                                

NAME                                 TYPE        VALUE                                              
------------------------------------ ----------- ------------------------------                     
standby_file_management              string      MANUAL                                             
SQL> spool off;

對於一個剛開始接觸Oracle的人來數要記住Oracle的參數名稱是件非常難的事，有了這個參數的模糊查詢我們可以先只記個大概，通過參數查詢找到詳細的參數名稱，一來二去熟悉了就可以。但是後面三個只是內部包含db和_，可能是包含就算吧，具體的我也不是很清楚，今天下午無意中發現的！
比如下面的我想看包含db_c的所有參數：SQL> show parameter db_c;

NAME                                 TYPE        VALUE                                              
------------------------------------ ----------- ------------------------------                     
db_cache_advice                      string      ON                                                 
db_cache_size                        big integer 0                                                  
db_create_file_dest                  string                                                         
db_create_online_log_dest_1          string                                                         
db_create_online_log_dest_2          string                                                         
db_create_online_log_dest_3          string                                                         
db_create_online_log_dest_4          string                                                         
db_create_online_log_dest_5          string                                                         
SQL> spool off;

好了就到這了，也沒什麼好說的，也算是今天一個意外的收穫吧.