模糊查询通过Oracle参数查询命令show parameter同样可以实现，下面就为您详细介绍该方法的实现过程，希望可以让您对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的参数名称是件非常难的事，有了这个参数的模糊查询我们可以先只记个大概，通过参数查询找到详细的参数名称，一来二去熟悉了就可以。

【编辑推荐】

Oracle with语句的用法

Oracle查询用户表空间的实现

Oracle并行查询方式的利用

16种oracle查询日期语句

Oracle索引的优化设计