Oracle DBMS_CACHEUTIL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
Packages
Real Application Clusters
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved