(转载)Oracle show parameter 命令的小技巧

http://www.cnblogs.com/interboy/archive/2007/04/09/705876.html

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 ;

转载于:https://www.cnblogs.com/afant/archive/2008/04/17/1157684.html