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

Related Topics
Built-in Functions
Built-in Packages
Real Application Clusters
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx