Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The following queries can be used to determine when materialized views were last refreshed.
For all times:
1 | SQL> SELECT * FROM ALL_MVIEW_REFRESH_TIMES; |
For a specific time interval:
1 | SQL> SELECT * FROM ALL_MVIEW_REFRESH_TIMES where last_refresh between '29-OCT-10' AND '31-OCT-10'; |
1 | SQL> SELECT * FROM ALL_MVIEW_REFRESH_TIMES where last_refresh > '28-OCT-10'; |
1 2 3 4 5 6 7 | SQL> set pages 1000 SQL> set lines 1000 SQL> SELECT * FROM ALL_MVIEW_REFRESH_TIMES; OWNER NAME MASTER_OWNER MASTER LAST_REFR ------------------------------ ------------------------------ ------------------------------ ------------------------------ --------- SYSMAN MGMT_ECM_MD_ALL_TBL_COLUMNS SYSMAN MGMT_ECM_SNAPSHOT_MD_COLUMNS 05-DEC-16 |
