For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
Purpose
This undocumented package contains miscellaneous cache layer PL/SQL functions
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);
dbms_cacheutil.grab_affinity(
schema IN VARCHAR2,
obj IN VARCHAR2,
partition IN VARCHAR2 := NULL,
grab_index IN BOOLEAN := TRUE,
active_drm IN BOOLEAN := FALSE);