1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. USER_MVREF_STATS_SYS_DEFAULTS

6.525 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:

"DBA_MVREF_STATS_SYS_DEFAULTS"