DBA_AUTO_MV_REFRESH_HISTORY

DBA_AUTO_MV_REFRESH_HISTORY describes automatic materialized view refreshes.

Column Datatype NULL Description
MVIEW_OWNER VARCHAR2(128) NOT NULL Owner of the materialized view
MVIEW_NAME VARCHAR2(128) NOT NULL Name of the materialized view
SWAT_MM_START_TIME DATE   Date and time of the maintenance invocation
REFRESH_START_TIME DATE   Date and time the refresh started
REFRESH_END_TIME DATE   Date and time the refresh ended
ELAPSED_REFRESH_TIME NUMBER   Duration of the refresh (in seconds)
STATUS NUMBER  

Status of the refresh. Possible values:

  • 0 - The refresh is in-progress

  • 1 - The refresh completed successfully

  • 2 - An error occurred during the refresh. Refer to the value of the ERROR column for more information.

  • 3 - The refresh was terminated

ERROR NUMBER   If an error occurred during the refresh, this column displays the error number, which corresponds to error code ORA-number. Otherwise, the value of this column is 0.