• 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

explain_rewrite from all users