5.198 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:

  • Y: All the statistics are available

  • N: All the statistics are not available

See Also:

"USER_MVREF_RUN_STATS"