Unlike the shared pool, the large pool does not have an LRU list. Oracle Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the database instance uses any of the following Oracle Database features:
与共享池不同,大型吃没有Least Recent Used List.Oracle并不是尝试去从large pool清理不常用的对象.考虑配置large pool如果数据库实例使用如下的特性:
Shared server
In a shared server architecture, the session memory for each client process is included in the shared pool.
共享服务器.
在一个共享服务器结构中,session的内存是在共享池中
Parallel query
Parallel query uses shared pool memory to cache parallel execution message buffers.
并行查询.
并行查询使用共享池听哦缓存并行执行的内容
Recovery Manager
Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size.
RMAN使用共享池来缓存 IO在备份和还原过程中.对于服务器进程的IO.备份,还原.Oracle分配100K以上的空间
This section describes how to configure the large pool for the shared server architecture and contains the following topics:
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8747612/viewspace-1966581/ ,如需转载,请注明出处,否则将追究法律责任。