shared pool_使用large pool

Using the Large Pool
使用large Pool

Unlike the shared pool, the large pool does not have an LRU list. Oracle does not
attempt to age objects out of the large pool.
不像shared pool，large pool不含有LRU 列表。ORACLE 不会尝试把对象
因长期不用而从large pool中去除.
You should consider configuring a large pool if your instance uses any of the
following:

如果你的实例使用下面的任何一个，你应该考虑使用large pool：

■ Parallel query
Parallel query uses shared pool memory to cache parallel execution message
buffers.
并行查询：
并行查询将使用shared pool内存来把并行执行消息缓存起来
■ Recovery Manager
Recovery Manager uses the shared pool to cache I/O buffers during backup and
restore operations. For I/O server processes and backup and restore operations,
Oracle allocates buffers that are a few hundred kilobytes in size.

恢复管理
recover manager 使用shared pool来缓存备份和恢复过程中 I/O buffer 里面的数据。
针对I/O 服务进程，以及备份和恢复操作。Oracle将分配buffers ,大小有几百K 。
■ Shared server
In a shared server architecture, the session memory for each client process is
included in the shared pool.

共享服务器：
在共享服务器访问模式下，每个客户端进程的会话内存都包含在共享池中。

Tuning the Large Pool and Shared Pool for the Shared Server Architecture
在共享服务器模式下调试large pool和share pool

As Oracle allocates shared pool memory for shared server session memory, the
amount of shared pool memory available for the library cache and dictionary cache
decreases. If you allocate this session memory from a different pool, then Oracle can
use the shared pool primarily for caching shared SQL and not incur the performance
overhead from shrinking the shared SQL cache.

由于ORACLE 从share pool 内存中分配共享的会话内存，那就没有足够的 library cache
以及dictionary cache 供shared pool使用。如果你从不同的池里为会话内存分配数据。
那么ORACLE就可以使用share pool来缓存共享SQL，从而不因为减少共享的SQL CACHE
影响性能。

Oracle recommends using the large pool to allocate the shared server-related User
Global Area (UGA), rather that using the shared pool.

Oracle 建议使用large pool来分配和共享服务器相关的 UGA，而不是使用shared pool。

 This is because Oracle uses the shared pool to allocate System Global Area (SGA) memory for other purposes,
such as shared SQL and PL/SQL procedures. Using the large pool instead of the shared pool
decreases fragmentation of the shared pool.

这是因为为了其他原因 ORACLE将使用 shared pool来分配SGA 内存，比如共享SQL 以及PL/SQL存储过程。
使用large pool 而不是shared pool将减小shared pool的碎片。