1. Materialized Views should be created with full refresh options.
2. Tables on which Materialized Views are based should be in nologging mode.
3. Indexes should be disabled on base tables on which M Views are created.
4. Better option to minimize redolog genaration is to use a custom job to refresh the MV, steps to this can be
a) disable indexes
b) call refresh
c) rebuild indexes with no logging
Never stop learning, because life never stops teaching.
No comments:
Post a Comment