首页 > 应用开发 > IT综合 > Large Pool (92)

Large Pool (92)

原创 IT综合 作者:tsinglee 时间:2007-10-25 09:41:56 0 删除 编辑

The database administrator can configure an optional memory area called the large
pool to provide large memory allocations for:
■ Session memory for the shared server and the Oracle XA interface (used where
transactions interact with more than one database)
■ I/O server processes
■ Oracle backup and restore operations
By allocating session memory from the large pool for shared server, Oracle XA, or
parallel query buffers, Oracle can use the shared pool primarily for caching shared
SQL and avoid the performance overhead caused by shrinking the shared SQL cache.
In addition, the memory for Oracle backup and restore operations, for I/O server
processes, and for parallel buffers is allocated in buffers of a few hundred kilobytes.
The large pool is better able to satisfy such large memory requests than the shared
The large pool does not have an LRU list. It is different from reserved space in the
shared pool, which uses the same LRU list as other memory allocated from the shared

比共享池更有效的满足大的内存的请求, 如:
1. shared server, Oracle XA
2. 并行查询
3. 备份恢复操作
4. I/O server processes


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: Java Pool (93)
请登录后发表评论 登录
  • 博文量
  • 访问量