SQL> select count(*) from mlog$_adp_ctm_log;
COUNT(*)
----------
0
SQL> select MVIEW_NAME, to_char(LAST_REFRESH_DATE,'dd-mm-yyyy hh24:mi:ss') from user_mviews where mview_name = 'ADP_CTM_LOG_MV';
MVIEW_NAME TO_CHAR(LAST_REFRES
------------------------------ -------------------
ADP_CTM_LOG_MV 20-02-2012 11:33:31
SQL> update adp_ctm_log set response_min_last_update_date =sysdate +3 where log_pk=17;
1 row updated.
SQL> commit;
SQL> select * from ADP_CTM_LOG_MV;
COUNT(*) OFFICE_BIC_CODE RESPONSE_
---------- ---------------- ---------
1 TEST1 23-FEB-12
-- Check MV's LAST_REFRESH_DATE.
SQL> select MVIEW_NAME, to_char(LAST_REFRESH_DATE,'dd-mm-yyyy hh24:mi:ss') from user_mviews where mview_name = 'ADP_CTM_LOG_MV';
MVIEW_NAME TO_CHAR(LAST_REFRES
------------------------------ -------------------
ADP_CTM_LOG_MV 20-02-2012 11:35:14
SQL>
-- See that it has changed; that means ON COMMIT MVIEW has refreshed successfully after the last update (and commit) statement.