Other SGA Initialization Parameters (96)
You can use several initialization parameters to control how the SGA uses memory.
Physical Memory
The LOCK_SGA parameter locks the SGA into physical memory.
SGA Starting Address
The SHARED_MEMORY_ADDRESS and HI_SHARED_MEMORY_ADDRESS parameters
specify the SGA's starting address at runtime. These parameters are rarely used. For
64-bit platforms, HI_SHARED_MEMORY_ADDRESS specifies the high order 32 bits of the
64-bit address.
Extended Buffer Cache Mechanism
The USE_INDIRECT_DATA_BUFFERS parameter enables the use of the extended
buffer cache mechanism for 32-bit platforms that can support more than 4 GB of
physical memory. On platforms that do not support this much physical memory, this
parameter is ignored.
其他有關sga的初始化引數
lock_sga : 將sga鎖定在實體記憶體中
USE_INDIRECT_DATA_BUFFERS : 32位平臺透過擴充套件buffer cache機制來支援4G的實體記憶體, 平臺中該引數被忽略
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-978523/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Understanding Initialization Parameters (85)
- Limiting the Size of the SGA (96)MIT
- The SGA_TARGET Initialization Parameter (74)
- The SGA_MAX_SIZE Initialization Parameter (72)
- Setting the Buffer Cache Initialization Parameters (108)
- The DB_nK_CACHE_SIZE Initialization Parameters (110)
- 驗證一個和 initialization parameters pfile有關的052考試題
- Initialization
- JVM parametersJVM
- list initialization
- v$nls_parameters和nls_database_parametersDatabase
- Oracle Parallel ParametersOracleParallel
- The SPFILE Initialization Parameter
- Runloop + runtime + otherOOP
- TypeError: object() takes no parametersErrorObject
- Oracle Hidden ParametersOracle
- Unix kernel parameters for OracleOracle
- 初始化 (Initialization)
- PHP函式庫(other)PHP函式
- sga_target與sga_max_size
- SGA_MAX_SIZE與SGA_TARGET
- sga_target與max_sga_size
- Globalization Support Parameters in Views (178)View
- Special Characters in Initialization Parameter Files
- SKIP_UNUSABLE_INDEXES InitializationIndex
- OPTIMIZER_MODE Initialization Parameter
- 多執行緒96執行緒
- show sga和show parameter sga的區別
- 【轉】SGA_MAX_SIZE與SGA_TARGET
- read by other session等待事件Session事件
- Python class中的otherPython
- read by other session 測試Session
- 等待事件:read by other session事件Session
- mount other server cdrom&directoryServer
- 【等待事件】read by other session事件Session
- 自動SGA共享記憶體管理,ASMM,MMAN,sga_target,sga_max_size記憶體ASM
- Oracle cascading standby ParametersOracle
- File hash GET parameters for Django staticfilesDjango