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.
Undocumented and following its action using 10046 and 10053 traces did not provide sufficient clarity to know how and when it is expected to function.
The following was found in $ORACLE_HOME/rdbms/admin/dbmsspu.sql in reference to Big Data space alerts.
-- TBD: setup remote db link when supported
--drop public database link hub;
--create public database link hub connect to system identified by
-- manager using 'inst1';