7.2.1 Overview of Using the KEEP Buffer Pool with True Cache

You can assign different objects to the KEEP buffer pool on different True Caches.

At a high level, this involves the following steps:

1. Configure DB_KEEP_CACHE_SIZE on True Cache.
2. Assign objects on True Cache to the KEEP buffer pool.

As with the primary database, when an object is assigned to the KEEP buffer pool on True Cache, the object's blocks are loaded for a query and then kept in the KEEP buffer pool. When new data is inserted into the object on the primary database, that new data is automatically propagated to the KEEP buffer pool on True Cache through the redo apply mechanism.

To propagate direct load data to True Cache, specify the LOGGING clause in the corresponding DDL or DML, or alter the corresponding object property to LOGGING. The LOGGING clause lets you specify whether certain operations will be logged in the redo log file (LOGGING) or not (NOLOGGING).

• How True Cache Works with the Primary Database Buffer Cache
  By default, marking something KEEP on the primary database also marks it KEEP on True Cache.