Oracle DBMS_MVIEW_STATS_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
Source {ORACLE_HOME}/rdbms/admin/prvtsnap.plb
Subprograms
 
PURGE_REFRESH_STATS
Purge Materialized View Stats

This procedure is protected with an ACCESSIBLE BY clause
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_MVIEW
DBMS_MVIEW_STATS
Materialized Views
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx