| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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 an Accessible By clause. |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtsnap.plb |
| Subprograms |
|
| |
| PURGE_REFRESH_STATS |
Purge Materialized View Stats
Protected by ACCESSIBLE BY clause |
dbms_mview_stats_internal.purge_refresh_stats(
mv_list IN VARCHAR2,
retention_period IN NUMBER); |
exec dbms_mview_stats_internal.purge_refresh_stats('MVSERVERS', 30);
*
PLS-00904: insufficient privilege to access object
DBMS_MVIEW_STATS_INTERNAL |
| |
| SET_MVREF_STATS_PARAMS |
| Set Materialized View Stats Collection Parameters |
dbms_mview_stats_internal.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_internal.set_system_default(
param_name IN VARCHAR2,
value IN VARCHAR2); |
| TBD |
| Overload 2 |
dbms_mview_stats_internal.set_system_default(
param_name IN VARCHAR2,
value IN NUMBER); |
| TBD |