Hai Everybody.
I have a big problem. I mean our database had redologs of 180MB each and usually only 5 or 6 archivelogs are produced daily. Yesterday, suddenly more than 30GB of archivelogs are produced. One of my colleague said it may be due to Materialized Views. Actually yesterday they did lot of testing activity but they said that the data size that they ised for testins is small. I would like to know if really Materialized Views are increasing archive logs, how to check and reduce that. Please help me..

Dileep.