Materialized View Generating Huge Amount Of Redo And Archived Logs During Complete Refresh (Doc ID 2461550.1)

Last updated on APRIL 17, 2023

Applies to:

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

Goal

A Materialized View is generating a huge amount of redo data during full refresh process causing the Fast Recovery Area (FRA) to get full.

What are the options to minimize redo generation during full Materialized View refresh process?

Can atomic_refresh value be changed to false?
What are pros and cons if this feature?

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

Solution

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Materialized View Generating Huge Amount Of Redo And Archived Logs During Complete Refresh (Doc ID 2461550.1)

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!