7.2.5 Viewing a List of KEEP Objects on True Cache

Use the V$TRUE_CACHE_KEEP view to see which objects are assigned to the KEEP buffer cache for True Cache.

Example 1

SELECT * FROM v$true_cache_keep;

TS_NUMBER  DATA_OBJECT_ID  CON_ID
---------- --------------  ------
         5          72948       3
         5          72950       3

Example 2

SELECT owner as schema, object_name as keepobj, subobject_name as partition, o.data_object_id
FROM dba_objects o, sys_objects so, v$true_cache_keep vtck
WHERE o.data_object_id = so.object_id
  AND vtck.con_id = sys_context('USERENV', 'CON_ID')
  AND so.ts_number=vtck.ts_number
  AND o.data_object_id = vtck.data_object_id;

SCHEMA  KEEPOBJ  PARTITION     DATA_OBJECT_ID
------  -------  ------------  --------------
SYS     TABLE1                          72948
SYS     TABLE2   TABLE2_PART1           72950

• V$TRUE_CACHE_KEEP Columns
  The following table describes the columns in the V$TRUE_CACHE_KEEP view.