Oracle DBMS_CACHEUTIL
Version 19.3

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
AUTHID DEFINER
Dependencies
DBMS_ASSERT DBMS_OUTPUT SYS_DBA_SEGS
Documented No
First Available 11.2.0.1
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');
 
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');
 
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');
 
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');
 
LIST_READMOSTLY
List objects that have the readmostly property set dbms_cacheutil.list_readmostly;
exec dbms_cacheutil.list_readmostly;
 
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');

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

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