Status of MVIEW ( Is refreshing or working ok? )
How to see if a MVIEW stops working or updates or refreshing ?
In alert Logfile occur following meessages
MV OWNER.MVIEW_NAME was not refreshed successfully.
Number of MV refresh failures: 1.
1. Check, if status VALID ?
select object_name, OBJECT_TYPE, status from user_objects where object_type='MATERIALIZED VIEW';
2. Check ALL_MVIEWS Column LAST_REFRESH_DATE a good starting point, but if you were checking with today's date, you'd have to include intervals as well.
Column AFTER_FAST_REFRESH ?