Oracle | DBMS_MVIEW

Oracle DBMS_MVIEW_STATS Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Collection of materialized view refresh statistics.

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_MVIEW_STATS_INTERNAL	DBMS_SYS_ERROR
DBMS_IREFRESH	DBMS_SNAPSHOT_COMMON	DBMS_UTILITY
DBMS_IREFSTATS

Documented Yes: Packages and Types Reference

First Available 12.2

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvtsnap.plb

Subprograms

PURGE_REFRESH_STATS

SET_MVREF_STATS_PARAMS

SET_SYSTEM_DEFAULT

PURGE_REFRESH_STATS

Purge Materialized View Stats dbms_mview_stats.purge_refresh_stats( mv_list IN VARCHAR2, retention_period IN NUMBER);

exec dbms_mview_stats.purge_refresh_stats('MVSERVERS', 30);

SET_MVREF_STATS_PARAMS

Set Materialized View Stats Collection Parameters dbms_mview_stats.set_mvref_stats_params( mv_list IN VARCHAR2, collection_level IN VARCHAR2, retention_period IN NUMBER);

TBD

SET_SYSTEM_DEFAULT

Set Stats Collection System Defaults

Overload 1 dbms_mview_stats.set_system_default( param_name IN VARCHAR2, value IN VARCHAR2);

TBD

Overload 2 dbms_mview_stats.set_system_default( param_name IN VARCHAR2, value IN NUMBER);

TBD