Oracle DBMS_MVIEW_STATS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Collection of materialized view refresh statistics.
AUTHID DEFINER
Dependencies
DBMS_ASSERT DBMS_MVIEW_STATS_INTERNAL DBMS_UTILITY
DBMS_IREFRESH DBMS_SNAPSHOT_COMMON MVREF$_STATS_SYS_DEFAULTS
DBMS_IREFSTATS DBMS_SYS_ERROR  
Documented No
First Available 12.2.0.1
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_MVIEW
DBMS_MVIEW_STATS_INTERNAL
Materialized Views
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved