Oracle | DBMS_CACHEUTIL

Oracle DBMS_CACHEUTIL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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_AFFINITY	LIST_READMOSTLY
DISSOLVE_READMOSTLY	GRAB_READMOSTLY	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');

      BEGIN dbms_cacheutil.dissolve_affinity(USER, 'SERV_INST'); 
      END;

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_CACHEUTIL", line 152

      ORA-06512: at line 1

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');

      BEGIN dbms_cacheutil.dissolve_readmostly(USER, 'SERV_INST'); 
      END;

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_CACHEUTIL", line 185

      ORA-06512: at line 1

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');

      BEGIN dbms_cacheutil.grab_affinity(USER, 'SERV_INST'); 
      END;

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_CACHEUTIL", line 87

      ORA-06512: at line 1

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');

      BEGIN dbms_cacheutil.grab_readmostly(USER, 'SERV_INST'); 
      END;

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_CACHEUTIL", line 120

      ORA-06512: at line 1

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.