|
|
|
|
|
In Oracle8, you can
configure a new system global area (SGA) called the large pool.
|
|
Configuration of the
large pool is optional; if configured, the RDBMS uses the memory for the
following:
|
|
Session memory (User
Global Area (UGA) memory) for MTS or Extended Architecture (XA)
|
|
I/O slaves
|
|
Oracle backup and
restore
|
|
The large pool was
created to allow the RDBMS to request large memory allocations from a
separate pool and to prevent competition with other subsystems for the same
memory. As the RDBMS allocates more shared pool memory for the MTS session
memory, the amount of shared pool memory available for the shared SQL cache
decreases. By allocating session memory from another area of shared memory,
the RDBMS can use the shared pool primarily for caching shared SQL and not
incur the performance overhead from shrinking the shared SQL cache.
|
|
For I/O slaves and
Oracle backup and restore, the RDBMS allocates buffers that are a few hundred
kilobytes in size. The shared pool cannot satisfy this request; the large
pool can.
|
|
The large pool does not
have an least recently used (LRU) list.
|