Multiple Buffer Pools (83)

You can configure the database buffer cache with separate buffer pools that either keep

data in the buffer cache or make the buffers available for new data immediately after

using the data blocks. Particular schema objects (tables, clusters, indexes, and

partitions) can then be assigned to the appropriate buffer pool to control the way their

data blocks age out of the cache.

■ The KEEP buffer pool retains the schema object’s data blocks in memory.

■ The RECYCLE buffer pool eliminates data blocks from memory as soon as they are

no longer needed.

■ The DEFAULT buffer pool contains data blocks from schema objects that are not

assigned to any buffer pool, as well as schema objects that are explicitly assigned

to the DEFAULT pool.

The initialization parameters that configure the KEEP and RECYCLE buffer pools are

DB_KEEP_CACHE_SIZE and DB_RECYCLE_CACHE_SIZE.

Note: Multiple buffer pools are only available for the standard block

size. Non-standard block size caches have a single DEFAULT pool.

Keep池将用户对象数据块保存在内存中

Recycle池尽快的将不需要使用的数据块从内存中清除

Default池…??

需要注意的是 , 多个池结构只对标准块可用 , 非标准块使用的是default池

[@more@]
请使用浏览器的分享功能分享到微信等