Hi, to analyze query/rewrite-problems
you can use :

DBMS_MVIEW.EXPLAIN_REWRITE (
query IN VARCHAR2,
mv IN VARCHAR2,
statement_id IN VARCHAR2);

Orca