Oracl-Buffer-Cache-中-Keep-Pool-说明.docVIP

Oracle-Buffer-Cache-中-Keep-Pool-说明 Oracle Buffer Cache 中 Keep Pool 说明Oracle Buffer Cache 中 Keep Pool 说明 一. Keep Pool 说明 在我之前的Blog里对DB buffer 进行了一个说明，参考： Oracle Buffer Cache 原理 /tianlesoftware/article/details/6573438 Oracle的buffer cache 由三个部分组成： default pool，keep pool 和Recycle pool. 每个Pool 都有自己的LRU来管理. （1）The default pool is for everything else. （2）The recycle pool is for larger objects. （3）The keep pools purpose is to take small objects that shouldalways be cached, for example Look Up Tables. 在这篇文章里我们重点看一下KeepPool的说明。 1.1 相关理论知识 1.1.1 BUFFER_POOL The BUFFER_POOL clause letsyou specify a default buffer pool (cache) for aschema object. All blocks for the object are stored in the specified cache. -- 缓冲池子句可指定一个数据库对象的默认缓冲池。这个对象的所有数据块存储在指定的缓存中。 If you define a buffer poolfor a partitioned table or index, then the partitions inherit the buffer poolfrom the table or index definition, unless overridden by a partition-leveldefinition. --如果给一个分区表或索引指定了缓冲池，那么该表或索引的分区也同样使用指定的缓冲池，除非在分区的定义中指定分区使用的缓冲池。 For an index-organized table,you can specify a buffer pool separately for the index segment and the overflowsegment. --对于一个索引组织表，可以为索引段和溢出段分别指定缓冲池。 （1）Restrictionson BUFFER_POOL You cannot specify this clausefor a cluster table. However, you can specify it for a cluster. --不能在聚集表上指定缓冲池，但是，可以在一个聚集上指定缓冲池。 You cannot specify this clausefor a tablespace or for a rollback segment. --不能在表空间或回滚段上指定缓冲池。（2）KEEP Specify KEEP to put blocksfrom the segment into the KEEP buffer pool. Maintaining an appropriately sizedKEEP buffer pool lets Oracle retain the schema object in memory to avoid I/Ooperations. KEEP takes precedence over any NOCACHEclause you specify for a table, cluster, materialized view, ormaterialized view log. --指定KEEP将把数据块放入KEEP缓冲池中。维护一个适当尺寸的KEEP缓冲池可以使Oracle在内存中保留数据库对象而避免I/O操作。在表、聚集、实体化视图或实体化视图日志上，KEEP子句的优先权大于NOCACHE子句。（3）RECYCLE Specify RECYCLE to put blocksfrom the segment into the RECYCLE pool. An appropriately sized RECYCLE poolreduces the number