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