Verifica Views Materializadas

select MVIEW_NAME, to_char(LAST_REFRESH_DATE,'YYYY-MM-DD HH24:MI:SS') from dba_mviews;
select MVIEW_NAME, to_char(LAST_REFRESH_DATE,'YYYY-MM-DD HH24:MI:SS') from dba_mview_analysis;
select NAME, to_char(LAST_REFRESH,'YYYY-MM-DD HH24:MI:SS') from dba_mview_refresh_times;



select
    a.name
    ,b.value
    ,to_char( b.value-&V, '999,999,999,999') diff
from
    v$statname a,
    v$mystat b
where
    a.statistic# = b.statistic#
    and a.name = 'redo size'