Other SGA Initialization Parameters (96)

tsinglee發表於2007-10-25

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的實體記憶體, 平臺中該引數被忽略

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-978523/,如需轉載,請註明出處,否則將追究法律責任。

相關文章