7.2 KEEP Buffer Pool
You can use the KEEP
buffer pool to keep frequently
accessed tables persistent in the buffer pool.
- Overview of Using the KEEP Buffer Pool with True Cache
You can assign different objects to theKEEP
buffer pool on different True Caches. - Configuring DB_KEEP_CACHE_SIZE on True Cache
To configure theKEEP
buffer pool on True Cache, set theDB_KEEP_CACHE_SIZE
initialization parameter to a large size (such as 10 GB). - Assigning Objects to the KEEP Buffer Pool for True Cache
After configuring theKEEP
buffer pool, assign the object to theKEEP
buffer pool for True Cache. - Removing an Object's KEEP Buffer Pool Assignment for True Cache
You can useDBMS_CACHEUTIL.TRUE_CACHE_UNKEEP()
to remove objects from theKEEP
buffer pool. - Viewing a List of KEEP Objects on True Cache
Use theV$TRUE_CACHE_KEEP
view to see which objects are assigned to theKEEP
buffer cache for True Cache.
Parent topic: Complementary Caching Features