The LAST_REFRESH_DATE column of the DBA_MVIEWS or the LAST_REFRESH column of the DBA_MVIEW_REFRESH_TIMES indicates the start refresh time. But what if we’d like to find out how long the refresh of the materialized view really takes. Well, we can query the DBA_MVIEW_ANALYSIS. For Complete Refresh, the refresh duration will be in the FULLREFRESHTIM column of […]
This is a good Metalink document for troubleshooting issues with creation or refresh or maintenance of materialized views. MVIEW ‘ORA-‘ error diagnosis. For Materialized View CREATE or REFRESH (Doc ID 1087507.1) The diagnostic is listed by the MView’s ORA errors.