| General Information |
| Note: This undocumented package contains miscellaneous cache layer PL/SQL functions |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmscu.sql |
| First Available |
11.2 |
| Dependencies |
| DBMS_ASSERT |
DBMS_OUTPUT |
SYS_DBA_SEGS |
|
| Security Model |
Execute is granted to the DBA role |
| |
| 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); |
| exec dbms_cacheutil.dissolve_affinity(USER, 'SERV_INST'); |
| |
| DISSOLVE_READMOSTLY |
Try to dissolve object readmostly in 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 RAC environment |
dbms_cacheutil.grab_affinity(
schema IN VARCHAR2,
obj IN VARCHAR2,
partition IN VARCHAR2 := NULL,
grab_index IN BOOLEAN := TRUE); |
| 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'); |
