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 but related to snapshot replication triggers
Synchronizes the existence of an internal trigger with a table or materialized view in the replication catalog. If the table or materialized view has replication support, then execute this procedure to create the internal replication trigger.
If replication support does not exist, then this procedure destroys any related internal trigger.
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
conn sys@pdbdev as sysdba
CREATE MATERIALIZED VIEW uwclass.mv_force
REFRESH FORCE ON DEMAND
WITH ROWID AS
SELECT * FROM servers;