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 package allow the user to refresh snapshots
and purge logs providing API supporting the refreshing of snapshot (materialized view) that are not part of the same refresh group and purging of MV snapshot logs.

dbms_mview is a synonym for dbms_snapshot which is the name of the actual package.

GRANT execute ON sys.RewriteMessage TO PUBLIC;
GRANT execute ON sys.RewriteArrayType TO PUBLIC;
GRANT execute ON sys.ExplainMVMessage TO PUBLIC;
GRANT execute ON sys.ExplainMVArrayType TO PUBLIC;
GRANT execute ON dbms_mview TO uwclass;

Note: You must run the utlxmv.sql script to create MV_CAPABILITIES_TABLE in the current schema prior to calling EXPLAIN_MVIEW except when you direct output to a VARRAY.
The script is found in the admin directory.

dbms_snapshot.refresh_mv(
pipename IN VARCHAR2,
mv_index IN BINARY_INTEGER,
owner IN VARCHAR2,
name IN VARCHAR2,
method IN VARCHAR2,
rollseg IN VARCHAR2,
atomic_refresh IN BINARY_INTEGER,
out_of_place IN BINARY_INTEGER,
skip_ext_data IN BINARY_INTEGER,
env IN BINARY_INTEGER,
resources IN BINARY_INTEGER DEFAULT 0,
refresh_id IN NUMBER);