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 188.8.131.52 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