Question: how to check mview refresh status?
Answer: SELECT.
OWNER,
MVIEW_NAME,
to_char(last_refresh_date, 'yyyymmddhh24miss') LAST_REFRESH_DATE.
FROM all_mviews.
WHERE owner = 'MY_OWNER_NAME'
AND mview_name = 'MY_MATERIALIZED_VIEW_NAME'