Oracle Automating Script for KEEP Pool Caching Tables & Indexes db_keep_cache_size
http://www.dba-oracle.com/t_script_automate_keep_pool_tables_indexes.htm
Using the Oracle KEEP pool
http://www.dba-oracle.com/oracle_tips_cache_small_fts.htm
Using the KEEP and RECYCLE Pool
http://www.toadworld.com/platforms/oracle/w/wiki/1347.using-the-keep-and-recycle-pool.aspx
Sometimes, data blocks are read in the database, and are infrequently reused. Often in a database we also have data blocks that are of frequent use (hot blocks). It is for these types of database blocks (and the objects associated with them) that Oracle offers the keep and recycle buffer pools. In this topic we will quickly review the database buffer cache, what the keep and recycle pools are, how to determine which objects to put in the keep pool, how to enable the buffer pool features, and finally how to assign objects to the buffer pools.
Buffer Cache Overview
Introducing the Keep and Recycle Pools
Analyze the Buffer Cache Usage
Enabling Multiple Buffer Pools
Dynamic Memory Allocation in Oracle9i
Guidelines for Initialization Parameters For Oracle8i
Allocating Segments to Different Pools
--Dell to Acquire Quest Software