5.200 DBA_MVREF_RUN_STATS
DBA_MVREF_RUN_STATS
has information about each refresh run for all the materialized views for the database, with each run being identified by the REFRESH_ID
. The information includes timing statistics related to the run and the parameters specified in that run.
Related View
USER_MVREF_RUN_STATS
has information about each refresh run for the materialized views accessible for the current database user, with each run being identified by the REFRESH_ID
. The information includes timing statistics related to the run and the parameters specified in that run. This view does not display the RUN_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the refresh operation (the user who launched the operation) |
|
|
|
The refresh ID of the refresh run |
|
|
|
The number of materialized views being refreshed in the run |
|
|
|
Shows the list of comma separated parameters specified in the API for the materialized view refresh operation |
|
|
|
For internal use only |
|
|
|
The |
|
|
|
The |
|
|
|
The |
|
|
|
The |
|
|
|
The |
|
|
|
The |
|
|
|
The |
|
|
|
The |
|
|
|
The |
|
|
|
The |
|
|
|
The number of failures that occurred in processing the API |
|
|
|
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; |
|
|
|
Indicates whether all the complete refresh statistics are available for this run:
|
See Also: