Oracle | DBMS_MVIEW_STATS

Oracle DBMS_MVIEW_STATS_INTERNAL Version 21c

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 DEFINER

Dependencies

ALL_MVIEWS	DBMS_MVIEW_STATS	DUAL
DBMS_ASSERT	DBMS_SYS_ERROR	MVREF$_STATS_PARAMS
DBMS_IREFRESH	DBMS_UTILITY	MVREF$_STATS_SYS_DEFAULTS
DBMS_IREFSTATS

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted

Direct access to this package is prevented by means of an Accessible By clause.

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);

      BEGIN 
      dbms_mview_stats.purge_refresh_stats('MVSERVERS', 30); END;

      *

      ERROR at line 1:

      ORA-20000: ORA-01031: insufficient privileges

      ORA-06512: at "SYS.DBMS_IREFRESH", line 186

      ORA-06512: at "SYS.DBMS_MVIEW_STATS", line 44

      ORA-06512: at "SYS.DBMS_MVIEW_STATS", line 60

      ORA-06512: at line 1

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