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 |
|---|---|---|---|
RUN_OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the refresh operation (the user who launched the operation) |
REFRESH_ID |
NUMBER |
NOT NULL |
The refresh ID of the refresh run |
NUM_MVS |
NUMBER |
NOT NULL |
The number of materialized views being refreshed in the run |
MVIEWS |
VARCHAR2(4000) |
Shows the list of comma separated parameters specified in the API for the materialized view refresh operation | |
BASE_TABLES |
VARCHAR2(4000) |
For internal use only | |
METHOD |
VARCHAR2(4000) |
The METHOD parameter specified by the API |
|
ROLLBACK_SEG |
VARCHAR2(4000) |
The ROLLBACK_SEG parameter specified by the API |
|
PUSH_DEFERRED_RPC |
CHAR(1) |
The PUSH_DEFERRED_RPC parameter specified by the API |
|
REFRESH_AFTER_ERRORS |
CHAR(1) |
The REFRESH_AFTER_ERRORS parameter specified by the API |
|
PURGE_OPTION |
NUMBER |
The PURGE_OPTION parameter specified by the API |
|
PARALLELISM |
NUMBER |
The PARALLELISM parameter specified by the API |
|
HEAP_SIZE |
NUMBER |
The HEAP_SIZE parameter specified by the API |
|
ATOMIC_REFRESH |
CHAR(1) |
The ATOMIC_REFRESH parameter specified by the API |
|
NESTED |
CHAR(1) |
The NESTED parameter specified by the API |
|
OUT_OF_PLACE |
CHAR(1) |
The OUT_OF_PLACE parameter specified by the API |
|
NUMBER_OF_FAILURES |
NUMBER |
The number of failures that occurred in processing the API | |
START_TIME |
TIMESTAMP(6) |
Start time of the refresh run | |
END_TIME |
TIMESTAMP(6) |
End time of the refresh run | |
ELAPSED TIME |
NUMBER |
The length of time for the refresh run, in seconds | |
LOG_SETUP_TIME |
NUMBER |
Log setup time (in seconds) for the materialized view for a non-atomic refresh; NULL for an atomic refresh |
|
LOG_PURGE_TIME |
NUMBER |
Log purge time (in seconds) for the materialized view in the case of atomic refresh; NULL in the case of non-atomic refresh |
|
COMPLETE_STATS_AVAILABLE |
CHAR(1) |
Indicates whether all the complete refresh statistics are available for this run:
|
See Also: “USER_MVREF_RUN_STATS”