Mview Log – Size Increasing !!!!!

Recently while checking the segment's size for a particular schema, i noticed a materialized view log (MLOG$_TABLE_NAME) occupying almost 10Gb of space. What is materialized view log? From the Oracle document :- When DML changes are made to master table data, Oracle Database stores rows describing those changes in the materialized view log and then … Continue reading Mview Log – Size Increasing !!!!!