7.2.4 Removing an Object's KEEP Buffer Pool Assignment for True Cache

You can use DBMS_CACHEUTIL.TRUE_CACHE_UNKEEP() to remove objects from the KEEP buffer pool.

Note that the block is not removed immediately. Instead, it will be naturally aged out as new blocks for other objects are brought into the KEEP buffer pool. Also, the KEEP buffer pool assignment on True Cache is only remembered while True Cache is up.

Example: Nonpartitioned Object

EXECUTE DBMS_CACHEUTIL.TRUE_CACHE_UNKEEP('SYS', 'TABLE1');

Example: Partition of a Partitioned Object

EXECUTE DBMS_CACHEUTIL.TRUE_CACHE_UNKEEP('SYS', 'TABLE2', 'TABLE2_PART1');

• TRUE_CACHE_UNKEEP Procedure
  When an object on True Cache no longer needs to be in the KEEP buffer pool, use this procedure to remove the object's KEEP assignment.