SQL>SELECT OWNER, MVIEW_NAME, REFRESH_MODE, REFRESH_METHOD, TO_CHAR(LAST_REFRESH_END_TIME,'YYYYMMDD-HH24:MI:SS'), STALENESS FROM DBA_MVIEWS;
SQL>SELECT OWNER, MVIEW_NAME, REFRESH_MODE, REFRESH_METHOD, TO_CHAR(LAST_REFRESH_END_TIME,'YYYYMMDD-HH24:MI:SS'), STALENESS FROM DBA_MVIEWS;