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的物理内存, 平台中该参数被忽略

[@more@]
请使用浏览器的分享功能分享到微信等