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.
Allows a Pluggable database to modify all DBA_HIST views to obtain its data from a different source.
Owned by SYS with EXECUTE granted to the DBA role.
MODIFY_AWR_VIEW_SETTINGS (new 12.2)
Allows a Pluggable database to modify all DBA_HIST views to obtain its data from a different source
view_location IN VARCHAR2 DEFAULT 'AWR_ROOT',
recomp_objs IN BOOLEAN DEFAULT TRUE);