Materialized View Refresh Status

To know the materialized view refresh status along with their refresh time, you can issue following query to the database.

SELECT mview_name, refresh_mode, refresh_method, last_refresh_type, last_refresh_date FROM user_mviews;

Also to know the materialized view logs present in schema of a user, use this query

SELECT log_owner, master, log_table FROM user_mview_logs;

Sphere: Related Content