Can Redo Generation Be Disabled During Materialized View Refresh (Doc ID 334878.1)

In this Document

Goal

Fix

References

---

APPLIES TO:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

GOAL

Can redo generation be disabled during a complete refresh of a materialized view ?

FIX

There is no way to turn off redo generation when refreshing materialized views.

Setting the NOLOGGING option during the materialized view creation does not affect this, as the option only applies during the actual creation and not to any subsequent actions on the materialized view. 

Enhancement requests have been  raised to be able to turn off redo generation during a refresh but these were rejected as this could put the database into an inconsistent state and affect options such as DataGuard as well as backup and recovery.

The amount of redo generated can be reduced by setting ATOMIC_REFRESH=FALSE in the DBMS_MVIEW.REFRESH options.

See the following documentation for more details -

Oracle9i Replication Management API Reference Release 2 (9.2)

PL/SQL Packages and Types Reference 10g Release 2 (10.2)

PL/SQL Packages and Types Reference 11g Release 1 (11.1.)

REFERENCES

NOTE:258252.1 - MATERIALIZED VIEW REFRESH: Locking, Performance, Monitoring
NOTE:413188.1 - Complete Materialized View Refresh Generates Lots Of Archive Logs and Rollback/Undo Activity