5.199 DBA_MVREF_STATS
DBA_MVREF_STATS
shows the REFRESH_ID
associated with each refresh run of each materialized view for the database. It also provides some basic timing statistics related to that materialized view’s refresh in that run.
Related View
USER_MVREF_STATS
shows the REFRESH_ID
associated with each refresh run of each materialized view for the database that is accessible to the current user. It also provides some basic timing statistics related to that materialized view’s refresh in that run. This view does not display the MV_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the materialized view |
|
|
|
Name of the materialized view |
|
|
|
The refresh ID of the refresh run |
|
|
|
The refresh method used to refresh the materialized view:
|
|
|
|
The refresh optimization, for example, a null refresh, or a primary key/foreign key that is applied during refresh of the materialize view |
|
|
|
The additional executions, for example, an index rebuild, or log operations involved during refresh of the materialized view |
|
|
|
Start time of the refresh run |
|
|
|
End time of the refresh run |
|
|
|
The length of time for the refresh run, in seconds |
|
|
|
Log setup time (in seconds) for the materialized view for a non-atomic refresh; |
|
|
|
Log purge time (in seconds) for the materialized view in the case of atomic refresh; |
|
|
|
Initial number of rows in the materialized view (at the start of the refresh) |
|
|
|
Final number of rows in the materialized view (at the end of the refresh) |
See Also: