• How to “MAX” out your Fast Refresh Materialized Views - Blue Gecko
  DBMS_ADVISOR.TUNE_MVIEW,
  in Oracle > DB 11g with dbms_advisor materialized max mv tune tune_mview view views
• Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites
  Use 11g packages in DBMS_MVIEW to see how the SQL query transformed or rewritten to use materialized view instead
  in Oracle > Optimization with and dbms_mview explain_rewrite materialized mv tune_mview view views

tune_mview from all users