1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
  4. DBA_MVREF_STATS_SYS_DEFAULTS

5.201 DBA_MVREF_STATS_SYS_DEFAULTS

DBA_MVREF_STATS_SYS_DEFAULTS displays the system-wide defaults for the refresh history statistics properties for materialized views. These values can be altered with the SET_SYSTEM_DEFAULTS procedure by a database administrator.

Related View

This view contains exactly two rows corresponding to the collection-level and retention-period properties; their initial values are TYPICAL and 31 respectively.

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.

Column Datatype NULL Description

PARAMETER_NAME

CHAR(16)

Value of the parameter_name parameter:

  • COLLECTION_LEVEL

  • RETENTION_PERIOD

VALUE

VARCHAR2(40)

The system-wide default value for the parameter

See Also:

"USER_MVREF_STATS_SYS_DEFAULTS"