7.2.3.1 TRUE_CACHE_KEEP Procedure

When you call this procedure on True Cache, it assigns the object to the KEEP buffer pool on that cache.

To use this procedure, the DB_KEEP_CACHE_SIZE initialization parameter must be configured on True Cache.

Syntax

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

Parameters

Table 7-1 TRUE_CACHE_KEEP 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.

Related Topics