See recommendations MetaLink Note#1031924.6
How can we find that who is using this materialized view. I had a database where MV log is created and is very big but cannot purge as I am not aware who has created. How we can say that this Log is used by which server or site
Hemant K Chitale http://hemantoracledba.blogspot.com -- //www.freelists.org/webpage/oracle-l