Tips for Oracle show parameter Command [from http://www.cnblogs.com/interboy /]

Today, I accidentally discovered an Oracle parameter query command show parameter, which can be used for Fuzzy queries. For example, if I want to query parameters that contain db _, I can use: 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;

It is very difficult to remember the Oracle parameter name for a person who has just started to contact Oracle. With the fuzzy query of this parameter, we can remember only a rough one first, you can find the detailed parameter name through the parameter query. However, the last three items only contain db and _, which may be included. I am not very clear about the details. I accidentally discovered this afternoon!
For example, I want to see all the parameters that contain 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;

Now, there is nothing to say about it. It is an unexpected achievement today.