My Oracle Support Banner

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

Last updated on NOVEMBER 06, 2023

Applies to:

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


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?


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

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