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 parameter name of Oracle for a person who has just started to contact Oracle, with the fuzzy query of this parameter, we can first record only the rough information and find the detailed parameter name through the parameter query. Once you get familiar with it, you can. 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:
code highlighting produced by actipro codehighlighter (freeware)
http://www.CodeHighlighter.com/
--> 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.