oracle 所有引數資訊x$ksppi
select ksppinm,ksppdesc from x$ksppi where ksppinm like 'db%'
結果如下
1 dbwr_io_slaves DBWR I/O slaves2 db_file_name_convert datafile name convert patterns and strings for standby/clone db
3 db_block_buffers Number of database blocks cached in memory
4 db_block_checksum store checksum in db blocks and check during reads
5 db_block_size Size of database block in bytes
6 db_cache_size Size of DEFAULT buffer pool for standard block size buffers
7 db_2k_cache_size Size of cache for 2K buffers
8 db_4k_cache_size Size of cache for 4K buffers
9 db_8k_cache_size Size of cache for 8K buffers
10 db_16k_cache_size Size of cache for 16K buffers
11 db_32k_cache_size Size of cache for 32K buffers
12 db_keep_cache_size Size of KEEP buffer pool for standard block size buffers
13 db_recycle_cache_size Size of RECYCLE buffer pool for standard block size buffers
14 db_writer_processes number of background database writer processes to start
15 db_cache_advice Buffer cache sizing advisory
16 db_files max allowable # db files
17 db_file_multiblock_read_count db block to be read each IO
18 db_create_file_dest default database location
19 db_create_online_log_dest_1 online log/controlfile destination #1
20 db_create_online_log_dest_2 online log/controlfile destination #2
21 db_create_online_log_dest_3 online log/controlfile destination #3
22 db_create_online_log_dest_4 online log/controlfile destination #4
23 db_create_online_log_dest_5 online log/controlfile destination #5
24 db_recovery_file_dest default database recovery file location
25 db_recovery_file_dest_size database recovery files size limit
26 db_flashback_retention_target Maximum Flashback Database log retention time in minutes.
27 db_block_checking header checking and data and index block checking
28 db_domain directory part of global database name stored with CREATE DATABASE
29 db_name database name specified in CREATE DATABASE
30 db_unique_name Database Unique Name[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70612/viewspace-1024126/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 隱含引數的查詢x$ksppi,x$ksppcv
- oracle 11g show parameter顯示隱含引數hidden parameter_x$ksppiOracle
- Oracle 中所有隱含的 引數Oracle
- 獲取Oracle隱含引數資訊Oracle
- ORACLE最重要的引數資訊 (轉)Oracle
- 基於oracle 11.2.0.4如何獲取變更或修改後的所有資料庫引數資訊Oracle資料庫
- Oracle收集統計資訊之NO_INVALIDATE引數Oracle
- Oracle引數-隱藏引數Oracle
- Jersey 框架取到所有引數的方法框架
- 顯示資料庫所有引數資料庫
- oracle 引數Oracle
- Outlook for Microsoft 365 所有命令列引數ROS命令列
- Oracle引數檔案解析——引數解析Oracle
- Oracle 核心引數Oracle
- Oracle UNDO引數Oracle
- Oracle引數大全Oracle
- oracle引數配置Oracle
- oracle 效能引數Oracle
- ORACLE核心引數Oracle
- oracle引數整理Oracle
- 蘋果iPhone X引數詳解與真機圖賞 iPhone X引數配置怎麼樣蘋果iPhone
- Oracle引數檔案 各引數解釋Oracle
- MySQL 5.6所有系統變數(系統引數)MySql變數
- Oracle:PDB 引數管理Oracle
- Oracle rman 配置引數Oracle
- Oracle 引數檔案Oracle
- ORACLE 配置event引數Oracle
- Oracle檢視引數Oracle
- Oracle隱式引數Oracle
- Oracle 隱含引數Oracle
- ORACLE隱含引數Oracle
- oracle重要初始引數Oracle
- Oracle 各版本引數/隱藏引數 介紹Oracle
- oracle 查詢所有表的行數Oracle
- Hadoop2.x 引數彙總Hadoop
- 獲取資料庫中所有隱藏引數資料庫
- Oracle動態、靜態引數引數修改規則Oracle
- Linux核心引數以及Oracle引數調整(updated)LinuxOracle