5.196 DBA_MVREF_STATS_PARAMS
DBA_MVREF_STATS_PARAMS displays the refresh statistics properties associated with each materialized view. These properties can be modified with the DBMS_MVIEW_STATS.SET_MVREF_STATS_PARAMS procedure.
Related View
USER_MVREF_STATS_PARAMS displays the refresh statistics properties associated with each materialized view accessible to the current user. These properties can be modified with the DBMS_MVIEW_STATS.SET_MVREF_STATS_PARAMS procedure.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the materialized view |
|
|
|
|
Name of the materialized view |
|
|
|
|
The collection level for the materialized view |
|
|
|
|
The retention period for the materialize view |
Note:
This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).See Also: