程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle數據庫基礎 >> Oracle參數查詢命令Oracle參數查詢命令show parameter的小技巧

Oracle參數查詢命令Oracle參數查詢命令show parameter的小技巧

編輯:Oracle數據庫基礎

模糊查詢通過Oracle參數查詢命令show parameter同樣可以實現,下面就為您詳細介紹該方法的實現過程,希望可以讓您對Oracle參數查詢命令show parameter有更深的認識。

Oracle參數查詢命令show parameter的一個小技巧,可以使用模糊查詢,比如我想查詢包含db_的參數,那麼我就可以用:

  1. SQL> show parameter db_;  
  2.  
  3. NAME                                  TYPE         VALUE                                                
  4. ------------------------------------ ----------- ------------------------------                       
  5. db_16k_cache_size                     big integer 0                                                    
  6. db_2k_cache_size                      big integer 0                                                    
  7. db_32k_cache_size                     big integer 0                                                    
  8. db_4k_cache_size                      big integer 0                                                    
  9. db_8k_cache_size                      big integer 0                                                    
  10. db_block_buffers                     integer     0                                                    
  11. db_block_checking                     string       FALSE                                                
  12. db_block_checksum                     string       TRUE                                                 
  13. db_block_size                        integer     8192                                                 
  14. db_cache_advice                       string      ON                                                   
  15. db_cache_size                         big integer 0                                                    
  16.  
  17. NAME                                  TYPE         VALUE                                                
  18. ------------------------------------ ----------- ------------------------------                       
  19. db_create_file_dest                   string                                                           
  20. db_create_online_log_dest_1           string                                                           
  21. db_create_online_log_dest_2           string                                                           
  22. db_create_online_log_dest_3           string                                                           
  23. db_create_online_log_dest_4           string                                                           
  24. db_create_online_log_dest_5           string                                                           
  25. db_domain                             string                                                           
  26. db_file_multiblock_read_count        integer     8                                                    
  27. db_file_name_convert                  string                                                           
  28. db_files                             integer     200                                                  
  29. db_Flashback_retention_target        integer     1440                                                 
  30.  
  31. NAME                                  TYPE         VALUE                                                
  32. ------------------------------------ ----------- ------------------------------                       
  33. db_keep_cache_size                    big integer 0                                                    
  34. db_name                               string       Ora813                                               
  35. db_recovery_file_dest                 string       d:\Oracle\product\10.2.0/Flash                       
  36.                                                   _recovery_area                                       
  37. db_recovery_file_dest_size            big integer 2G                                                   
  38. db_recycle_cache_size                 big integer 0                                                    
  39. db_unique_name                        string       Ora813                                               
  40. db_writer_processes                  integer     1                                                    
  41. dbwr_io_slaves                       integer     0                                                    
  42. rdbms_server_dn                       string                                                           
  43. standby_archive_dest                  string      %Oracle_HOME%\RDBMS                                  
  44.  
  45. NAME                                  TYPE         VALUE                                                
  46. ------------------------------------ ----------- ------------------------------                       
  47. standby_file_management               string       MANUAL                                               
  48. SQL> spool off;  


對於一個剛開始接觸Oracle的人來數要記住Oracle的參數名稱是件非常難的事,有了這個參數的模糊查詢我們可以先只記個大概,通過參數查詢找到詳細的參數名稱,一來二去熟悉了就可以。

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved