I have materialized views identified in the dba_refresh_children view as part of a single refresh group, all with next_date values of earlier today ("2017/09/23 05:00:00").
But all_mviews.last_refresh_date does not reflect the refresh happening with most views having null for this value because they are new (and they are defined as build deferred and recompiled yesterday). those views are not returning data. old views show an old date.
dba_jobs shows a last_date of null, next_date of "2017/09/23 05:00:00" and an interval of "TRUNC(sysdate) + 1 + 5/24".
So essentially, dba_refresh_children.next_date has passed 12 hours ago and they have not refreshed.
where do I look to determine what the issue is?
thanks for your responses.