DBA_MVIEW_REFRESH_TIMES

Oracle 11gR1

DBA_MVIEW_REFRESH_TIMES describes refresh times of all materialized views in the database. Its columns are the same as those in ALL_MVIEW_REFRESH_TIMES.

Related Views

· ALL_MVIEW_REFRESH_TIMES describes refresh times of the materialized views accessible to the current user.

· USER_MVIEW_REFRESH_TIMES describes refresh times of the materialized views owned by the current user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the materialized view
NAME	VARCHAR2(30)	NOT NULL	Name of the materialized view
MASTER_OWNER	VARCHAR2(30)		Owner of the master table
MASTER	VARCHAR2(30)		Name of the master table
LAST_REFRESH	DATE		The last refresh

Note:

1. Show materialized view tables and masters

select owner || '.' || name mview

, master_owner || '.' || master master

from dba_mview_refresh_times

Oracle data dictionary views

Oracle dynamic performance views