thanks pavb for the valuable answers....

i got the answer....

SQL> select message from rewrite_table;

MESSAGE
--------------------------------------------------------------------------------
QSM-01151: query was rewritten
QSM-01209: query rewritten with materialized view, MV_BIGTAB, using text match a
lgorithm