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.

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
MV_OWNER VARCHAR2(128) NOT NULL Owner of the materialized view
MV_NAME VARCHAR2(128) NOT NULL Name of the materialized view
REFRESH_ID NUMBER NOT NULL The refresh ID of the refresh run
REFRESH_METHOD VARCHAR2(30)  

The refresh method used to refresh the materialized view:

  • FAST

  • PCT

  • COMPLETE

  • OUT OF PLACE FAST

  • OUT OF PLACE PCT

  • OUT OF PLACE COMPLETE
REFRESH_OPTIMIZATIONS VARCHAR2(4000)   The refresh optimization, for example, a null refresh, or a primary key/foreign key that is applied during refresh of the materialize view
ADDITIONAL_EXECUTIONS VARCHAR2(4000)   The additional executions, for example, an index rebuild, or log operations involved during refresh of the materialized view
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
INITIAL_NUM_ROWS NUMBER   Initial number of rows in the materialized view (at the start of the refresh)
FINAL_NUM_ROWS NUMBER   Final number of rows in the materialized view (at the end of the refresh)

See Also: “USER_MVREF_STATS”