6.519 USER_MVREF_STATS_SYS_DEFAULTS
USER_MVREF_STATS_SYS_DEFAULTS
displays the system-wide defaults for the refresh history statistics properties for materialized views accessible to the current user. These values can be altered with the SET_SYSTEM_DEFAULTS
procedure by a database administrator.
Its columns are the same as those in DBA_MVREF_STATS_SYS_DEFAULTS
.
This view contains exactly two rows corresponding to the collection-level and retention-period properties; their initial values are TYPICAL
and 31
respectively.
See Also: