HP-UX Kernel Configuration for Oracle for 8i/9i (3)
第三部分
SEMVMX |
Maximum value of a semaphore. Recommended: >= Oracle 9i = 32768
|
shmmax (see appendix 4) |
maximum allowable size of one shared memory segment. The SHMMAX setting should be large enough to hold the entire SGA in one shared memory segment. A low setting can cause creation of multiple shared memory segments which may lead to performance degradation, but normally it is ok to use a small number of shared memory segments.
default=0x04000000 (64MB) Oracle 7 0x40000000 (1GB = 1073741824 Bytes) Oracle 8, 8i, 9i recommended: db_block_size * db_block_buffers + shared_pool_size + log_buffer + shared memory for the application or hold the entire SGA in one shared memory segment ! (for 64bit use up to size of physical memory, but Oracle can also use multiple segments (please check appendix 4))
|
Shmmni |
maximum number of shared memory segments in the entire system. default=200. recommended: <= Oracle 8.1.7 = use default. >= Oracle 9i = 512
|
Shmseg |
maximum number of shared memory segments one process can attach. default=12. recommended: <= Oracle 8.1.7 = 10 per Oracle database >= Oracle 9i = 32 per Oracle database
|
Streampipes |
Set this parameter to 0 during on the installation of Oracle DB will reduce the installation time. Default: 0 Recommended for installation: 0 |
swapmem_on (see appendix 5) |
Allow Memory to Exceed Swap Spacedefault: 0 (off) recommended: 1 (on)
|
Swchunk |
Swap Chunk Size (1K Blocks) (related to kernel parameter maxswapchunks) default: 2048 recommended: 4096 (up to 65536 for large RAM)
|
VPS_CEILING |
maximum System-Selected Page Size in kilobytes. Recommended: >= Oracle9i = 64 (up to 16384 = 16MB for large SGA)
|
第三部分完。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/34596/viewspace-566898/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- HP-UX Kernel Configuration for Oracle for 8i/9i (2)UXOracle
- HP-UX Kernel Configuration for 11g 推薦UX
- HP-UX Kernel Configuration for 10g 推薦UX
- 解析Oracle 8i/9i的計劃穩定性(3)Oracle
- Plan Stability in Oracle 8i/9iOracle
- 解析Oracle 8i/9i的計劃穩定性(1)Oracle
- 解析Oracle 8i/9i的計劃穩定性(2)Oracle
- 解析Oracle 8i/9i的計劃穩定性(轉)Oracle
- RedHat AS3安裝Oracle 8iRedhatS3Oracle
- Oracle 9i Dataguard Max Performance Configuration for freshman in DBA TeamOracleORM
- 8i客戶端不能連線9i?客戶端
- Introduction to Tuning Oracle7 / Oracle8 / 8i / 9i (Doc ID 61998.1)Oracle
- oracle 8i的restoreOracleREST
- 處理 Oracle7/8/8i/9i/10g/11g 中的 Oracle 塊損壞Oracle
- hp-ux oracleUXOracle
- Unix kernel parameters for OracleOracle
- Oracle 8i DataGuard 的啟用Oracle
- Oracle 8i 密碼驗證Oracle密碼
- Oracle 9i 分析函式參考手冊(3)Oracle函式
- oracle 8i 提高imp速度的方法Oracle
- ORACLE 8I 建立密碼檔案!Oracle密碼
- Oracle 8i 是Java 寫的? (轉)OracleJava
- oracle 8i 32-bit (8.1.7.0.0) 連線oracle 方式Oracle
- Oracle 8i 新分析工具-LogMiner(轉)Oracle
- Oracle 9i安裝Oracle
- Uninstall Oracle 9iOracle
- oracle 9i 閃回Oracle
- oracle 9i index bug?OracleIndex
- ORACLE 9i statspack使用Oracle
- Oracle 9I dataguard(standby)Oracle
- windows平臺Oracle 8i DataGuard 建立和管理WindowsOracle
- Oracle 8i 與 oracle 9 下 RMAN 中 CROSSCHECK 使用的差異OracleROS
- 遷移案例一: oracle 8i 檔案遷移Oracle
- oracle 8i的記憶體引數設定Oracle記憶體
- Oracle 8i資料庫體系結構(轉)Oracle資料庫
- 理解和使用Oracle 8i分析工具-LogMiner(轉)Oracle
- oracle 9i 開啟autotrace onOracle
- Oracle 9I FlashBack 測試Oracle