7.2.4.1 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.

Syntax

DBMS_CACHEUTIL.TRUE_CACHE_UNKEEP(
   schema                 IN VARCHAR2,
   obj                    IN VARCHAR2,
   partition              IN VARCHAR2 := NULL);

Parameters

Table 7-2 TRUE_CACHE_UNKEEP Procedure Parameters

Parameter Description
schema The name of the schema for the object.
obj The name of the object.
partition
  • If the object is not partitioned, then this is NULL.
  • If the object is partitioned, use the name of the partition segment.
  • If it's a composited partitioned object, use the name of the subpartition segment.