| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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 |
| 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);
PL/SQL procedure successfully completed. |
| |
| 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 |