Table: DBA_MVIEW_REFRESH_TIMES
All fast refreshable materialized views and their last refresh times for each master table
Column Name | Description |
---|---|
LAST_REFRESH | SYSDATE from the master site at the time of the last refresh |
MASTER | Name of the master table |
MASTER_OWNER | Owner of the master table |
NAME | The view used by users and applications for viewing the MV |
OWNER | Owner of the materialized view |