Oracle | DBMS_CACHEUTIL

Oracle DBMS_CACHEUTIL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose This undocumented package contains miscellaneous cache layer PL/SQL functions for Real Application Clusters (RAC) environments.

AUTHID DEFINER

Dependencies

DBMS_ASSERT

DBMS_OUTPUT

SYS_DBA_SEGS

Documented No

First Available 11.2

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmscu.sql

Subprograms

DISSOLVE_AFFINITY	GRAB_READMOSTLY	TRUE_CACHE_KEEP
DISSOLVE_READMOSTLY	LIST_READMOSTLY	TRUE_CACHE_UNKEEP
GRAB_AFFINITY	OBJECT_DOWNCONVERT

DISSOLVE_AFFINITY

Try to dissolve object affinity in RAC environment dbms_cacheutil.dissolve_affinity( schema IN VARCHAR2, obj IN VARCHAR2, partition IN VARCHAR2 := NULL, dissolve_index IN BOOLEAN := TRUE, active_drm IN BOOLEAN := FALSE);

exec dbms_cacheutil.dissolve_affinity(USER, 'SERV_INST');

          
      *

      ORA-01633: Real Application Clusters Option needed for this operation

DISSOLVE_READMOSTLY

Try to dissolve object readmostly in a RAC environment dbms_cacheutil.dissolve_readmostly( schema IN VARCHAR2, obj IN VARCHAR2, partition IN VARCHAR2 := NULL, dissolve_index IN BOOLEAN := TRUE);

exec dbms_cacheutil.dissolve_readmostly(USER, 'SERV_INST');

          
      *

      ORA-01633: Real Application Clusters Option needed for this operation

GRAB_AFFINITY

Try to grab object affinity in a RAC environment dbms_cacheutil.grab_affinity( schema IN VARCHAR2, obj IN VARCHAR2, partition IN VARCHAR2 := NULL, grab_index IN BOOLEAN := TRUE, active_drm IN BOOLEAN := FALSE);

exec dbms_cacheutil.grab_affinity(USER, 'SERV_INST');

           *

      ORA-01633: Real Application Clusters Option needed for this operation

GRAB_READMOSTLY

Try to grab object readmostly in RAC environment dbms_cacheutil.grab_readmostly( schema IN VARCHAR2, obj IN VARCHAR2, partition IN VARCHAR2 := NULL, grab_index IN BOOLEAN := TRUE);

exec dbms_cacheutil.grab_readmostly(USER, 'SERV_INST');

           *

      ORA-01633: Real Application Clusters Option needed for this operation

LIST_READMOSTLY

List objects that have the readmostly property set dbms_cacheutil.list_readmostly;

exec dbms_cacheutil.list_readmostly;

      

      PL/SQL procedure successfully completed.

OBJECT_DOWNCONVERT

Tries to downconvert object locks to shared mode in RAC dbms_cacheutil.object_downconvert( schema IN VARCHAR2, obj IN VARCHAR2, partition IN VARCHAR2 := NULL, downconvert_index IN BOOLEAN := TRUE);

exec dbms_cacheutil.object_downconvert(USER, 'SERV_INST');

      

      PL/SQL procedure successfully completed.

TRUE_CACHE_KEEP

Set an object to KEEP on True Cache dbms_cacheutil.true_cache_keep( schema IN VARCHAR2, obj IN VARCHAR2, partition IN VARCHAR2 := NULL);

TBD

TRUE_CACHE_UNKEEP

Unset an object to KEEP on True Cache dbms_cacheutil.true_cache_unkeep( schema IN VARCHAR2, obj IN VARCHAR2, partition IN VARCHAR2 := NULL);

TBD